Dan Burkert created IMPALA-7620:
-----------------------------------
Summary: Improve display of Kudu partitions
Key: IMPALA-7620
URL: https://issues.apache.org/jira/browse/IMPALA-7620
Project: IMPALA
Issue Type: Improvement
Reporter: Dan Burkert
Impala currently exposes the raw partition keys of Kudu tables in the output of
`SHOW PARTITIONS`. The partition keys are considered an internal
implementation detail of Kudu. It would be a lot nicer if the partition hash
and range component(s) were pretty-printed in their own column. Example of
current behavior:
{code:java}
> CREATE TABLE dan_test (
a INT,
b INT,
PRIMARY KEY (a, b)
) PARTITION BY
HASH (a) PARTITIONS 2,
HASH (b) PARTITIONS 2,
RANGE (b) (
PARTITION 0 <= VALUES < 100,
PARTITION VALUE = 150,
PARTITION 200 <= VALUES
) STORED AS KUDU;
> SHOW RANGE PARTITIONS dan_test;
+-------------------+
| RANGE (b) |
+-------------------+
| 0 <= VALUES < 100 |
| VALUE = 150 |
| VALUES >= 200 |
+-------------------+
> SHOW PARTITIONS dan_test;
+--------+--------------------------+--------------------------+-----------------------------------+------------+
| # Rows | Start Key | Stop Key | Leader
Replica | # Replicas |
+--------+--------------------------+--------------------------+-----------------------------------+------------+
| -1 | 000000000000000080000000 | 000000000000000080000064 |
nightly6x-3.vpc.cloudera.com:7050 | 3 |
| -1 | 000000000000000080000096 | 000000000000000080000097 |
nightly6x-2.vpc.cloudera.com:7050 | 3 |
| -1 | 0000000000000000800000C8 | 0000000000000001 |
nightly6x-2.vpc.cloudera.com:7050 | 3 |
| -1 | 000000000000000180000000 | 000000000000000180000064 |
nightly6x-3.vpc.cloudera.com:7050 | 3 |
| -1 | 000000000000000180000096 | 000000000000000180000097 |
nightly6x-2.vpc.cloudera.com:7050 | 3 |
| -1 | 0000000000000001800000C8 | 00000001 |
nightly6x-3.vpc.cloudera.com:7050 | 3 |
| -1 | 000000010000000080000000 | 000000010000000080000064 |
nightly6x-2.vpc.cloudera.com:7050 | 3 |
| -1 | 000000010000000080000096 | 000000010000000080000097 |
nightly6x-4.vpc.cloudera.com:7050 | 3 |
| -1 | 0000000100000000800000C8 | 0000000100000001 |
nightly6x-4.vpc.cloudera.com:7050 | 3 |
| -1 | 000000010000000180000000 | 000000010000000180000064 |
nightly6x-2.vpc.cloudera.com:7050 | 3 |
| -1 | 000000010000000180000096 | 000000010000000180000097 |
nightly6x-4.vpc.cloudera.com:7050 | 3 |
| -1 | 0000000100000001800000C8 | |
nightly6x-2.vpc.cloudera.com:7050 | 3 |
+--------+--------------------------+--------------------------+-----------------------------------+------------+
{code}
Example of what I have in mind:
{code:java}
> SHOW PARTITIONS dan_test;
+--------+----------+----------+-------------------+-----------------------------------+------------+
| # Rows | HASH (a) | HASH (b) | RANGE (b) | Leader Replica
| # Replicas |
+--------+----------+----------+-------------------+-----------------------------------+------------+
| -1 | 0 | 0 | 0 <= VALUES < 100 |
nightly6x-3.vpc.cloudera.com:7050 | 3 |
| -1 | 0 | 0 | VALUE = 150 |
nightly6x-2.vpc.cloudera.com:7050 | 3 |
| -1 | 0 | 0 | VALUES >= 200 |
nightly6x-3.vpc.cloudera.com:7050 | 3 |
| -1 | 0 | 1 | 0 <= VALUES < 100 |
nightly6x-3.vpc.cloudera.com:7050 | 3 |
| -1 | 0 | 1 | VALUE = 150 |
nightly6x-2.vpc.cloudera.com:7050 | 3 |
| -1 | 0 | 1 | VALUES >= 200 |
nightly6x-3.vpc.cloudera.com:7050 | 3 |
| -1 | 1 | 0 | 0 <= VALUES < 100 |
nightly6x-3.vpc.cloudera.com:7050 | 3 |
| -1 | 1 | 0 | VALUE = 150 |
nightly6x-2.vpc.cloudera.com:7050 | 3 |
| -1 | 1 | 0 | VALUES >= 200 |
nightly6x-3.vpc.cloudera.com:7050 | 3 |
| -1 | 1 | 1 | 0 <= VALUES < 100 |
nightly6x-3.vpc.cloudera.com:7050 | 3 |
| -1 | 1 | 1 | VALUE = 150 |
nightly6x-2.vpc.cloudera.com:7050 | 3 |
| -1 | 1 | 1 | VALUES >= 200 |
nightly6x-3.vpc.cloudera.com:7050 | 3 |
+--------+----------+----------+-------------------+-----------------------------------+------------+
{code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
