Mike Percy has posted comments on this change. (
http://gerrit.cloudera.org:8080/11665 )
Change subject: [tools] Add a describe table tool
......................................................................
Patch Set 5:
Would it be possible to output Impala-compatible syntax ala /table in the
Master UI? BTW can we fix that thing to include all this new good stuff?
Well, that is equivalent to "show create table" but I think it's pretty legit,
technically describe table might only show schema stuff.
>From impala-shell:
> describe mpercy_test8;
Query: describe mpercy_test8
+------+--------+---------+-------------+----------+---------------+---------------+---------------------+------------+
| name | type | comment | primary_key | nullable | default_value | encoding
| compression | block_size |
+------+--------+---------+-------------+----------+---------------+---------------+---------------------+------------+
| f0 | bigint | | true | false | |
AUTO_ENCODING | DEFAULT_COMPRESSION | 0 |
| f1 | string | | false | true | |
AUTO_ENCODING | DEFAULT_COMPRESSION | 0 |
| f2 | string | | false | true | |
AUTO_ENCODING | DEFAULT_COMPRESSION | 0 |
| f3 | string | | false | true | |
AUTO_ENCODING | DEFAULT_COMPRESSION | 0 |
| f4 | string | | false | true | |
AUTO_ENCODING | DEFAULT_COMPRESSION | 0 |
| f5 | string | | false | true | |
AUTO_ENCODING | DEFAULT_COMPRESSION | 0 |
| f6 | string | | false | true | |
AUTO_ENCODING | DEFAULT_COMPRESSION | 0 |
| f7 | string | | false | true | |
AUTO_ENCODING | DEFAULT_COMPRESSION | 0 |
| f8 | string | | false | true | |
AUTO_ENCODING | DEFAULT_COMPRESSION | 0 |
| f9 | string | | false | true | |
AUTO_ENCODING | DEFAULT_COMPRESSION | 0 |
+------+--------+---------+-------------+----------+---------------+---------------+---------------------+------------+
Fetched 10 row(s) in 0.04s
> show create table mpercy_test8;
Query: show create table mpercy_test8
+-----------------------------------------------------------------------------------------------------+
| result
|
+-----------------------------------------------------------------------------------------------------+
| CREATE TABLE default.mpercy_test8 (
|
| f0 BIGINT NOT NULL ENCODING AUTO_ENCODING COMPRESSION DEFAULT_COMPRESSION,
|
| f1 STRING NULL ENCODING AUTO_ENCODING COMPRESSION DEFAULT_COMPRESSION,
|
| f2 STRING NULL ENCODING AUTO_ENCODING COMPRESSION DEFAULT_COMPRESSION,
|
| f3 STRING NULL ENCODING AUTO_ENCODING COMPRESSION DEFAULT_COMPRESSION,
|
| f4 STRING NULL ENCODING AUTO_ENCODING COMPRESSION DEFAULT_COMPRESSION,
|
| f5 STRING NULL ENCODING AUTO_ENCODING COMPRESSION DEFAULT_COMPRESSION,
|
| f6 STRING NULL ENCODING AUTO_ENCODING COMPRESSION DEFAULT_COMPRESSION,
|
| f7 STRING NULL ENCODING AUTO_ENCODING COMPRESSION DEFAULT_COMPRESSION,
|
| f8 STRING NULL ENCODING AUTO_ENCODING COMPRESSION DEFAULT_COMPRESSION,
|
| f9 STRING NULL ENCODING AUTO_ENCODING COMPRESSION DEFAULT_COMPRESSION,
|
| PRIMARY KEY (f0)
|
| )
|
| PARTITION BY HASH (f0) PARTITIONS 450
|
| STORED AS KUDU
|
| TBLPROPERTIES ('kudu.master_addresses'='vc1320.halxg.cloudera.com',
'kudu.num_tablet_replicas'='1') |
+-----------------------------------------------------------------------------------------------------+
Fetched 1 row(s) in 0.04s
--
To view, visit http://gerrit.cloudera.org:8080/11665
To unsubscribe, visit http://gerrit.cloudera.org:8080/settings
Gerrit-Project: kudu
Gerrit-Branch: master
Gerrit-MessageType: comment
Gerrit-Change-Id: Ib02f2a94cf11d0e60b32cd85be920ca9b99dd977
Gerrit-Change-Number: 11665
Gerrit-PatchSet: 5
Gerrit-Owner: Will Berkeley <[email protected]>
Gerrit-Reviewer: Adar Dembo <[email protected]>
Gerrit-Reviewer: Alexey Serbin <[email protected]>
Gerrit-Reviewer: Andrew Wong <[email protected]>
Gerrit-Reviewer: Attila Bukor <[email protected]>
Gerrit-Reviewer: Grant Henke <[email protected]>
Gerrit-Reviewer: Mike Percy <[email protected]>
Gerrit-Reviewer: Tidy Bot
Gerrit-Reviewer: Will Berkeley <[email protected]>
Gerrit-Comment-Date: Fri, 12 Oct 2018 21:12:52 +0000
Gerrit-HasComments: No
