hadoop - write json data from hive to local file -


this query in hive

select colname uber_test; ok {"data":"{\"age\":42, \"gender\":\"male\"}"} 

this how export data:

    create table export_test_1( name string) row format delimited fields terminated ',' stored textfile;     insert overwrite local directory 'export_test_1' row format delimited fields terminated ',' select colname uber_test; 

this data looks after export:

more export_test_2/000000_0  data{"age":42, "gender":"male"} 

i need preserve json. needs be:

 {"data":"{\"age\":42, \"gender\":\"male\"}"} 


Comments

Popular posts from this blog

sql - Time in datatime field -

javascript - How to split the success output from an Ajax post? -

java - sharing object across different classes -