question Re: Add comments to columns in an impala table in Archives of Support Questions (Read Only)

Add comments to columns in an impala table

gimp077 — Fri, 16 Sep 2022 12:00:51 GMT

How do I add comments to a column in an impala table for specific columns after creating it.

Thanks

Re: Add comments to columns in an impala table

saranvisa — Mon, 31 Jul 2017 02:39:12 GMT

@gimp077

I didn't get a chance to test it, but just try this, it may help

Go to Hue -> Metastore manager -> db.table -> property -> update comment

Re: Add comments to columns in an impala table

EricL — Wed, 02 Aug 2017 11:38:52 GMT

ALTER TABLE test CHANGE {columname} {columnname} {datatype} comment 'test comment';

See below test case:

[impala-host:21000] > show create table test;
Query: show create table test
+---------------------------------------------------------------------------------------------------------------------+
| result                                                                                                              |
+---------------------------------------------------------------------------------------------------------------------+
| CREATE TABLE default.test (                                                                                         |
|   a INT,                                                                                                            |
|   b INT                                                                                                             |
| )                                                                                                                   |
| WITH SERDEPROPERTIES ('serialization.format'='1')                                                                   |
| STORED AS TEXTFILE                                                                                                  |
| LOCATION 'hdfs://namenode-host:8020/user/hive/warehouse/test'                                 |
| TBLPROPERTIES ('numFiles'='3', 'COLUMN_STATS_ACCURATE'='true', 'numRows'='9', 'totalSize'='40', 'rawDataSize'='31') |
+---------------------------------------------------------------------------------------------------------------------+
Fetched 1 row(s) in 7.42s
[impala-host:21000] > alter table test change a a int comment 'test comment';
Query: alter table test change a a int comment 'test comment'

Fetched 0 row(s) in 0.66s
[impala-host:21000] > show create table test;
Query: show create table test
+---------------------------------------------------------------------------------------------------------------------+
| result                                                                                                              |
+---------------------------------------------------------------------------------------------------------------------+
| CREATE TABLE default.test (                                                                                         |
|   a INT COMMENT 'test comment',                                                                                     |
|   b INT                                                                                                             |
| )                                                                                                                   |
| WITH SERDEPROPERTIES ('serialization.format'='1')                                                                   |
| STORED AS TEXTFILE                                                                                                  |
| LOCATION 'hdfs://namenode-host:8020/user/hive/warehouse/test'                                 |
| TBLPROPERTIES ('numFiles'='3', 'COLUMN_STATS_ACCURATE'='true', 'numRows'='9', 'totalSize'='40', 'rawDataSize'='31') |
+---------------------------------------------------------------------------------------------------------------------+

Re: Add comments to columns in an impala table

urmfriend71 — Thu, 13 Jun 2019 03:00:13 GMT

Hi, here is a question.

How do I alter and remove a table comment?

THANKS.

Re: Add comments to columns in an impala table

EricL — Thu, 13 Jun 2019 05:09:45 GMT

Hi,

You could just set the comment as empty string like "", I am not sure if you can remove the field completely.

Cheers
Eric

Re: Add comments to columns in an impala table

urmfriend71 — Thu, 13 Jun 2019 09:24:34 GMT

Thanks for your quick reply.

What I wanna know is how do I alter and remove a "table level" comment.

I cannot find an example or document on the Internet.

Re: Add comments to columns in an impala table

grahn — Tue, 17 Sep 2019 20:49:53 GMT

In the docs:

https://impala.apache.org/docs/build/html/topics/impala_comment.html

Set it to NULL.

Re: Add comments to columns in an impala table

EricL — Wed, 18 Sep 2019 07:01:53 GMT

You can do alter like I mentioned before:

ALTER TABLE test CHANGE col1 col1 int COMMENT 'test comment';

But I do not think you can remove it, but rather to just empty it.

Cheers
Eric