[IMPALA-6775] Inconsistent ALTER TABLE SET LOCATION output format

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: Impala 2.9.0, Impala 2.10.0, Impala 2.11.0
• Component/s: Frontend
• Epic Color: ghx-label-7
• Assignee: Unassigned
• Reporter: Fredy Wijaya
• Created: 30/Mar/18 18:09
• Updated: 17/Apr/18 05:00
• Resolved: 17/Apr/18 05:00

Description

No tabular output.

[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

vs others:

[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

[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

[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

Issue Links

• relates to: IMPALA-5903 Inconsistent specification of result set and result set metadata