如何使用JSON模式覆盖插入目录?
有一个原始的Hive Avro表; (实际上有许多字段)
tb_test--------
name string
kickname string
-----------------
那我想通过使用jsonserde将查询结果保存到HDFS的某个目录中。
我尝试了这个。
insert overwrite directory '/json/'
ROW FORMAT SERDE 'org.apache.hive.hcatalog.data.JsonSerDe'
WITH SERDEPROPERTIES (
"stat_name"="$._col0",
"stat_interval"="$._col1"
)
STORED AS TEXTFILE
select name, nickname
from tb_test limit 100
但是在/json/中写入的json文件中,字段名_colXX代替了原始字段名。
{"_col0":"basic_qv"," _col1":"h"}
{"_col0":"basic_qv","_col1 ":"h"}
{"_col0":"basic_qv","_col1 ":"h"}
{"_col0":"basic_qv"," _col1":"h"}
{"_col0":"basic_qv","_col1 ":"h"}
我期待的{"name":"basic_qv","nickname":"h"}
{"name":"basic_qv","nickname":"h"}
{"name":"basic_qv","nickname":"h"}
{"name":"basic_qv","nickname":"h"}
{"name":"basic_qv","nickname":"h"}
什么可以帮助这个问题?
谢谢!