Getting following error while testing connection in windows odbc 64 and 32 manager: [Starburst][Trino] (1010) Error occurred while trying to connect: SYNTAX_ERROR : USER_ERROR : line 1:1: mismatched input '{'. Expecting: 'ALTER', 'ANALYZE', 'CALL', 'COMMENT', 'COMMIT', 'CREATE', 'DEALLOCATE', 'DELETE', 'DENY', 'DESC', 'DESCRIBE', 'DROP', 'EXECUTE', 'EXPLAIN', 'GRANT', 'INSERT', 'MERGE', 'PREPARE', 'REFRESH', 'RESET', 'REVOKE', 'ROLLBACK', 'SET', 'SHOW', 'START', 'TRUNCATE', 'UPDATE', 'USE',
Steps to recreate:
- download and install to CentOS 7 Trino from trino.io https://repo1.maven.org/maven2/io/trino/trino-server-rpm/377/trino-server-rpm-377.rpm
- configure /etc/catalog/hive.properties
- start launcher
- download and install Starburst ODBC 64bit to windows
- open windows ODBC manager, input trino url and port 8080 and press test connection
default trino installation from trino.io trino server version: 377 and 352 (both have same error)