Hi,
A query running successfully on sqlline does not work with drlll-explorer. The drillbit is 0.8 and drill-explorer is 0.7. (is this an issue??) Here is the error message, from drill-explorer ERROR [HY000] [MapR][Drill] (1040) Drill failed to execute the query: SELECT * FROM `dfs`.`root`.`./process/guru-rawdata/Merkel.1.drill.json` [30024]Query execution error. Details:[ Query failed: Failure while running fragment., Field references must be singular names. [ 78b5c6e2-ee85-4926-ae5d-10621ad6c28f on cvcv4hdp1003:31010 ] [ 78b5c6e2-ee85-4926-ae5d-10621ad6c28f on cvcv4hdp1003:31010 ]] Here is the log message 2014-12-31 17:52:23,412 [2b5bc829-54d5-e21d-bcaa-c8f01dfa2a2a:frag:0:0] ERROR o.a.drill.exec.work.foreman.Foreman - Error 45bf3633-2995-4b0d-8711-9ca00bcbbbcc: Query failed: Failure while running fragment., Field references must be singular names. [ 78b5c6e2-ee85-4926-ae5d-10621ad6c28f on cvcv4hdp1003:31010 ] [ 78b5c6e2-ee85-4926-ae5d-10621ad6c28f on cvcv4hdp1003:31010 ] org.apache.drill.exec.rpc.RemoteRpcException: Failure while running fragment., Field references must be singular names. [ 78b5c6e2-ee85-4926-ae5d-10621ad6c28f on cvcv4hdp1003:31010 ] [ 78b5c6e2-ee85-4926-ae5d-10621ad6c28f on cvcv4hdp1003:31010 ] at org.apache.drill.exec.work.foreman.QueryManager.statusUpdate(QueryManager.java:93) [drill-java-exec-0.8.0-SNAPSHOT-rebuffed.jar:0.8.0-SNAPSHOT] at org.apache.drill.exec.work.foreman.QueryManager$RootStatusReporter.statusChange(QueryManager.java:151) [drill-java-exec-0.8.0-SNAPSHOT-rebuffed.jar:0.8.0-SNAPSHOT] at org.apache.drill.exec.work.fragment.AbstractStatusReporter.fail(AbstractStatusReporter.java:113) [drill-java-exec-0.8.0-SNAPSHOT-rebuffed.jar:0.8.0-SNAPSHOT] at org.apache.drill.exec.work.fragment.AbstractStatusReporter.fail(AbstractStatusReporter.java:109) [drill-java-exec-0.8.0-SNAPSHOT-rebuffed.jar:0.8.0-SNAPSHOT] at org.apache.drill.exec.work.fragment.FragmentExecutor.internalFail(FragmentExecutor.java:166) [drill-java-exec-0.8.0-SNAPSHOT-rebuffed.jar:0.8.0-SNAPSHOT] at org.apache.drill.exec.work.fragment.FragmentExecutor.run(FragmentExecutor.java:129) [drill-java-exec-0.8.0-SNAPSHOT-rebuffed.jar:0.8.0-SNAPSHOT] at org.apache.drill.exec.work.WorkManager$RunnableWrapper.run(WorkManager.java:254) [drill-java-exec-0.8.0-SNAPSHOT-rebuffed.jar:0.8.0-SNAPSHOT] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [na:1.7.0_55] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [na:1.7.0_55] at java.lang.Thread.run(Thread.java:744) [na:1.7.0_55] 2014-12-31 17:52:23,450 [UserServer-1] INFO o.a.drill.exec.rpc.user.UserServer - Channel closed between local 0.0.0.0/0.0.0.0:31010 and remote /149.42.24.124:60262 Thanks, Sungwook
