Re: External table with Avro Serde

2013-09-23 Thread Sravya Tirukkovalur
Thank you, that was helpful! On Sat, Sep 21, 2013 at 7:02 PM, j.barrett Strausser < j.barrett.straus...@gmail.com> wrote: > Fairly sure you just forgot the 'Stored As' clause. > > The below works for me on .11 > > CREATE EXTERNAL TABLE avrotab > PARTITIONED BY(dq_dummy int) > ROW FORMAT SERDE 'o

Re: External table with Avro Serde

2013-09-21 Thread j.barrett Strausser
Fairly sure you just forgot the 'Stored As' clause. The below works for me on .11 CREATE EXTERNAL TABLE avrotab PARTITIONED BY(dq_dummy int) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.avro.AvroSerDe' STORED AS INPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerInputFormat' OUTPUTFOR

External table with Avro Serde

2013-09-21 Thread Sravya Tirukkovalur
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.AvroC