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)
