title: How to create external tables from parquet files in s3 using hive 1.2?
body: <p>I have created an external table in Qubole(Hive) which reads parquet(compressed: snappy) files from s3, but on performing a <code>SELECT * table_name</code> <em>I am getting null values for all columns except the partitioned column</em>.</p>
  
  <p>I tried using different serialization.format values in SERDEPROPERTIES, but I am still facing the same issue. 
  And on removing the property <code>'serialization.format' = '1'</code> I am getting <code>ERROR: Failed with exception java.io.IOException:Can not read value at 0 in block -1 in file s3://path_to_parquet/</code>.</p>
  
  <p>I checked the parquet files and was able to read the data using parquet-tools:</p>
  
  <pre><code>**file_01.snappy.parquet:**
  {"col_2":1234,"col_3":ABC}
  {"col_2":124,"col_3":FHK}
  {"col_2":12515,"col_3":UPO}
  
  
  **External table stmt:**
  CREATE EXTERNAL TABLE parquet_test
  (
      col2 int,
      col3 string
  )
  PARTITIONED BY (col1 date) 
  ROW FORMAT SERDE 'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'
  WITH SERDEPROPERTIES (
    'serialization.format' = '1'
  )
  STORED AS PARQUET
  LOCATION 's3://path_to_parquet'
  TBLPROPERTIES ('parquet.compress'='SNAPPY');
  
  Result:
  col_1   col_2   col_3
  5/3/19  NULL    NULL
  5/4/19  NULL    NULL
  5/5/19  NULL    NULL
  5/6/19  NULL    NULL
  
  Expected Result:
  col_1   col_2   col_3
  5/3/19  1234    ABC
  5/4/19  124     FHK
  5/5/19  12515   UPO
  5/6/19  1234    ABC
  </code></pre>