[jira] [Commented] (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:comment-tabpanel&focusedCommentId=14803399#comment-14803399 ] 

Sergey Shelukhin commented on HIVE-11859:
-----------------------------------------

This is from the old db product detection method that would issue all kinds of db-specific queries. It should be fixed by HIVE-11123

> 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)