[ 
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)

Reply via email to