You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "xhmz (JIRA)" <ji...@apache.org> on 2018/08/03 07:37:00 UTC

[jira] [Created] (HIVE-20303) INSERT OVERWRITE TABLE db.table PARTITION () if not exists . will error as Table not found db (state=42000,code=40000)

xhmz created HIVE-20303:
---------------------------

             Summary: INSERT OVERWRITE TABLE   db.table PARTITION ()  if not exists . will error as Table not found db (state=42000,code=40000) 
                 Key: HIVE-20303
                 URL: https://issues.apache.org/jira/browse/HIVE-20303
             Project: Hive
          Issue Type: Bug
          Components: CLI
    Affects Versions: 2.2.0
            Reporter: xhmz


if i use INSERT OVERWRITE TABLE   db.table PARTITION ()  if not exists select xx, it wii error

as 

Error: Error while compiling statement: FAILED: SemanticException org.apache.hadoop.hive.ql.metadata.InvalidTableException: Table not found db (state=42000,code=40000)

 

but   INSERT OVERWRITE TABLE   db.table PARTITION ()  select,  do not use [if not exists], it is ok



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)