[GitHub] [incubator-doris] wsjz commented on issue #2729: Doris could not 'show tables' by JDBC

[GitBox <gi...@apache.org>]

wsjz commented on issue #2729: Doris could not 'show tables' by JDBC
URL: https://github.com/apache/incubator-doris/issues/2729#issuecomment-573063294
 
 
   I got the exception when attempted to use mysql connector to construct palo catalog for **Presto**.
   with palo catalog, I could "show schemas" and "use", but when I performed "show tables", presto printed the exception:
   
   java.sql.SQLException: 'TABLE' is not a number
   	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965)
   	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3933)
   	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3869)
   	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524)
   	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2675)
   	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465)
   	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1912)
   	at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2020)
   	at com.mysql.jdbc.DatabaseMetaDataUsingInfoSchema.executeMetadataQuery(DatabaseMetaDataUsingInfoSchema.java:65)
   	at com.mysql.jdbc.DatabaseMetaDataUsingInfoSchema.getTables(DatabaseMetaDataUsingInfoSchema.java:1190)

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org