[jira] [Created] (DRILL-7742) Ignoring unknown property: zk and cannot querry data and SQL Query null

["duan kesong (Jira)" <ji...@apache.org>]

duan kesong created DRILL-7742:
----------------------------------

             Summary: Ignoring unknown property: zk and cannot querry data and SQL Query null
                 Key: DRILL-7742
                 URL: https://issues.apache.org/jira/browse/DRILL-7742
             Project: Apache Drill
          Issue Type: Bug
          Components: Functions - Drill
    Affects Versions: 1.7.0
            Reporter: duan kesong


L-3:~ # /opt/apache-drill/bin/sqlline -u jdbc:drill:zk=C-1:6181,C-2:6181,L-3:6181 -n ser360 -p ser360
0: jdbc:drill:zk=C-1:6181,C-2:6181,L-3:618> use mysql.udb_user_data;
[Error Id: 06fae1cb-c4ad-4b98-a2c2-06acc5118c76 on L-8:31010] (state=,code=0)

L-8:/var/log/drill/drillbit.log

2020-05-11 13:12:31,599 [UserServer-1] WARN o.a.drill.exec.rpc.user.UserSession - Ignoring unknown property: zk
2020-05-11 13:12:46,226 [2146ccd1-6580-96da-a7cc-dcde29c3994c:foreman] INFO o.a.drill.exec.work.foreman.Foreman - Query text for query id 2146ccd1-6580-96da-a7cc-dcde29c3994c: use mysql.udb_user_data
2020-05-11 13:12:46,250 [2146ccd1-6580-96da-a7cc-dcde29c3994c:foreman] INFO o.a.d.e.planner.sql.SchemaUtilites - User Error Occurred
org.apache.drill.common.exceptions.UserException: VALIDATION ERROR: Schema [mysql.udb_user_data] is not valid with respect to either root schema or current default schema.

Current default schema: No default schema selected

[Error Id: 06fae1cb-c4ad-4b98-a2c2-06acc5118c76 ]
 at org.apache.drill.common.exceptions.UserException$Builder.build(UserException.java:543) ~[drill-common-1.7.0.jar:1.7.0]
 at org.apache.drill.exec.planner.sql.SchemaUtilites.throwSchemaNotFoundException(SchemaUtilites.java:139) [drill-java-exec-1.7.0.jar:1.7.0]
 at org.apache.drill.exec.rpc.user.UserSession.setDefaultSchemaPath(UserSession.java:185) [drill-java-exec-1.7.0.jar:1.7.0]
 at org.apache.drill.exec.planner.sql.handlers.UseSchemaHandler.getPlan(UseSchemaHandler.java:45) [drill-java-exec-1.7.0.jar:1.7.0]
 at org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:94) [drill-java-exec-1.7.0.jar:1.7.0]
 at org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:978) [drill-java-exec-1.7.0.jar:1.7.0]
 at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:257) [drill-java-exec-1.7.0.jar:1.7.0]
 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [na:1.7.0_131]
 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [na:1.7.0_131]
 at java.lang.Thread.run(Thread.java:745) [na:1.7.0_131]
2020-05-11 13:13:16,304 [UserServer-1] INFO o.a.drill.exec.rpc.user.UserServer - RPC connection /169.253.122.8:31010 <--> /169.253.122.3:47581 (user client) timed out. Timeout was set to 30 seconds. Closing connection.
2020-05-11 14:24:09,172 [UserServer-1] WARN o.a.drill.exec.rpc.user.UserSession - Ignoring unknown property: zk


SQL Query null



--
This message was sent by Atlassian Jira
(v8.3.4#803005)