[ 
https://issues.apache.org/jira/browse/IMPALA-12844?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18058253#comment-18058253
 ] 

ASF subversion and git services commented on IMPALA-12844:
----------------------------------------------------------

Commit f0ac9a4b7d3b7c1eb9e9b5cc36aae80031ce9340 in impala's branch 
refs/heads/master from Balazs Hevele
[ https://gitbox.apache.org/repos/asf?p=impala.git;h=f0ac9a4b7 ]

IMPALA-12844: Support setting DBPROPERTIES

Added support for ALTER DATABASE <db> SET DBPROPERTIES(...)
Added support for [WITH DBPROPERTIES(...)] for CREATE DATABASE queries

Database properties can now be set by Impala through these queries
either at database creation or for already existing databases.

Testing:
- Added frontend tests for parsing/analyzing/authorizing relevant queries
- Added E2E tests to verify that altering properties does take effect

Change-Id: I628c7bed4f0c39aed7f5f4ffea52421caf501933
Reviewed-on: http://gerrit.cloudera.org:8080/23905
Reviewed-by: Impala Public Jenkins <[email protected]>
Tested-by: Impala Public Jenkins <[email protected]>


> Support CREATE DATABASE WITH DBPROPERTIES
> -----------------------------------------
>
>                 Key: IMPALA-12844
>                 URL: https://issues.apache.org/jira/browse/IMPALA-12844
>             Project: IMPALA
>          Issue Type: New Feature
>            Reporter: Quanlong Huang
>            Assignee: Balazs Hevele
>            Priority: Major
>              Labels: ramp-up
>
> Based on fe/src/main/cup/sql-parser.cup, currently Impala just supports the 
> following syntax for CREATE DATABASE:
> {code:sql}
> CREATE (DATABASE|SCHEMA) [IF NOT EXISTS] database_name[COMMENT 
> 'database_comment']
>   [LOCATION hdfs_path];{code}
> It'd be nice to add support for specifying the dbproperties, e.g.
> {noformat}
> CREATE DATABASE tempdb WITH DBPROPERTIES ('impala.disableHmsSync'='true');
> {noformat}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to