hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tor Ivry <tork...@gmail.com>
Subject Hive queries returning all NULL values.
Date Sun, 17 Aug 2014 12:13:18 GMT
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

Mime
View raw message