Tristan Stevens created IMPALA-10172:
----------------------------------------
Summary: Support Hive metastore managed locations for databases
Key: IMPALA-10172
URL: https://issues.apache.org/jira/browse/IMPALA-10172
Project: IMPALA
Issue Type: Improvement
Reporter: Tristan Stevens
In Hive 3 a database can have both managed and (unmanaged) locations.
Hive DDL syntax is as follows:
{noformat}
CREATE (DATABASE|SCHEMA) [IF NOT EXISTS] database_name
[COMMENT database_comment]
[LOCATION hdfs_path]
[MANAGEDLOCATION hdfs_path]
[WITH DBPROPERTIES (property_name=property_value, ...)];
ALTER (DATABASE|SCHEMA) database_name SET MANAGEDLOCATION hdfs_path;
{noformat}
Right now, Impala does not appear to support this syntax.
Also the {{DESCRIBE FORMATTED}} and {{DESCRIBE EXTENDED}} statements should
display both the {{LOCATION}} and {{MANAGEDLOCATION}}.
Example:
{noformat}
impala-shell -i host-2.user1-c5.my.example.com -d default -k --ssl
--ca_cert=/opt/cloudera/security/pki/chain.pem
Starting Impala Shell using Kerberos authentication
Using service name 'impala'
SSL is enabled
Opened TCP connection to host-2.user1-c5.my.example.com:21000
Connected to host-2.user1-c5.my.example.com:21000
Server version: impalad version 3.4.0-SNAPSHOT RELEASE (build
25402784335c39cc24076d71dab7a3ccbd562094)
Query: use `default`
***********************************************************************************
Welcome to the Impala shell.
(Impala Shell v3.4.0-SNAPSHOT (2540278) built on Wed Aug 5 11:07:32 UTC 2020)
To see a summary of a query's progress that updates in real-time, run 'set
LIVE_PROGRESS=1;'.
***********************************************************************************
Query: use `default`
[host-2.user1-c5.my.example.com:21000] default> create database dbnew4 LOCATION
'hdfs://host-1.user1-c5.my.example.com:8020/data/dbnewnew/external'
MANAGEDLOCATION
'hdfs://host-1.user1-c5.my.example.com:8020/data/dbnewnew/managed';
Query: create database dbnew4 LOCATION
'hdfs://host-1.user1-c5.my.example.com:8020/data/dbnewnew/external'
MANAGEDLOCATION
'hdfs://host-1.user1-c5.my.example.com:8020/data/dbnewnew/managed'
ERROR: ParseException: Syntax error in line 1:
...0/data/dbnewnew/external' MANAGEDLOCATION 'hdfs://ccyc...
^
Encountered: IDENTIFIER
Expected: AS, CACHED, PARTITION, TBLPROPERTIES, UNCACHED
CAUSED BY: Exception: Syntax error
[host-2.user1-c5.my.example.com:21000] default> alter database dbnewnew SET
MANAGEDLOCATION='hdfs://host-1.user1-c5.my.example.com:8020/data/dbnewnew/managed';
Query: alter database dbnewnew SET
MANAGEDLOCATION='hdfs://host-1.user1-c5.my.example.com:8020/data/dbnewnew/managed'
ERROR: ParseException: Syntax error in line 1:
...newnew SET MANAGEDLOCATION='hdfs://host-1.user1-...
^
Encountered: =
Expected: ROLE, IDENTIFIER
CAUSED BY: Exception: Syntax error
[host-2.user1-c5.my.example.com:21000] default> describe database formatted
db_cust_loc3 ;
Query: describe database formatted db_cust_loc3
+--------------+-------------------------------------------------------------------+---------+
| name | location
| comment |
+--------------+-------------------------------------------------------------------+---------+
| db_cust_loc3 | hdfs://host-1.user1-c5.my.example.com:8020/data/db_cust_loc3 |
|
| Owner: |
| |
| | admin
| USER |
+--------------+-------------------------------------------------------------------+---------+
Fetched 3 row(s) in 0.03s
[host-2.user1-c5.my.example.com:21000] default> describe database extended
db_cust_loc3 ;
Query: describe database extended db_cust_loc3
+--------------+-------------------------------------------------------------------+---------+
| name | location
| comment |
+--------------+-------------------------------------------------------------------+---------+
| db_cust_loc3 | hdfs://host-1.user1-c5.my.example.com:8020/data/db_cust_loc3 |
|
| Owner: |
| |
| | admin
| USER |
+--------------+-------------------------------------------------------------------+---------+
Fetched 3 row(s) in 0.01s
[host-2.user1-c5.my.example.com:21000] default>
{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]
