Re: Hive queries returning all NULL values.

2014-08-26 Thread Tor Ivry
e a small set of data like 2-5 line and insert it... >> >> After that you can try insert first 10 column and then next 10 till you >> fund your problematic column >> On Aug 17, 2014 8:37 PM, "Tor Ivry" wrote: >> >>> Is there any way to debug t

Re: Hive queries returning all NULL values.

2014-08-17 Thread Tor Ivry
ata in files. > > Thanks > Vikas Srivastava > On Aug 17, 2014 7:07 PM, "Tor Ivry" wrote: > >> Hi >> >> >> >> I have a hive (0.11) table with the following create syntax: >> >> >> >> CREATE EXTE

Hive queries returning all NULL values.

2014-08-17 Thread 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.De

Hive queries returning all NULL values.

2014-08-17 Thread 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.De

Hive queries returning all NULL values.

2014-08-17 Thread 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.De