You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Kallam Reddy (JIRA)" <ji...@apache.org> on 2017/05/26 18:41:04 UTC

[jira] [Updated] (HIVE-16770) Concatinate is not working on Table/Partial Partition level

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

Kallam Reddy updated HIVE-16770:
--------------------------------
    Description: 
Not able to CONCATENATE at Table/Partial partition levels. I have table test partitioned on year, month and date. If I try to concatenate by providing corresponding year, month and date of partition it is working fine, but when I want to concatenate ORC files for all the sub partition corresponding to year and month, it is giving exception.

hive> ALTER TABLE test PARTITION (year = '2017', month = '05') CONCATENATE;
FAILED: SemanticException org.apache.hadoop.hive.ql.parse.SemanticException: Partition not found {year=2017, month=05}

hive> ALTER TABLE test CONCATENATE;
FAILED: SemanticException org.apache.hadoop.hive.ql.parse.SemanticException: source table test is partitioned but no partition desc found.

I am expecting this to trigger concatenate in all available sub partitions.

  was:
Not able to CONCATENATE at Table/Partial partition levels. I have table test partitioned on year, month and date. If I try to concatenate by providing corresponding year, month and date of partition it is working fine, but when I want to concatenate ORC files for all the sub partition corresponding to year and month, it is giving exception.

hive> ALTER TABLE test PARTITION (year = '2017', month = '05') CONCATENATE;
FAILED: SemanticException org.apache.hadoop.hive.ql.parse.SemanticException: Partition not found {year=2017, month=05}

hive> ALTER TABLE otda_es_orc_p1 CONCATENATE;
FAILED: SemanticException org.apache.hadoop.hive.ql.parse.SemanticException: source table otdadb.otda_es_orc_p1 is partitioned but no partition desc found.

I am expecting this to trigger concatenate in all available sub partitions.


> Concatinate is not working on Table/Partial Partition level 
> ------------------------------------------------------------
>
>                 Key: HIVE-16770
>                 URL: https://issues.apache.org/jira/browse/HIVE-16770
>             Project: Hive
>          Issue Type: Bug
>          Components: CLI
>    Affects Versions: 1.2.1
>         Environment: centOS7
>            Reporter: Kallam Reddy
>
> Not able to CONCATENATE at Table/Partial partition levels. I have table test partitioned on year, month and date. If I try to concatenate by providing corresponding year, month and date of partition it is working fine, but when I want to concatenate ORC files for all the sub partition corresponding to year and month, it is giving exception.
> hive> ALTER TABLE test PARTITION (year = '2017', month = '05') CONCATENATE;
> FAILED: SemanticException org.apache.hadoop.hive.ql.parse.SemanticException: Partition not found {year=2017, month=05}
> hive> ALTER TABLE test CONCATENATE;
> FAILED: SemanticException org.apache.hadoop.hive.ql.parse.SemanticException: source table test is partitioned but no partition desc found.
> I am expecting this to trigger concatenate in all available sub partitions.



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