Anyone run into issues with Drill INFORMATION_SCHEMA queries when using the
JDBC plugin with MySQL?
In my case some tools are interrogating Drill's Metadata, which then fails when
enabling the JDBC plugin with MySQL.
Using Drill 1.4 and MySQL 5.1.73
{query}
SELECT DISTINCT TABLE_SCHEMA as NAME_SPACE, TABLE_NAME as TAB_NAME FROM
INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA <>'INFORMATION_SCHEMA' and
TABLE_SCHEMA <> 'sys';
{/query}
{result}
Error: SYSTEM ERROR: MySQLSyntaxErrorException: Unknown table engine
'PERFORMANCE_SCHEMA'
Fragment 0:0
{/result}
Thanks
--Andries
