[ https://issues.apache.org/jira/browse/SPARK-17783?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15703558#comment-15703558 ]
Apache Spark commented on SPARK-17783: -------------------------------------- User 'gatorsmile' has created a pull request for this issue: https://github.com/apache/spark/pull/16047 > Hide Credentials in CREATE and DESC FORMATTED/EXTENDED a PERSISTENT/TEMP > Table for JDBC > --------------------------------------------------------------------------------------- > > Key: SPARK-17783 > URL: https://issues.apache.org/jira/browse/SPARK-17783 > Project: Spark > Issue Type: Bug > Components: SQL > Affects Versions: 2.0.1, 2.1.0 > Reporter: Xiao Li > Assignee: Xiao Li > Priority: Critical > Fix For: 2.1.0 > > > We should never expose the Credentials in the EXPLAIN and DESC > FORMATTED/EXTENDED command. However, below commands exposed the credentials. > {noformat} > CREATE TABLE tab1 USING org.apache.spark.sql.jdbc > {noformat} > {noformat} > == Physical Plan == > ExecutedCommand > +- CreateDataSourceTableCommand CatalogTable( > Table: `tab1` > Created: Tue Oct 04 21:39:44 PDT 2016 > Last Access: Wed Dec 31 15:59:59 PST 1969 > Type: MANAGED > Provider: org.apache.spark.sql.jdbc > Storage(Properties: > [url=jdbc:h2:mem:testdb0;user=testUser;password=testPass, > dbtable=TEST.PEOPLE, user=testUser, password=testPass])), false > {noformat} > {noformat} > DESC FORMATTED tab1 > {noformat} > {noformat} > ... > |# Storage Information | > | | > |Compressed: |No > | | > |Storage Desc Parameters: | > | | > | path > |file:/Users/xiaoli/IdeaProjects/sparkDelivery/spark-warehouse/tab1| | > | url > |jdbc:h2:mem:testdb0;user=testUser;password=testPass | | > | dbtable |TEST.PEOPLE > | | > | user |testUser > | | > | password |testPass > | | > +----------------------------+------------------------------------------------------------------+-------+ > {noformat} > {noformat} > DESC EXTENDED tab1 > {noformat} > {noformat} > ... > Storage(Properties: > [path=file:/Users/xiaoli/IdeaProjects/sparkDelivery/spark-warehouse/tab1, > url=jdbc:h2:mem:testdb0;user=testUser;password=testPass, dbtable=TEST.PEOPLE, > user=testUser, password=testPass]))| | > {noformat} > {noformat} > CREATE TEMP VIEW tab1 USING org.apache.spark.sql.jdbc > {noformat} > {noformat} > == Physical Plan == > ExecutedCommand > +- CreateTempViewUsing `tab1`, false, org.apache.spark.sql.jdbc, Map(url > -> jdbc:h2:mem:testdb0;user=testUser;password=testPass, dbtable -> > TEST.PEOPLE, user -> testUser, password -> testPass) > {noformat} -- This message was sent by Atlassian JIRA (v6.3.4#6332) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org