[
https://issues.apache.org/jira/browse/DRILL-7742?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
duan kesong updated DRILL-7742:
-------------------------------
Environment: (was: set /drill/sys.storage_plugins/mysql
\{"type":"jdbc","driver":"com.mysql.jdbc.Driver","url":"jdbc:mysql://${HOSTNAME}:3306","username":"drill","password":"drill","enabled":true})
> 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
> Priority: Major
>
> 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)
