[jira] [Created] (HIVE-14894) Queries with functions in the filters, aggregation are failing when the vectorized is enabled and

["Madhumalini (JIRA)" <ji...@apache.org>]

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)