Support Questions
Find answers, ask questions, and share your expertise
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Hive table properties


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.




Re: Hive table properties

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.
Don't have an account?
Coming from Hortonworks? Activate your account here