Support Questions
Find answers, ask questions, and share your expertise

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.




Master Guru
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.