[DRILL-1296] Star query fails with a nested select

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.5.0
• Component/s: Execution - Codegen, Execution - Relational Operators
• Assignee: Mehant Baid
• Reporter: Hanifi Gunes
• Created: 13/Aug/14 18:42
• Updated: 19/Aug/14 19:20
• Resolved: 19/Aug/14 19:20

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

Running the following fails:

select *
FROM dfs.`/path/to/t1.csv` 
where columns[0] in 
(SELECT columns[0] FROM dfs.`/path/to/t2.csv`);

java.lang.UnsupportedOperationException: Failure finding function that runtime code generation expected. Signature: compare_to( INT:OPTIONALVARCHAR:OPTIONAL, ) returns INT:REQUIRED
at org.apache.drill.exec.expr.fn.FunctionGenerationHelper.getFunctionExpression(FunctionGenerationHelper.java:78)
at org.apache.drill.exec.expr.fn.FunctionGenerationHelper.getComparator(FunctionGenerationHelper.java:50)
at org.apache.drill.exec.physical.impl.common.ChainedHashTable.setupIsKeyMatchInternal(ChainedHashTable.java:214)
at org.apache.drill.exec.physical.impl.common.ChainedHashTable.createAndSetupHashTable(ChainedHashTable.java:173)
at org.apache.drill.exec.physical.impl.join.HashJoinBatch.setupHashTable(HashJoinBatch.java:301)
at org.apacheError: exception while executing query: Failure while trying to get next result batch. (state=,code=0)
.drill.exec.physical.impl.join.HashJoinBatch.executeBuildPhase(HashJoinBatch.java:328)
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)
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)
at org.apache.drill.exec.physical.impl.BaseRootExec.next(BaseRootExec.java:59)
at org.apache.drill.exec.physical.impl.ScreenCreator$ScreenRoot.innerNext(ScreenCreator.java:98)
at org.apache.drill.exec.physical.impl.BaseRootExec.next(BaseRootExec.java:49)
at org.apache.drill.exec.work.fragment.FragmentExecutor.run(FragmentExecutor.java:105)
at org.apache.drill.exec.work.WorkManager$RunnableWrapper.run(WorkManager.java:250)

Issue Links

• is duplicated by: DRILL-1310 Star select with join throws AssertionError