Hive table properties

[#1]

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.

[#2]

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.