CODE EXAMPLE FOR JAVASCRIPT

get data from json key with special character

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