Madhumalini created HIVE-14894:
----------------------------------
Summary: Queries with functions in the filters, aggregation are
failing when the vectorized is enabled and
Key: HIVE-14894
URL: https://issues.apache.org/jira/browse/HIVE-14894
Project: Hive
Issue Type: Bug
Components: Vectorization
Affects Versions: 0.14.0
Environment: Production
Reporter: Madhumalini
When the hive.vectorized.execution.enabled=ture; the first query provides the
result but the second on throws error in both mr and tez. When the
vectorization is false it works fine in both. Based on the documentation, the
string functions are supported in vectroization.
SELECT count(*) as RecordCount FROM tada_data.lu_billing WHERE ( upper(field1)
= upper('hb1') ) ;
SELECT hlr_tlg_name_s,hlr_name_s FROM tada_data.lu_billing WHERE (
upper(field1) = upper('hb1') )
Here is the error:
Caused by: java.lang.RuntimeException:
org.apache.hadoop.hive.ql.metadata.HiveException: Hive Runtime Error while
processing row
at
org.apache.hadoop.hive.ql.exec.tez.MapRecordSource.processRow(MapRecordSource.java:91)
at
org.apache.hadoop.hive.ql.exec.tez.MapRecordSource.pushRecord(MapRecordSource.java:68)
at
org.apache.hadoop.hive.ql.exec.tez.MapRecordProcessor.run(MapRecordProcessor.java:294)
at
org.apache.hadoop.hive.ql.exec.tez.TezProcessor.initializeAndRunProcessor(TezProcessor.java:163)
... 13 more
Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: Hive Runtime Error
while processing row
at
org.apache.hadoop.hive.ql.exec.vector.VectorMapOperator.process(VectorMapOperator.java:52)
at
org.apache.hadoop.hive.ql.exec.tez.MapRecordSource.processRow(MapRecordSource.java:83)
... 16 more
Caused by: java.lang.ArrayIndexOutOfBoundsException: 2
at
org.apache.hadoop.hive.ql.exec.vector.expressions.StringUnaryUDF.evaluate(StringUnaryUDF.java:70)
at
org.apache.hadoop.hive.ql.exec.vector.expressions.VectorExpression.evaluateChildren(VectorExpression.java:118)
at
org.apache.hadoop.hive.ql.exec.vector.expressions.gen.FilterStringGroupColEqualStringGroupScalarBase.evaluate(FilterStringGroupColEqualStringGroupScalarBase.java:40)
at
org.apache.hadoop.hive.ql.exec.vector.VectorFilterOperator.processOp(VectorFilterOperator.java:100)
at org.apache.hadoop.hive.ql.exec.Operator.forward(Operator.java:815)
at
org.apache.hadoop.hive.ql.exec.TableScanOperator.processOp(TableScanOperator.java:95)
at
org.apache.hadoop.hive.ql.exec.MapOperator$MapOpCtx.forward(MapOperator.java:157)
at
org.apache.hadoop.hive.ql.exec.vector.VectorMapOperator.process(VectorMapOperator.java:45)
... 17 more
Please fix and provide insight if you think it is not a bug.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
