[DRILL-880] Selecting a non existant column from text file hangs sqlline

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.5.0
• Component/s: Storage - Text & CSV
• Assignee: Jason Altekruse
• Reporter: Ramana Inukonda Nagaraj
• Due: 15/Aug/14
• Created: 30/May/14 22:41
• Updated: 15/Aug/14 22:18
• Resolved: 15/Aug/14 22:11

Description

git.commit.id.abbrev=e1e5ea0

Have a TSV file. I am able to do a select * and select columns[0] etc from the tsv file just fine.

However if I specify an invalid column the query just hangs sqlline- Should fail with an error.

The logs contain an error message like this
Exception in thread "dca6a192-a774-4389-b03e-55ad21745ebd:frag:0:0" java.lang.IllegalArgumentException: Selected column must have name 'columns'
at com.google.common.base.Preconditions.checkArgument(Preconditions.java:92)
at org.apache.drill.exec.store.text.DrillTextRecordReader.<init>(DrillTextRecordReader.java:73)
at org.apache.drill.exec.store.easy.text.TextFormatPlugin.getRecordReader(TextFormatPlugin.java:70)
at org.apache.drill.exec.store.dfs.easy.EasyFormatPlugin.getReaderBatch(EasyFormatPlugin.java:138)
at org.apache.drill.exec.store.dfs.easy.EasyReaderBatchCreator.getBatch(EasyReaderBatchCreator.java:34)
at org.apache.drill.exec.store.dfs.easy.EasyReaderBatchCreator.getBatch(EasyReaderBatchCreator.java:27)
at org.apache.drill.exec.physical.impl.ImplCreator.visitOp(ImplCreator.java:62)
at org.apache.drill.exec.physical.impl.ImplCreator.visitOp(ImplCreator.java:39)
at org.apache.drill.exec.physical.base.AbstractPhysicalVisitor.visitSubScan(AbstractPhysicalVisitor.java:92)
at org.apache.drill.exec.physical.base.AbstractSubScan.accept(AbstractSubScan.java:50)
at org.apache.drill.exec.physical.impl.ImplCreator.getChildren(ImplCreator.java:74)
at org.apache.drill.exec.physical.impl.ImplCreator.visitOp(ImplCreator.java:62)
at org.apache.drill.exec.physical.impl.ImplCreator.visitOp(ImplCreator.java:39)
at org.apache.drill.exec.physical.base.AbstractPhysicalVisitor.visitProject(AbstractPhysicalVisitor.java:47)
at org.apache.drill.exec.physical.config.Project.accept(Project.java:53)
at org.apache.drill.exec.physical.impl.ImplCreator.getChildren(ImplCreator.java:74)
at org.apache.drill.exec.physical.impl.ImplCreator.visitOp(ImplCreator.java:59)
at org.apache.drill.exec.physical.impl.ImplCreator.visitOp(ImplCreator.java:39)
at org.apache.drill.exec.physical.base.AbstractPhysicalVisitor.visitStore(AbstractPhysicalVisitor.java:97)
at org.apache.drill.exec.physical.base.AbstractPhysicalVisitor.visitScreen(AbstractPhysicalVisitor.java:155)
at org.apache.drill.exec.physical.config.Screen.accept(Screen.java:104)
at org.apache.drill.exec.physical.impl.ImplCreator.getExec(ImplCreator.java:87) at org.apache.drill.exec.work.fragment.FragmentExecutor.run(FragmentExecutor.java:81)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:744)