Re: NPE while querying timestamp data type in ORC tables

2016-06-10 Thread Prasanth Jayachandran
016 10:32 AM Subject: Re: NPE while querying timestamp data type in ORC tables To: mailto:user@hive.apache.org>> Cc: Prasanth Jayachandran mailto:pjayachand...@hortonworks.com>> Thanks Prasanth. The work-around which you suggested worked for me. But since the table is pretty huge, th

Re: NPE while querying timestamp data type in ORC tables

2016-06-10 Thread Sharath Babu Basavaraja
Thanks Prasanth. The work-around which you suggested worked for me. But since the table is pretty huge, this seems to have a performance issues on the query time. Can I try applying this patch to fix this issue as provided in JIRA-10592. Regards, Sharath On 8 June 2016 at 16:18, Prasanth Jayacha

Re: NPE while querying timestamp data type in ORC tables

2016-06-08 Thread Prasanth Jayachandran
Hi This is a known issue and is fixed as part of https://issues.apache.org/jira/browse/HIVE-10592 Workaround is to set hive.optimize.index.filter=false but this will disable predicate pushdown and will have performance impact. This issue can happen when all the values in the timestamp column pe

NPE while querying timestamp data type in ORC tables

2016-06-08 Thread Sharath Babu Basavaraja
Hi all, I have a ORC Hive table with multiple columns. One of the column data type (say column1) is of type timestamp. When I make a query 'select * from table_name where column1 is null;', I get Null Pointer Exception. Has anyone faced similar issue when you are making similar queries on timesta