[jira] [Updated] (HIVE-13604) Do not log AlreadyExistsException when "IF NOT EXISTS" is used.

["Yuriy Plysyuk (JIRA)" <ji...@apache.org>]

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

Yuriy Plysyuk updated HIVE-13604:
---------------------------------
    Component/s: Logging

> Do not log AlreadyExistsException when "IF NOT EXISTS" is used.
> ---------------------------------------------------------------
>
>                 Key: HIVE-13604
>                 URL: https://issues.apache.org/jira/browse/HIVE-13604
>             Project: Hive
>          Issue Type: Bug
>          Components: Logging
>    Affects Versions: 2.0.0
>            Reporter: Yuriy Plysyuk
>            Priority: Trivial
>
> When trying to create view that exists with statement:
> CREATE VIEW IF NOT EXISTS dummy_table ...
> Next error is logged:
> ERROR RetryingHMSHandler:190 - AlreadyExistsException(message:Table dummy_view already exists)
> at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.create_table_core(HiveMetaStore.java:1296)
> ...
> The same when creating schema using:
> CREATE SCHEMA IF NOT EXISTS ...
> Error should not be logged as it confuses.
> For 
> CREATE TABLE IF NOT EXISTS ...
> it works fine. I checked that there is code to handle this in:
> org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeCreateTable
> // check for existence of table
>     if (ifNotExists) {
>       try {
>         Table table = getTable(qualifiedTabName, false);
>         if (table != null) { // table exists
>           return null;
>         }
> could you please add similar check for creating views and schema?



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