[
https://issues.apache.org/jira/browse/IMPALA-7620?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Tim Armstrong updated IMPALA-7620:
----------------------------------
Component/s: Frontend
> Improve display of Kudu partitions
> ----------------------------------
>
> Key: IMPALA-7620
> URL: https://issues.apache.org/jira/browse/IMPALA-7620
> Project: IMPALA
> Issue Type: Improvement
> Components: Frontend
> Reporter: Dan Burkert
> Priority: Major
>
> 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
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
