hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sravya Tirukkovalur <sra...@cloudera.com>
Subject External table with Avro Serde
Date Sun, 22 Sep 2013 01:41:52 GMT
This command fails:

CREATE EXTERNAL TABLE avrotab
PARTITIONED BY(dummy int)
LOCATION '/user/user1/avrodata'
ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.avro.AvroSerDe'
INPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerInputFormat'
OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerOutputFormat'
TBLPROPERTIES ( 'avro.schema.url'='file:///tmp/data.avsc');

Error:
Error: Error while processing statement: FAILED: ParseException line 1:131
missing EOF at 'ROW' near ''/user/user1/avrodata'' (state=42000,code=40000)

Not sure what I am missing. Can anyone see any obvious mistake?

Thanks!
-- 
Sravya Tirukkovalur

Mime
View raw message