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