Trino Starburst Odbc Syntax_Error: User_Error (1010)
Getting Following Error While Testing Connection in Windows Odbc 64 and 32 Manager: [Starburst][Trino] (1010) Error Occurred While Trying to Connect...
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
- 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)
1 Answer
This error appears to be due to the ODBC driver you are using for the connection. Try using the Magnitude ODBC driver like this link Magnitude ODBC
For reference on this error see the discussion about the problem in the Odbc driver
Chloe Bennett explores the intersection of pop culture, streaming entertainment, digital trends, and contemporary lifestyle. Her weekly commentary reaches thousands of culture enthusiasts.
