Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 !
This should get you what you're looking for
@Daniel Evans Thank you so much 😊