You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@impala.apache.org by "Fredy Wijaya (JIRA)" <ji...@apache.org> on 2018/04/17 05:01:00 UTC

[jira] [Resolved] (IMPALA-6775) Inconsistent ALTER TABLE SET LOCATION output format

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

Fredy Wijaya resolved IMPALA-6775.
----------------------------------
    Resolution: Duplicate

> Inconsistent ALTER TABLE SET LOCATION output format
> ---------------------------------------------------
>
>                 Key: IMPALA-6775
>                 URL: https://issues.apache.org/jira/browse/IMPALA-6775
>             Project: IMPALA
>          Issue Type: Bug
>          Components: Frontend
>    Affects Versions: Impala 2.9.0, Impala 2.10.0, Impala 2.11.0
>            Reporter: Fredy Wijaya
>            Priority: Major
>
> No tabular output.
> {noformat}
> [localhost:21000] > alter table functional.alltypesagg partition(year=2009, month=1) set location 'hdfs://localhost:20500/test-warehouse/new_table';
> Query: alter table functional.alltypesagg partition(year=2009, month=1) set location 'hdfs://localhost:20500/test-warehouse/new_table'
> Fetched 0 row(s) in 0.05s
> {noformat}
> vs others:
> {noformat}
> [localhost:21000] > alter table functional.alltypesagg partition(year=2009, month=1) set fileformat parquet;
> Query: alter table functional.alltypesagg partition(year=2009, month=1) set fileformat parquet
> +-------------------------+
> | summary                 |
> +-------------------------+
> | Updated 0 partition(s). |
> +-------------------------+
> Fetched 1 row(s) in 0.02s
> {noformat}
> {noformat}
> [localhost:21000] > alter table functional.alltypesagg partition(year=2009, month=1) set tblproperties ('key'='value');
> Query: alter table functional.alltypesagg partition(year=2009, month=1) set tblproperties ('key'='value')
> +-------------------------+
> | summary                 |
> +-------------------------+
> | Updated 0 partition(s). |
> +-------------------------+
> Fetched 1 row(s) in 0.02s
> {noformat}
> {noformat}
> [localhost:21000] > alter table functional.alltypesagg partition(year=2009, month=1) set tblproperties ('key'='value');
> Query: alter table functional.alltypesagg partition(year=2009, month=1) set tblproperties ('key'='value')
> +-------------------------+
> | summary                 |
> +-------------------------+
> | Updated 0 partition(s). |
> +-------------------------+
> Fetched 1 row(s) in 0.02s
> {noformat}



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