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

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.7.0
• Component/s: Functions - Drill
• Assignee: Unassigned
• Reporter: duan kesong
• Created: 22/May/20 03:09
• Updated: 22/May/20 03:11

Description

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