dongjoon-hyun commented on PR #38180:
URL: https://github.com/apache/spark/pull/38180#issuecomment-1272766758

   @cloud-fan . Apache Spark CTAS with `STORED BY ... TBLPROPERTIES` table has 
been simply consistent with `CREATE TABLE` + `INSERT INTO` like the following.
   ```
   spark-sql> CREATE TABLE t(a int) STORED AS PARQUET TBLPROPERTIES 
(parquet.compression 'zstd');
   spark-sql> INSERT INTO t VALUES(1);
   ```
   
   ```
   $ ls -al spark-warehouse/t
   total 24
   drwxr-xr-x  6 dongjoon  staff  192 Oct  9 21:13 .
   drwxr-xr-x  3 dongjoon  staff   96 Oct  9 21:13 ..
   -rw-r--r--  1 dongjoon  staff    8 Oct  9 21:13 ._SUCCESS.crc
   -rw-r--r--  1 dongjoon  staff   12 Oct  9 21:13 
.part-00000-0a4b4b66-8970-4223-8263-18d35c3eee43-c000.zstd.parquet.crc
   -rw-r--r--  1 dongjoon  staff    0 Oct  9 21:13 _SUCCESS
   -rw-r--r--  1 dongjoon  staff  450 Oct  9 21:13 
part-00000-0a4b4b66-8970-4223-8263-18d35c3eee43-c000.zstd.parquet
   ```


-- 
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