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

["Sergey Shelukhin (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-11859?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Sergey Shelukhin resolved HIVE-11859.
-------------------------------------
    Resolution: Duplicate

> Bunch of SQL error reported for Hive with SQL Server as Metastore
> -----------------------------------------------------------------
>
>                 Key: HIVE-11859
>                 URL: https://issues.apache.org/jira/browse/HIVE-11859
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Aparup Banerjee
>            Priority: Critical
>
> 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.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)