Details
-
Bug
-
Status: Resolved
-
Major
-
Resolution: Fixed
-
None
-
None
Description
0: jdbc:drill:zk=local> select * from dfs.`/tmp/test.tsv`;
------------
columns |
------------
["{ \"name\": \"Tomer\", \"children\": [ { \"name\": \"Reut\", \"age\": 6 }, { \"name\": \"Romi\", \"age\": 3 }, { \"name\": \"Yuval\", \"age\": 0 } ] }"] |
["{ \"name\": \"Dikla\", \"children\": [ { \"name\": \"Shir\", \"age\": 10 } ] }"] |
------------
2 rows selected (1.046 seconds)
0: jdbc:drill:zk=local> select convert_from(columns[0], json) from dfs.`/tmp/test.tsv`;
Exception in thread "564aa091-d64d-4846-9835-011232dd2010: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:140)
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:745)
[It hangs here...]