[
https://issues.apache.org/jira/browse/IMPALA-6686?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17198421#comment-17198421
]
Tim Armstrong commented on IMPALA-6686:
---------------------------------------
[~csringhofer] I think it's OK to change. We can keep the "formatted" output in
the row-oriented format, maybe, as a fallback option (Hive doesn't have that).
{noformat}
[localhost.EXAMPLE.COM:21000] default> describe database functional;
Query: describe database functional
+------------+------------------------------------------------------+---------+
| name | location | comment |
+------------+------------------------------------------------------+---------+
| functional | hdfs://172.19.0.1:20500/test-warehouse/functional.db | |
+------------+------------------------------------------------------+---------+
Fetched 1 row(s) in 0.01s
[localhost.EXAMPLE.COM:21000] default> describe database extended functional;
Query: describe database extended functional
+------------+------------------------------------------------------+---------+
| name | location | comment |
+------------+------------------------------------------------------+---------+
| functional | hdfs://172.19.0.1:20500/test-warehouse/functional.db | |
| Owner: | | |
| | tarmstrong | USER |
+------------+------------------------------------------------------+---------+
Fetched 3 row(s) in 0.01s
[localhost.EXAMPLE.COM:21000] default> describe database formatted functional;
Query: describe database formatted functional
+------------+------------------------------------------------------+---------+
| name | location | comment |
+------------+------------------------------------------------------+---------+
| functional | hdfs://172.19.0.1:20500/test-warehouse/functional.db | |
| Owner: | | |
| | tarmstrong | USER |
+------------+------------------------------------------------------+---------+
Fetched 3 row(s) in 0.01s
{noformat}
> Change the DESCRIBE DATABASE output to look more like Hive output
> -----------------------------------------------------------------
>
> Key: IMPALA-6686
> URL: https://issues.apache.org/jira/browse/IMPALA-6686
> Project: IMPALA
> Issue Type: Improvement
> Components: Frontend
> Reporter: Fredy Wijaya
> Priority: Minor
> Labels: compatibility, incompatibility
>
> In Hive:
> {noformat}
> describe database functional;
> +----------+----------+------------------------------------------------+-------------+-------------+-------------+
> | db_name | comment | location |
> owner_name | owner_type | parameters |
> +----------+----------+------------------------------------------------+-------------+-------------+-------------+
> | tpch | | hdfs://localhost:20500/test-warehouse/tpch.db | foo
> | USER | |
> +----------+----------+------------------------------------------------+-------------+-------------+-------------+{noformat}
> In Impala:
> {noformat}
> describe database extended functional;
> +---------+-----------------------------------------------+---------+
> | name | location | comment |
> +---------+-----------------------------------------------+---------+
> | tpch | hdfs://localhost:20500/test-warehouse/tpch.db | |
> | Owner: | | |
> | | foo | USER |
> +---------+-----------------------------------------------+---------+
> {noformat}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
