How to extract key value pairs using tExtractJsonFields

[Pavithra52]

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 !

[evansdar · Accepted solution]

This should get you what you're looking for

[Pavithra52]

@Daniel Evans​ Thank you so much 😊