Hi Sharath Glad that it worked. From HIVE-10592 you just need the changes from ColumnStatisticsImpl.java, rest of the patch is irrelevant for this issue.
Thanks Prasanth _____________________________ From: Sharath Babu Basavaraja <sharathfe...@gmail.com<mailto:sharathfe...@gmail.com>> Sent: Friday, June 10, 2016 10:32 AM Subject: Re: NPE while querying timestamp data type in ORC tables To: <user@hive.apache.org<mailto:user@hive.apache.org>> Cc: Prasanth Jayachandran <pjayachand...@hortonworks.com<mailto:pjayachand...@hortonworks.com>> 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 Jayachandran <pjayachand...@hortonworks.com<mailto:pjayachand...@hortonworks.com>> wrote: 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 per stripe are null. If at least one non-null value exist for timestamp column per stripe then this should not happen. Thanks Prasanth On Jun 8, 2016, at 4:13 PM, Sharath Babu Basavaraja <sharathfe...@gmail.com<mailto:sharathfe...@gmail.com>> wrote: 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 timestamp values checking if it is null? Regards, Sharath
