Hanifi Gunes created DRILL-1310:
-----------------------------------
Summary: Star select with join throws AssertionError
Key: DRILL-1310
URL: https://issues.apache.org/jira/browse/DRILL-1310
Project: Apache Drill
Issue Type: Bug
Reporter: Hanifi Gunes
Fix For: 0.5.0
Take two simple csv files:
{panel:title=t1.csv}
ID,Name,Lastname
9711942,name0,last0
9707867,name1,last1
{panel}
{panel:title=t2.csv}
ID,Case Number
9711942,HX362083
9707867,HX357851
{panel}
Making a simple join on them with a star projection:
{code:sql}
explain plan for
select *
from
dfs.`/path/to/t1.csv` t1,
dfs.`/path/to/t2.csv` t2
where t1.columns[0] = t2.columns[0];
{code}
throws
{panel}
java.lang.AssertionError: Unexpected project expression or reference.
at
org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.classifyExpr(ProjectRecordBatch.java:597)
at
org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.setupNewSchema(ProjectRecordBatch.java:260)
at
org.apache.drill.exec.record.AbstractSingleRecordBatch.innerNext(AbstractSingleRecordBatch.java:66)
at
org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.innerNext(ProjectRecordBatch.java:120)
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:95)
at
org.apache.drill.exec.physical.impl.validate.IteratorValidatorBatchIterator.next(IteratorValidatorBatchIterator.java:116)
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:75)
at
org.apache.drill.exec.physical.impl.join.HashJoinBatch.executeBuildPhase(HashJoinBatch.java:307)
at
org.apache.drill.exec.physical.impl.join.HashJoinBatch.innerNext(HashJoinBatch.java:196)
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:95)
at
org.apache.drill.exec.physical.impl.validate.IteratorValidatorBatchIterator.next(IteratorValidatorBatchIterator.java:116)
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:75)
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:65)
at
org.apache.drill.exec.record.AbstractSingleRecordBatch.innerNext(AbstractSingleRecordBatch.java:45)
at
org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.innerNext(ProjectRecordBatch.java:120)
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:95)
at
org.apache.drill.exec.physical.impl.validate.IteratorValidatorBatchIterator.next(IteratorValidatorBatchIterator.java:116)
{panel}
--
This message was sent by Atlassian JIRA
(v6.2#6252)
