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