hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ramesh Kumar Thangarajan (Jira)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-22829) Decimal64: NVL in vectorization miss NPE with CBO on
Date Tue, 25 Feb 2020 00:09:00 GMT

     [ https://issues.apache.org/jira/browse/HIVE-22829?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Ramesh Kumar Thangarajan updated HIVE-22829:
--------------------------------------------
    Attachment: HIVE-22829.3.patch
        Status: Patch Available  (was: Open)

> Decimal64: NVL in vectorization miss NPE with CBO on
> ----------------------------------------------------
>
>                 Key: HIVE-22829
>                 URL: https://issues.apache.org/jira/browse/HIVE-22829
>             Project: Hive
>          Issue Type: Bug
>          Components: Vectorization
>            Reporter: Gopal Vijayaraghavan
>            Assignee: Ramesh Kumar Thangarajan
>            Priority: Major
>         Attachments: HIVE-22829.3.patch
>
>
> {code}
> select  
> sum(NVL(ss_sales_price, 1.0BD))
> from store_sales where ss_sold_date_sk % 1111 = 1;
> {code}
> {code}
> |                 notVectorizedReason: exception: java.lang.NullPointerException stack
trace: org.apache.hadoop.hive.ql.optimizer.physical.Vectorizer.fixDecimalDataTypePhysicalVariations(Vectorizer.java:4754),
org.apache.hadoop.hive.ql.optimizer.physical.Vectorizer.fixDecimalDataTypePhysicalVariations(Vectorizer.java:4687),
org.apache.hadoop.hive.ql.optimizer.physical.Vectorizer.vectorizeSelectOperator(Vectorizer.java:4669),
org.apache.hadoop.hive.ql.optimizer.physical.Vectorizer.validateAndVectorizeOperator(Vectorizer.java:5269),
org.apache.hadoop.hive.ql.optimizer.physical.Vectorizer.doProcessChild(Vectorizer.java:977),
org.apache.hadoop.hive.ql.optimizer.physical.Vectorizer.doProcessChildren(Vectorizer.java:864),
org.apache.hadoop.hive.ql.optimizer.physical.Vectorizer.validateAndVectorizeOperatorTree(Vectorizer.java:834),
org.apache.hadoop.hive.ql.optimizer.physical.Vectorizer.access$2500(Vectorizer.java:245),
org.apache.hadoop.hive.ql.optimizer.physical.Vectorizer$VectorizationDispatcher.validateAndVectorizeMapOperators(Vectorizer.java:2103),
org.apache.hadoop.hive.ql.optimizer.physical.Vectorizer$VectorizationDispatcher.validateAndVectorizeMapOperators(Vectorizer.java:2055),
org.apache.hadoop.hive.ql.optimizer.physical.Vectorizer$VectorizationDispatcher.validateAndVectorizeMapWork(Vectorizer.java:2030),
org.apache.hadoop.hive.ql.optimizer.physical.Vectorizer$VectorizationDispatcher.convertMapWork(Vectorizer.java:1185),
org.apache.hadoop.hive.ql.optimizer.physical.Vectorizer$VectorizationDispatcher.dispatch(Vectorizer.java:1017),
org.apache.hadoop.hive.ql.lib.TaskGraphWalker.dispatch(TaskGraphWalker.java:111), org.apache.hadoop.hive.ql.lib.TaskGraphWalker.walk(TaskGraphWalker.java:180),
... |
> {code}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Mime
View raw message