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
