当我们为avro文件格式创建配置单元表时,在检查desc表时不会显示注解。它显示为
“来自反序列化程序”
表ddl:
CREATE EXTERNAL TABLE bs_rev_profit_by_campaign
(revenue DOUBLE, grossprofit DOUBLE, campaignName STRING)
COMMENT "A table backed by Avro data with the Avro schema embedded in the CREATE TABLE statement"
ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.avro.AvroSerDe'
STORED AS INPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerInputFormat'
OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerOutputFormat'
LOCATION '/home/biadmin/test_data/avro/'
TBLPROPERTIES
('avro.schema.literal'=
'{"type": "record","name": "TUPLE_3",
"fields": [
{"name": "Revenue","type": ["null", "double" ],"doc": "autogenerated from Pig Field Schema"},
{"name": "GrossProfit","type": ["null", "double" ],"doc": "autogenerated from Pig Field Schema"},
{"name": "CampaignName", "type": ["null", "string" ],"doc": "autogenerated from Pig Field Schema"} ]}'
);
我们正在使用Hive1.1。有人能帮我知道原因吗。
暂无答案!
目前还没有任何答案,快来回答吧!