[ https://issues.apache.org/jira/browse/HIVE-20651?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16633152#comment-16633152 ]
Hive QA commented on HIVE-20651: -------------------------------- Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12941799/HIVE-20651.2.patch {color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified. {color:red}ERROR:{color} -1 due to 5 failed/errored test(s), 15010 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[load_dyn_part3] (batchId=160) org.apache.hadoop.hive.ql.TestWarehouseExternalDir.testManagedPaths (batchId=242) org.apache.hive.jdbc.TestJdbcWithMiniHS2.testParallelCompilation3 (batchId=255) org.apache.hive.storage.jdbc.TestJdbcInputFormat.testSplitLogic_noSpillOver (batchId=235) org.apache.hive.storage.jdbc.TestJdbcInputFormat.testSplitLogic_withSpillOver (batchId=235) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/14134/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/14134/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-14134/ Messages: {noformat} Executing org.apache.hive.ptest.execution.TestCheckPhase Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.YetusPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase Tests exited with: TestsFailedException: 5 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12941799 - PreCommit-HIVE-Build > JdbcStorageHandler password should be encrypted > ----------------------------------------------- > > Key: HIVE-20651 > URL: https://issues.apache.org/jira/browse/HIVE-20651 > Project: Hive > Issue Type: Improvement > Components: StorageHandler > Reporter: Daniel Dai > Assignee: Daniel Dai > Priority: Major > Attachments: HIVE-20651.1.patch, HIVE-20651.2.patch > > > Currently, external jdbc table with JdbcStorageHandler store password as > "hive.sql.dbcp.password" table property in clear text. We should put it in a > keystore file. Here is the proposed change: > {code:java} > …. > STORED BY 'org.apache.hive.storage.jdbc.JdbcStorageHandler' > TBLPROPERTIES ( > "hive.sql.dbcp.password.keystore" = > "hdfs:///user/hive/credential/postgres.jceks", > "hive.sql.dbcp.password.key" = "mydb.password" > ); > {code} > > The jceks file is created with: > {code} > hadoop credential create mydb.password -provider > hdfs:///user/hive/credential/postgres.jceks -v secretpassword > {code} > User can choose to put all db password in one jceks, or a separate jceks for > each db. -- This message was sent by Atlassian JIRA (v7.6.3#76005)