Hi Andries,I can not also use INFORMATION_SCHEMA.SCHEMA when my MSSQL JDBC
driver is on; As a consequence I need to disable this storage plug in it to
connect Tableau with Drill through ODBC driver;
Boris
Le Mardi 26 janvier 2016 17h26, Andries Engelbrecht
<[email protected]> a écrit :
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
