[DRILL-1310] Star select with join throws AssertionError

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.5.0
• Assignee: DrillCommitter
• Reporter: Hanifi Gunes
• Created: 18/Aug/14 19:28
• Updated: 29/Aug/14 17:55
• Resolved: 29/Aug/14 17:55

Description

Take two simple csv files:

t1.csv

ID,Name,Lastname
9711942,name0,last0
9707867,name1,last1

t2.csv

ID,Case Number
9711942,HX362083
9707867,HX357851

Making a simple join on them with a star projection:

select *
from 
dfs.`/path/to/t1.csv` t1,
dfs.`/path/to/t2.csv` t2
where t1.columns[0] = t2.columns[0];

throws

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)

Issue Links

• duplicates: DRILL-1296 Star query fails with a nested select