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

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

Yuriy Plysyuk created HIVE-13604:
------------------------------------

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