get data from json key with special character

Amandeep Singh answered on July 13, 2022 Popularity 4/10 Helpfulness 1/10

answer get data from json key with special character

Comment

hive> select get_json_object(regexp_replace(jsn,'@',''),"$.date") from (select string('{"name":"jai","@date":"2015-06-15"}')jsn)t;
2015-06-15

Popularity 4/10 Helpfulness 1/10 Language javascript

Tags: character get javascript json key

Link to this answer
Share Copy Link

Contributed on Jul 13 2022

Amandeep Singh

0 Answers Avg Quality 2/10

Oops, You will need to install Grepper and log-in to perform this action.