1

Can someone point in the doc to create external table on qubole base on avro files? 

CREATE TABLE my_table_name
 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 's3://my_avro_files/'

The following directory have a bunch of avro files

s3://my_avro_files/

s3://my_avro_files/file1.avro
s3://my_avro_files/file2.avro
s3://my_avro_files/file....avro
user10714010
  • 865
  • 2
  • 13
  • 20

1 Answers1

0

I believe you need to provide the schema as well. Please see here for details on how to extract it and specify in the create table statement.

Hariharan Iyer
  • 36
  • 4