Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-7742

Ignoring unknown property: zk and cannot querry data and SQL Query null

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 1.7.0
    • None
    • Functions - Drill
    • None

    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

      Attachments

        Activity

          People

            Unassigned Unassigned
            duankesong duan kesong
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: