AngersZhuuuu opened a new pull request, #36495:
URL: https://github.com/apache/spark/pull/36495

   
   ### What changes were proposed in this pull request?
   Currently, when call `DESC EXTENDED` at an JDBCTable, there is no table 
properties, user don't know the related url information.
   ```
   > desc formatted jdbc.test.people;
   NAME string
   ID   int
   
   # Partitioning
   Not partitioned
   
   # Detailed Table Information
   Name test.people
   Table Properties     []
   Time taken: 0.048 seconds, Fetched 9 row(s)
   ``` 
   
   After this pr:
   ```
   
+----------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------+
   |                    col_name|                                               
                                                                                
                                                                                
                       data_type|comment|
   
+----------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------+
   |                        DEPT|                                               
                                                                                
                                                                                
                             int|       |
   |                        NAME|                                               
                                                                                
                                                                                
                          string|       |
   |                      SALARY|                                               
                                                                                
                                                                                
                   decimal(20,2)|       |
   |                       BONUS|                                               
                                                                                
                                                                                
                          double|       |
   |                  IS_MANAGER|                                               
                                                                                
                                                                                
                         boolean|       |
   |                            |                                               
                                                                                
                                                                                
                                |       |
   |              # Partitioning|                                               
                                                                                
                                                                                
                                |       |
   |             Not partitioned|                                               
                                                                                
                                                                                
                                |       |
   |                            |                                               
                                                                                
                                                                                
                                |       |
   |# Detailed Table Information|                                               
                                                                                
                                                                                
                                |       |
   |                        Name|                                               
                                                                                
                                                                                
                   test.employee|       |
   |            Table 
Properties|[dbtable="test"."employee",driver=org.h2.Driver,pushDownAggregate=true,pushDownLimit=true,url=jdbc:h2:/Users/yi.zhu/Documents/project/Angerszhuuuu/spark/target/tmp/spark-f6094e60-b18a-4591-afb5-c284f1700304;user=testUser;password=testPass]|
       |
   
+----------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------+
   ```
   
   
   ### Why are the changes needed?
   When desc JDBCTable, make it can show JDBCOptions as table properties. Make 
user easy to check 
   
   
   ### Does this PR introduce _any_ user-facing change?
   User can use DESC EXTENDED to know JDBCTable's JDBCOptions
   
   
   ### How was this patch tested?
   Added UT


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


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

Reply via email to