LantaoJin opened a new pull request #26466: [SPARK-29839][SQL] Supporting 
STORED AS in CREATE TABLE LIKE
URL: https://github.com/apache/spark/pull/26466
 
 
   ### What changes were proposed in this pull request?
   In SPARK-29421 (#26097) , we can specify a different table provider for 
`CREATE TABLE LIKE` via `USING provider`. 
   Hive support `STORED AS` new file format syntax:
   ```sql
   CREATE TABLE tbl(a int) STORED AS TEXTFILE;
   CREATE TABLE tbl2 LIKE tbl STORED AS PARQUET;
   ```
   For Hive compatibility, we should also support `STORED AS` in `CREATE TABLE 
LIKE`.
   
   ### Why are the changes needed?
   See https://github.com/apache/spark/pull/26097#issue-327424759
   
   ### Does this PR introduce any user-facing change?
   Add a new syntax based on current CTL:
   CREATE TABLE tbl2 LIKE tbl [STORED AS hiveFormat];
   
   
   ### How was this patch tested?
   Add UTs.
   

----------------------------------------------------------------
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.
 
For queries about this service, please contact Infrastructure at:
[email protected]


With regards,
Apache Git Services

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

Reply via email to