You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Eugene Koifman (JIRA)" <ji...@apache.org> on 2017/02/10 02:17:41 UTC

[jira] [Updated] (HIVE-15871) Cannot insert into target table because column number/types are different with hive.merge.cardinality.check=false

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

Eugene Koifman updated HIVE-15871:
----------------------------------
    Description: 
Merge statement with WHEN MATCHED and hive.merge.cardinality.check=false
causes errors like
{noformat}
FAILED: SemanticException [Error 10044]: Line 11:12 Cannot insert into target table because column number/types are different 'part_0': Table insclause-0 has 3 columns, but query has 4 columns.
{noformat}

  was:
Merge statement with WHEN MATCHED and hive.merge.cardinality.check=false
causes
{noformat}
FAILED: SemanticException [Error 10044]: Line 11:12 Cannot insert into target table because column number/types are different 'part_0': Table insclause-0 has 3 columns, but query has 4 columns.
{noformat}


> Cannot insert into target table because column number/types are different with hive.merge.cardinality.check=false 
> ------------------------------------------------------------------------------------------------------------------
>
>                 Key: HIVE-15871
>                 URL: https://issues.apache.org/jira/browse/HIVE-15871
>             Project: Hive
>          Issue Type: Sub-task
>          Components: Transactions
>    Affects Versions: 2.2.0
>            Reporter: Eugene Koifman
>            Assignee: Eugene Koifman
>
> Merge statement with WHEN MATCHED and hive.merge.cardinality.check=false
> causes errors like
> {noformat}
> FAILED: SemanticException [Error 10044]: Line 11:12 Cannot insert into target table because column number/types are different 'part_0': Table insclause-0 has 3 columns, but query has 4 columns.
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)