[
https://issues.apache.org/jira/browse/IMPALA-6686?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17209782#comment-17209782
]
ASF subversion and git services commented on IMPALA-6686:
---------------------------------------------------------
Commit 76f9b75c8b701e50378ce92a729f01768da55171 in impala's branch
refs/heads/master from Csaba Ringhofer
[ https://gitbox.apache.org/repos/asf?p=impala.git;h=76f9b75 ]
IMPALA-10172: Support Hive metastore managed locations for databases
This change lets the user set the managed location path in new
databases, e.g.
CREATE DATABASE db MANAGEDLOCATION 'some url';
This property sets the location where the database's tables with
table property 'transactional'='true' will be placed.
The change also adds managedlocation to DESCRIBE DATABASE's output.
Example:
DESCRIBE DATABASE db;
+------------------+-----------------------------------------+---------+
| name | location | comment |
+------------------+-----------------------------------------+---------+
| db | hdfs://localhost:20500/test-warehouse/a | |
| managedlocation: | hdfs://localhost:20500/test-warehouse/b | |
+------------------+-----------------------------------------+---------+
DESCRIBE DATABASE EXTENDED db6;
+------------------+-----------------------------------------+---------+
| name | location | comment |
+------------------+-----------------------------------------+---------+
| db | hdfs://localhost:20500/test-warehouse/a | |
| managedlocation: | hdfs://localhost:20500/test-warehouse/b | |
| Owner: | | |
| | csringhofer | USER |
+------------------+-----------------------------------------+---------+
Note that Impala's output for DESCRIBE DATABASE (EXTENDED) is
different than Hive's, where a new column was added for each extra
piece of information, while Impala adds a new row to keep the 3 column
format. Changing to Hive's format would be preferable in my opinion,
but is a potentially breaking change.
See IMPALA-6686 for further discussion.
Testing:
- added FE and EE tests
- ran relevant tests
Change-Id: I925632a43ff224f762031e89981896722e453399
Reviewed-on: http://gerrit.cloudera.org:8080/16529
Reviewed-by: Impala Public Jenkins <[email protected]>
Tested-by: Impala Public Jenkins <[email protected]>
> 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]
