Menu ▾ ▴

#1359 Presto JDBC - system.jdbc.columns query takes forever, anyway to disable catalog scan?

None
open
nobody
None
1
2018-12-22
2018-09-08
bob jones
No

Am using Squirrel sql 3.2.1 with presto jdbc driver (v.210), seems like it generates this before actually running the query select * from hive.bob.asx_l

Below query hangs forever, if i kill it from the presto webui then i can run other queries. Is there a squirrel setting to disable these queries from being auto-generated/run?

SELECT TABLE_CAT, TABLE_SCHEM, TABLE_NAME, COLUMN_NAME, DATA_TYPE,
TYPE_NAME, COLUMN_SIZE, BUFFER_LENGTH, DECIMAL_DIGITS, NUM_PREC_RADIX,
NULLABLE, REMARKS, COLUMN_DEF, SQL_DATA_TYPE, SQL_DATETIME_SUB,
CHAR_OCTET_LENGTH, ORDINAL_POSITION, IS_NULLABLE,
SCOPE_CATALOG, SCOPE_SCHEMA, SCOPE_TABLE,
SOURCE_DATA_TYPE, IS_AUTOINCREMENT, IS_GENERATEDCOLUMN
FROM system.jdbc.columns
WHERE TABLE_NAME LIKE 'asx_l' ESCAPE '\' AND COLUMN_NAME LIKE '%' ESCAPE '\'
ORDER BY TABLE_CAT, TABLE_SCHEM, TABLE_NAME, ORDINAL_POSITION

See
https://github.com/prestodb/presto/issues/11442

Discussion


Log in to post a comment.