cfmcgrady opened a new pull request, #3877:
URL: https://github.com/apache/incubator-kyuubi/pull/3877
<!--
Thanks for sending a pull request!
Here are some tips for you:
1. If this is your first time, please read our contributor guidelines:
https://kyuubi.readthedocs.io/en/latest/community/CONTRIBUTING.html
2. If the PR is related to an issue in
https://github.com/apache/incubator-kyuubi/issues, add '[KYUUBI #XXXX]' in your
PR title, e.g., '[KYUUBI #XXXX] Your PR title ...'.
3. If the PR is unfinished, add '[WIP]' in your PR title, e.g.,
'[WIP][KYUUBI #XXXX] Your PR title ...'.
-->
### _Why are the changes needed?_
<!--
Please clarify why the changes are needed. For instance,
1. If you add a feature, you can talk about the use case of it.
2. If you fix a bug, you can clarify why it is a bug.
-->
## Local Test
### Input dataset
```
spark.sql(
"""
|select * from tpcds.sf10.catalog_sales limit 2000000
|""".stripMargin)
.write
.mode("overwrite")
.save("/tmp/parquet/tpcds/sf10/catalog_sales_2000000")
```
### Query
cat /tmp/b.sql
```sql
select * from parquet.`/tmp/parquet/tpcds/sf10/catalog_sales_2000000`;
```
### Beeline command
```
bin/beeline -u 'jdbc:hive2://${remote-ip}:10009/;' --hiveconf
kyuubi.operation.result.codec=arrow --hiveconf
kyuubi.operation.incremental.collect=true --hiveconf
kyuubi.operation.result.compression.codec=gzip/lz4/zstd/snappy -f /tmp/b.sql >
/dev/null
```
### Result
| kyuubi.operation.result.compression.codec | time spent (round 1) | time
spent (round 2) |
| --- | --- | --- |
| lz4 | 116.563 seconds | 114.017 seconds |
| snappy | 117.992 seconds | 122.061 seconds |
| zstd | 107.774 seconds | 108.832 seconds |
| gzip | 143.361 seconds | 141.129 seconds |
| none | 183.002 seconds| 169.164 seconds |
--
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]
