[HIVE-11859] Bunch of SQL error reported for Hive with SQL Server as Metastore

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Duplicate
• Assignee: Unassigned
• Reporter: Aparup Banerjee
• Created: 17/Sep/15 03:42
• Updated: 17/Sep/15 18:42
• Resolved: 17/Sep/15 18:42

Description

We are getting a lot of SQL errors reported at SQL Server end. Our set up is a Two Node Hive cluster using SQL Server as MetaStore.

Here is a snippet of SQL Server errors

Invalid object name 'v$instance'. Caused by: SELECT version FROM v$instance

Must declare the scalar variable "@@session".Caused by: SET @@session.sql_mode=ANSI_QUOTES

This is filling our logs at a very rapid rate, which we are forced to purge.

Please note these queries are for MySQL / Oracle.

Issue Links

• duplicates: HIVE-11123 Fix how to confirm the RDBMS product name at Metastore.