[prev in list] [next in list] [prev in thread] [next in thread] 

List:       drill-user
Subject:    drill explorer error
From:       Sungwook Yoon <syoon () maprtech ! com>
Date:       2014-12-31 18:05:55
Message-ID: CAC-7oTxhz=73ex6qrqyswBU=7Gv-SR9jW9WkmAsHYELBVZ30gg () mail ! gmail ! com
[Download RAW message or body]


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


[prev in list] [next in list] [prev in thread] [next in thread]