[
https://issues.apache.org/jira/browse/HIVE-14894?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Madhumalini updated HIVE-14894:
-------------------------------
Summary: Queries with functions in the filters, aggregation are failing
when the vectorization is enabled (was: Queries with functions in the filters,
aggregation are failing when the vectorized is enabled and )
> Queries with functions in the filters, aggregation are failing when the
> vectorization is enabled
> ------------------------------------------------------------------------------------------------
>
> 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)