[ https://issues.apache.org/jira/browse/HIVE-3926?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13578132#comment-13578132 ]
Navis commented on HIVE-3926: ----------------------------- This issue also resolves single sourced multi scan with virtual columns. For example, the query <code> SELECT a.INPUT__FILE__NAME,a.key,a.value,b.INPUT__FILE__NAME,b.key,b.value FROM myinput1 a LEFT OUTER JOIN myinput1 b RIGHT OUTER JOIN myinput1 c ON a.value = b.value and b.value = c.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value AND c.key > 40 AND c.value > 50 AND c.key = c.value; <code> is not working in trunk, throwing {code} Caused by: java.lang.ClassCastException: org.apache.hadoop.hive.serde2.lazy.LazyStruct cannot be cast to [Ljava.lang.Object; at org.apache.hadoop.hive.serde2.objectinspector.UnionStructObjectInspector.getStructFieldData(UnionStructObjectInspector.java:123) at org.apache.hadoop.hive.serde2.objectinspector.UnionStructObjectInspector.getStructFieldData(UnionStructObjectInspector.java:131) at org.apache.hadoop.hive.ql.exec.ExprNodeColumnEvaluator.evaluate(ExprNodeColumnEvaluator.java:98) at org.apache.hadoop.hive.ql.exec.ReduceSinkOperator.processOp(ReduceSinkOperator.java:233) at org.apache.hadoop.hive.ql.exec.Operator.process(Operator.java:522) at org.apache.hadoop.hive.ql.exec.Operator.forward(Operator.java:850) at org.apache.hadoop.hive.ql.exec.TableScanOperator.processOp(TableScanOperator.java:90) at org.apache.hadoop.hive.ql.exec.Operator.process(Operator.java:522) at org.apache.hadoop.hive.ql.exec.Operator.forward(Operator.java:850) at org.apache.hadoop.hive.ql.exec.MapOperator.process(MapOperator.java:657) {code} > PPD on virtual column of partitioned table is not working > --------------------------------------------------------- > > Key: HIVE-3926 > URL: https://issues.apache.org/jira/browse/HIVE-3926 > Project: Hive > Issue Type: Bug > Components: Query Processor > Reporter: Navis > Assignee: Navis > Priority: Minor > Attachments: HIVE-3926.D8121.1.patch, HIVE-3926.D8121.2.patch > > > {code} > select * from src where BLOCK__OFFSET__INSIDE__FILE<100; > {code} > is working, but > {code} > select * from srcpart where BLOCK__OFFSET__INSIDE__FILE<100; > {code} > throws SemanticException. Disabling PPD makes it work. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira