Posts: 14
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,903
Kudos: 435
Solutions: 305
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.