Hive queries returning all NULL values.

[Tor Ivry]

Hi



I have a hive (0.11) table with the following create syntax:



CREATE EXTERNAL TABLE events(

…

)

PARTITIONED BY(dt string)

  ROW FORMAT SERDE 'parquet.hive.serde.ParquetHiveSerDe'

  STORED AS

    INPUTFORMAT "parquet.hive.DeprecatedParquetInputFormat"

    OUTPUTFORMAT "parquet.hive.DeprecatedParquetOutputFormat"

    LOCATION '/data-events/success’;



Query runs fine.


I add hdfs partitions (containing snappy.parquet files).



When I run

hive

> select count(*) from events where dt=“20140815”

I get the correct result



*Problem:*

When I run

hive

> select * from events where dt=“20140815” limit 1;

I get

OK

NULL NULL NULL NULL NULL NULL NULL 20140815



*The same query in Impala returns the correct values.*



Any idea what could be the issue?



Thanks

Tor