Can`t query mysql table using a uppercase name

[devilcony]

happens when querying a mysql table with a uppercase name ,and mysql server is case sensitive
query like this: select * from mysql.test."MY_TEST"
the presto server returns this: Table 'mysql.test.my_test' does not exist

[findepi]

Hi @devilcony
This is known limitation.

PrestoSQL has a fix.

[tooptoop4]

any update? hive metastore tables in mysql like DBS, PARTITIONS can't be queried.

presto> select * from mysql.metastore.DBS;
Query 20180913_015448_00010_774as failed: line 1:15: Table mysql.metastore.dbs does not exist

[findepi]

@tooptoop4 this is a duplicate; please follow the original issue