Linking to the hive its not working

Technical Discussions Hive
#1

CREATE EXTERNAL TABLE movieapp_logs
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’

#2

Hi Shraddha,

Could you help us understand what error are you facing?

#3

@shraddha,

The version of Hive available in Cloudxlab supports Avro SerDe inbuilt, no need to mention Row format, InputFormat & OutputFormat SerDe, seperately, try below method to create Hive table in Avro format.

CREATE TABLE movieapp_logs ROW FORMAT DELIMITED FIELDS TERMINATED BY ‘,’ STORED AS AVRO;