[ https://issues.apache.org/jira/browse/HIVE-22829?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17049973#comment-17049973 ]
Ramesh Kumar Thangarajan edited comment on HIVE-22829 at 3/3/20 7:41 AM: ------------------------------------------------------------------------- [~hashutosh] [~gopalv] , can you please help me review this? was (Author: rameshkumar): [~hashutosh], can you please help me review this? > 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)