Zoltan Chovan created HIVE-22804: ------------------------------------ Summary: Ensure ANSI quotes are used for mysql connections Key: HIVE-22804 URL: https://issues.apache.org/jira/browse/HIVE-22804 Project: Hive Issue Type: Improvement Reporter: Zoltan Chovan Assignee: Zoltan Chovan
Recent changes in direct sql queries to resolve postgres issues(e.g. TxnHandler in HIVE-22663 ) break compatibility with mysql backend db. A workaround for these issues is to add a session config to the mysql connection string, e.g.: {code:java} jdbc:mysql://localhost:3306/db?sessionVariables=sql_mode=ANSI_QUOTES {code} -- This message was sent by Atlassian Jira (v8.3.4#803005)