Reply
Explorer
Posts: 13
Registered: ‎10-21-2018

Hive table properties

I have uploaded a flatfile as a table using hive(ambari) and selected "stored as" field avro.

 will this generate avsc or avro format files by doing this. If so what is the location.

 

 

Posts: 1,754
Kudos: 371
Solutions: 279
Registered: ‎07-31-2013

Re: Hive table properties

No, STORED AS AVRO will dynamically convert your table column metadata
information to a schema at runtime.

In general if you have avro converted files under the table directory, you
can use 'hadoop jar /opt/cloudera/parcels/CDH/lib/avro/avro-tools.jar
getschema hdfs://path/to/file.avro to fetch its generated schema.
Announcements
New solutions