You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "ASF subversion and git services (Jira)" <ji...@apache.org> on 2024/03/27 07:15:00 UTC
[jira] [Commented] (IMPALA-12928) Mask dbcp.password table property of JDBC table for 'desc formatted' and 'show create table' commands
[ https://issues.apache.org/jira/browse/IMPALA-12928?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17831192#comment-17831192 ]
ASF subversion and git services commented on IMPALA-12928:
----------------------------------------------------------
Commit 0a077fe9921af7c5bac2f9decba371c5eca55d6a in impala's branch refs/heads/master from wzhou-code
[ https://gitbox.apache.org/repos/asf?p=impala.git;h=0a077fe99 ]
IMPALA-12928: Mask JDBC table property dbcp.password for DESC FORMATTED and SHOW CREATE TABLE
'desc formatted' and 'show create table' commands show all of table
properties in clear text. For external JDBC table, dbcp.password table
property value should be masked in the output of these two commands.
This patch makes dbcp.password property value been masked in the output
of 'desc formatted' and 'show create table' commands.
dbcp.password table property could be wrote into Impala and HMS log
files with JDBC table creation statements. There is generic tool in
production environment with which user could set up the regular
expressions to detect and redact sensitive information within SQL
statement text in log files.
Testing:
- Added end-to-end test cases.
- Passed core tests.
Change-Id: I83dc32c8d0fec1cdfdfe06e720561b2ae1adf5df
Reviewed-on: http://gerrit.cloudera.org:8080/21187
Reviewed-by: Impala Public Jenkins <im...@cloudera.com>
Tested-by: Impala Public Jenkins <im...@cloudera.com>
> Mask dbcp.password table property of JDBC table for 'desc formatted' and 'show create table' commands
> -----------------------------------------------------------------------------------------------------
>
> Key: IMPALA-12928
> URL: https://issues.apache.org/jira/browse/IMPALA-12928
> Project: IMPALA
> Issue Type: Sub-task
> Components: Clients, Frontend
> Reporter: Wenzhe Zhou
> Assignee: Wenzhe Zhou
> Priority: Major
> Fix For: Impala 4.4.0
>
>
> 'desc formatted' and 'show create table' commands show all of table properties in clear text. For external JDBC table, dbcp.password table property should be masked in the output of above two commands.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org