Matthew Jacobs created IMPALA-5308:
--------------------------------------
Summary: SHOW TABLE STATS for Kudu tables is confusing
Key: IMPALA-5308
URL: https://issues.apache.org/jira/browse/IMPALA-5308
Project: IMPALA
Issue Type: Bug
Components: Frontend
Affects Versions: Impala 2.8.0
Reporter: Matthew Jacobs
SHOW TABLE STATS for Kudu tables shows all Kudu tablets and explicitly shows
the #rows are -1, because we don't support per-partition or per-tablet stats
(see IMPALA-2830).
However, we do have table statistics (# rows) and that doesn't show up in the
SHOW TABLE STATS output, which is confusing. The table stats does show up in
the DESCRIBE EXTENDED output.
{code}
[localhost:21000] > show table stats tdata;
Query: show table stats tdata
+--------+-----------+----------+----------------------------------+------------+
| # Rows | Start Key | Stop Key | Leader Replica | # Replicas
|
+--------+-----------+----------+----------------------------------+------------+
| -1 | | 00000001 | mj-desktop.ca.cloudera.com:31201 | 3
|
| -1 | 00000001 | 00000002 | mj-desktop.ca.cloudera.com:31202 | 3
|
| -1 | 00000002 | | mj-desktop.ca.cloudera.com:31201 | 3
|
+--------+-----------+----------+----------------------------------+------------+
Fetched 3 row(s) in 0.02s
[localhost:21000] > describe extended tdata;
Query: describe extended tdata
+------------------------------+-------------------------------------------------+-------------------------------------------+
| name | type
| comment |
+------------------------------+-------------------------------------------------+-------------------------------------------+
| # col_name | data_type
| comment |
| | NULL
| NULL |
| id | int
| NULL |
...
|
| | NULL
| NULL |
| # Detailed Table Information | NULL
| NULL |
| Database: | default
| NULL |
| Owner: | mj
| NULL |
| CreateTime: | Mon May 08 11:16:29 PDT 2017
| NULL |
| LastAccessTime: | UNKNOWN
| NULL |
| Protect Mode: | None
| NULL |
| Retention: | 0
| NULL |
| Location: | hdfs://localhost:20500/test-warehouse/tdata
| NULL |
| Table Type: | MANAGED_TABLE
| NULL |
| Table Parameters: | NULL
| NULL |
| | DO_NOT_UPDATE_STATS
| true |
| | STATS_GENERATED_VIA_STATS_TASK
| true |
| | kudu.master_addresses
| 127.0.0.1 |
| | kudu.table_name
| impala::default.tdata |
| ==========> | numRows | 1500
|
{code}
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
