[ https://issues.apache.org/jira/browse/HIVE-6649?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jitendra Nath Pandey updated HIVE-6649: --------------------------------------- Resolution: Fixed Fix Version/s: 0.13.0 Status: Resolved (was: Patch Available) > Vectorization: some date expressions throw exception. > ----------------------------------------------------- > > Key: HIVE-6649 > URL: https://issues.apache.org/jira/browse/HIVE-6649 > Project: Hive > Issue Type: Bug > Reporter: Jitendra Nath Pandey > Assignee: Jitendra Nath Pandey > Fix For: 0.13.0 > > Attachments: HIVE-6649.1.patch, HIVE-6649.2.patch, HIVE-6649.2.patch, > HIVE-6649.2.patch > > > Query ran with hive.vectorized.execution.enabled=true: > {code} > select dt, to_date(date_add(dt, 2)), to_date(date_sub(dt, 2)), > datediff(dt, date_add(dt, 2)), datediff(dt, date_sub(dt, 2)), > datediff(date_add(dt, 2), date_sub(dt, 2)) > from vectortab10korc limit 1; > {code} > fails with the following error: > {noformat} > Error: java.lang.RuntimeException: > org.apache.hadoop.hive.ql.metadata.HiveException: Hive Runtime Error while > processing row > at org.apache.hadoop.hive.ql.exec.mr.ExecMapper.map(ExecMapper.java:195) > at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:54) > at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:430) > at org.apache.hadoop.mapred.MapTask.run(MapTask.java:342) > at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:168) > at java.security.AccessController.doPrivileged(Native Method) > at javax.security.auth.Subject.doAs(Subject.java:396) > at > org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1548) > at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:163) > 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:45) > at org.apache.hadoop.hive.ql.exec.mr.ExecMapper.map(ExecMapper.java:177) > ... 8 more > Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: Error evaluating > datediff(date_add(dt, 2), date_sub(dt, 2)) > at > org.apache.hadoop.hive.ql.exec.vector.VectorSelectOperator.processOp(VectorSelectOperator.java:117) > at org.apache.hadoop.hive.ql.exec.Operator.forward(Operator.java:791) > at > org.apache.hadoop.hive.ql.exec.TableScanOperator.processOp(TableScanOperator.java:92) > at org.apache.hadoop.hive.ql.exec.Operator.forward(Operator.java:791) > at > org.apache.hadoop.hive.ql.exec.vector.VectorMapOperator.process(VectorMapOperator.java:43) > ... 9 more > Caused by: java.lang.NullPointerException > at java.lang.String.checkBounds(String.java:400) > at java.lang.String.<init>(String.java:569) > at > org.apache.hadoop.hive.ql.exec.vector.expressions.VectorUDFDateDiffColCol.setDays(VectorUDFDateDiffColCol.java:254) > at > org.apache.hadoop.hive.ql.exec.vector.expressions.VectorUDFDateDiffColCol.copySelected(VectorUDFDateDiffColCol.java:231) > at > org.apache.hadoop.hive.ql.exec.vector.expressions.VectorUDFDateDiffColCol.toDateArray(VectorUDFDateDiffColCol.java:190) > at > org.apache.hadoop.hive.ql.exec.vector.expressions.VectorUDFDateDiffColCol.evaluate(VectorUDFDateDiffColCol.java:72) > at > org.apache.hadoop.hive.ql.exec.vector.VectorSelectOperator.processOp(VectorSelectOperator.java:115) > ... 13 more > {noformat} -- This message was sent by Atlassian JIRA (v6.2#6252)