Details
-
Improvement
-
Status: Resolved
-
Major
-
Resolution: Implemented
-
None
-
None
-
None
-
ghx-label-6
Description
In Hive 3 a database can have both managed and (unmanaged) locations.
Hive DDL syntax is as follows:
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;
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:
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>
Attachments
Issue Links
- relates to
-
IMPALA-462 ALTER DATABASE support to rename or move database
-
- Reopened
-