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:

  1. download and install to CentOS 7 Trino from trino.io
  2. configure /etc/catalog/hive.properties
  3. start launcher
  4. download and install Starburst ODBC 64bit to windows
  5. 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)

4

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

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password

Post as a guest

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.