Ashish Kumar created HIVE-14510:
-----------------------------------
Summary: Hive query failing because of unavailable partition
Key: HIVE-14510
URL: https://issues.apache.org/jira/browse/HIVE-14510
Project: Hive
Issue Type: Bug
Reporter: Ashish Kumar
I'm trying to run below query with Hive on TEZ and getting some partition
issue. The same query is working fine with MR engine. Used table is external
one and having partitions on year and month columns.
Hive Version 1.2
Format ORC
*Query:*
*select count(crn) as bookings,
month(to_date(from_utc_timestamp(pickup_date,'IST'))) as month from
bookings_table and year=2016 group by
month(to_date(from_utc_timestamp(pickup_date,'IST')));*
*Error:*
Caused by: org.apache.hadoop.hive.ql.metadata.HiveException:
java.io.IOException: java.io.IOException: While processing file
s3n://<bucket>/warehouse/bookings_table/year=2016/month=1. null
at
org.apache.hadoop.hive.ql.exec.tez.MapRecordSource.pushRecord(MapRecordSource.java:78)
at
org.apache.hadoop.hive.ql.exec.tez.MapRecordProcessor.run(MapRecordProcessor.java:292)
at
org.apache.hadoop.hive.ql.exec.tez.TezProcessor.initializeAndRunProcessor(TezProcessor.java:148)
... 14 more
Caused by: java.io.IOException: java.io.IOException: While processing file
s3n://<bucket>/warehouse/bookings_table/year=2016/month=1. null
at
org.apache.hadoop.hive.io.HiveIOExceptionHandlerChain.handleRecordReaderNextException(HiveIOExceptionHandlerChain.java:121)
at
org.apache.hadoop.hive.io.HiveIOExceptionHandlerUtil.handleRecordReaderNextException(HiveIOExceptionHandlerUtil.java:77)
at
org.apache.hadoop.hive.ql.io.HiveContextAwareRecordReader.doNext(HiveContextAwareRecordReader.java:372)
at
org.apache.hadoop.hive.ql.io.HiveRecordReader.doNext(HiveRecordReader.java:79)
at
org.apache.hadoop.hive.ql.io.HiveRecordReader.doNext(HiveRecordReader.java:33)
at
org.apache.hadoop.hive.ql.io.HiveContextAwareRecordReader.next(HiveContextAwareRecordReader.java:118)
at
org.apache.hadoop.mapred.split.TezGroupedSplitsInputFormat$TezGroupedSplitsRecordReader.next(TezGroupedSplitsInputFormat.java:137)
at org.apache.tez.mapreduce.lib.MRReaderMapred.next(MRReaderMapred.java:113)
at
org.apache.hadoop.hive.ql.exec.tez.MapRecordSource.pushRecord(MapRecordSource.java:68)
... 16 more
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
