You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "Dan Burkert (JIRA)" <ji...@apache.org> on 2018/09/25 18:58:00 UTC
[jira] [Created] (IMPALA-7620) Improve display of Kudu partitions
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)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org