title: Hive table for an external Snappy avro data shows compression is false
body: <p>Imported single table using sqoop</p>
  
  <pre><code>...
  --as-avrodatafile
  --compression-codec ...SnappyCodec
  ...
  </code></pre>
  
  <p>Viewing in Hue file browser confirms that it is compressed by displaying a message <code>Output rendered from compressed avro file.</code></p>
  
  <p>Created external table in Hive as</p>
  
  <pre><code>create external table customers_avro
  stored as avro
  location '.../path/'
  tblproperties('avro.schema.file'='/path/to/customers.avsc')
  </code></pre>
  
  <p>However, when querying with <code>describe extended tblname</code> shows <code>compressed:false</code></p>
  
  <pre><code>...
  inputFormat:org.apache.hadoop.hive.ql.io.avro.AvroContainerInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.avro.AvroContainerOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.avro.AvroSerDe, parameters:{serialization.format=1})...
  </code></pre>
  
  <p>Is there any other property that needs to be set with <code>tblproperties</code>?</p>