Create Avro Hive table from S3 bucket
<pre><code>    I have a S3 bucket which contains data in day wise partitions. Each of the partition contains a days worth of data in Avro format .I need to load this data into a hive table.
    How can I create a partitioned Avro hive table to store data for last 90 days.

    I tried the below create table command
   table creation command

    hive&gt; CREATE EXTERNAL TABLE fxgm_avro
        &gt;   PARTITIONED BY (dt string)
        &gt;   ROW FORMAT SERDE
        &gt;   'org.apache.hadoop.hive.serde2.avro.AvroSerDe'
        &gt;   STORED AS INPUTFORMAT
        &gt;   'org.apache.hadoop.hive.ql.io.avro.AvroContainerInputFormat'
        &gt;   OUTPUTFORMAT
        &gt;   'org.apache.hadoop.hive.ql.io.avro.AvroContainerOutputFormat'
        &gt;   LOCATION 's3://glbl_mkts/fxgm/bkt%3Dkinesis_fxgm_logs/format%3Davro/dt%3D2016-01-12/part-r-00000.avro'
        &gt;   TBLPROPERTIES (
        &gt;     'avro.schema.url'='file://fxgm_avr/fxgm.avsc');
    OK
    Time taken: 3.535 seconds
</code></pre>

<p>ON selecting from the table no record is selected
        hive> select * from fxgm_avro limit 10;
        OK
        Time taken: 0.473 seconds</p>

<pre><code>    When I tried to select from the table, no records is selected.
    I wonder this is the correct way or something I am missing.
</code></pre>