How to convert Key value pairs into separate columns

Pavithra52 — Sat, 16 Nov 2024 02:08:29 GMT

I have HBase table where one column consists of key value pairs, I want that key value pairs as separate columns(Based on Keys).

example :

INPUT :

Alert_type(Column name) :

{'name': 'xxx', 'id' : '05'}

{'name': 'yyy', 'id' : '06'}

OUTPUT:

name id

xxx 05

yyy 06

Please kindly help me with this.

Thanks in advance.

Re: How to convert Key value pairs into separate columns

manodwhb — Tue, 16 Jun 2020 09:12:55 GMT

@Pavithra52 , you need to use tExtractJsonFields.

check the below link to know more about it.