How to extract key value pairs using tExtractJsonFields

Pavithra52 — Sat, 16 Nov 2024 01:50:27 GMT

Hi,

I have data in HBase. While retrieving data, In one table , a column contains

key value pairs The key value pairs are like :

{'id': '60946a0a', 'first_name': 'fred', 'last_name': 'tyler', 'email': 'admin@abc.com', 'name': 'fred tyler'}

{'id': '413d67', 'first_name': 'jackson', 'last_name': 'roy', 'email': 'admin@def.com', 'name': 'jackson roy'}

{'name': 'john abraham', 'first_name': 'john', 'last_name': 'abraham', 'id': '8b41f9i8', 'email': 'admin@ghicom'}

{'id': '60946', 'first_name': 'george', 'last_name': 'paul', 'email': 'admin@jkl.com', 'name': 'john paul'}

I want to retrieve this as separate columns :

name, first_name, last_name, id, email

'name' 'first_name' 'last_name' 'id' 'email'

fred tyler fred tyler 60946a0a admin@abc.com

jackson roy jackson roy 413d67 admin@def.com

john abraham john abraham 8b41f9i8 admin@ghi.com

george paul george paul 60946 admin@jkl.com

Does anyone have idea on how to achieve this?

Thanks in advance !

Re: How to extract key value pairs using tExtractJsonFields

evansdar — Tue, 21 Jul 2020 15:05:36 GMT

This should get you what you're looking for

Pavithra52 — Wed, 22 Jul 2020 04:31:12 GMT

@Daniel Evans Thank you so much 😊