hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Deepesh Khandelwal (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-11123) Fix how to confirm the RDBMS product name at Metastore.
Date Mon, 24 Aug 2015 21:36:45 GMT

    [ https://issues.apache.org/jira/browse/HIVE-11123?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14710109#comment-14710109
] 

Deepesh Khandelwal commented on HIVE-11123:
-------------------------------------------

[~sinchii] thanks for the patch! What version of Oracle did you use for testing this? We saw
some issues with existing code (without your patch) on Oracle 12 whereas it worked fine on
Oracle 11. Just want to make sure that it works as expected between different Oracle versions.

> Fix how to confirm the RDBMS product name at Metastore.
> -------------------------------------------------------
>
>                 Key: HIVE-11123
>                 URL: https://issues.apache.org/jira/browse/HIVE-11123
>             Project: Hive
>          Issue Type: Bug
>          Components: Metastore
>    Affects Versions: 1.2.0
>         Environment: PostgreSQL
>            Reporter: Shinichi Yamashita
>            Assignee: Shinichi Yamashita
>         Attachments: HIVE-11123.1.patch, HIVE-11123.2.patch, HIVE-11123.3.patch, HIVE-11123.4.patch
>
>
> I use PostgreSQL to Hive Metastore. And I saw the following message at PostgreSQL log.
> {code}
> < 2015-06-26 10:58:15.488 JST >ERROR:  syntax error at or near "@@" at character
5
> < 2015-06-26 10:58:15.488 JST >STATEMENT:  SET @@session.sql_mode=ANSI_QUOTES
> < 2015-06-26 10:58:15.489 JST >ERROR:  relation "v$instance" does not exist at
character 21
> < 2015-06-26 10:58:15.489 JST >STATEMENT:  SELECT version FROM v$instance
> < 2015-06-26 10:58:15.490 JST >ERROR:  column "version" does not exist at character
10
> < 2015-06-26 10:58:15.490 JST >STATEMENT:  SELECT @@version
> {code}
> When Hive CLI and Beeline embedded mode are carried out, this message is output to PostgreSQL
log.
> These queries are called from MetaStoreDirectSql#determineDbType. And if we use MetaStoreDirectSql#getProductName,
we need not to call these queries.



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

Mime
View raw message