title: Create hive table for schema less avro files
body: <p>I have multiple  avro files and each file have a STRING in it. Each avro file is a single row. How can I write hive table to consume all the avro files located in a single directory .
  Each file has a big number in it and hence I do not have any json kind of schema that I can relate too. I might be wrong when I say schema less . But I cannot find a way for hive to understand this data. This might be very simple but I am lost since I tried numerous different ways without success. I created tables pointing to json schema as avro uri, but this is not the case here. 
  For more context files were written using crunch api</p>
  
  <pre><code>final Path outcomesVersionPath = ...
  pipeline.write(fruit.keys(), To.avroFile(outcomesVersionPath));
  </code></pre>
  
  <p>I tried following query which creates table but does not read data properly</p>
  
  <pre><code>CREATE EXTERNAL TABLE test_table
  ROW FORMAT
  SERDE 'org.apache.hadoop.hive.serde2.avro.AvroSerDe'
  STORED AS
  INPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerInputFormat'
  OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerOutputFormat'
  LOCATION 'hdfs:///somePath/directory_with_Ids'
  </code></pre>