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

Fri, 03 Aug 2018 00:38:02 -0700 

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)

Reply via email to