Queries are run against a Parquet TPCH SF 1 schema on Presto 0.286 on a single node cluster
Q1
presto:tpch_sf1_parquet> explain select l_quantity from lineitem l, orders o where l_orderkey = o_orderkey and o_totalprice < 1000 and l_quantity < 48;
Anant Aneja aaneja
aaneja
/ run-java
Created
February 22, 2019 22:38
— forked from PetrGlad/run-java
Enable java remote debugger (JDWP, openjdk)
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| java -agentlib:jdwp=transport=dt_socket,address=8000,server=y,suspend=n ClassName |
aaneja
/ show_stats_all.sql
Last active
August 15, 2022 18:48
Presto PR 18188 : SF100 Stats from TPCH connector v. Stats from materialized table
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| show stats for customer ; | |
| show stats for lineitem ; | |
| show stats for nation ; | |
| show stats for orders ; | |
| show stats for part ; | |
| show stats for partsupp ; | |
| show stats for region ; | |
| show stats for supplier; |
aaneja
/ results.txt
Created
August 19, 2022 18:19
net.agkn.hll.HLL v. com.facebook.airlift.stats.cardinality.HyperLogLog
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| net.agkn.hll.HLL cardinality estimate : 100000 | |
| com.facebook.airlift.stats.cardinality.HyperLogLog cardinality estimate : 100426 |
aaneja
/ plan_log_with_filter_pushdown.log
Last active
September 25, 2023 09:14
TPCDS Q9 with and without connector filter pushdown
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 2023-09-25T14:32:22.405+0530 INFO Query-20230925_090220_00000_asxxc-1169 com.facebook.presto.sql.planner.optimizations.LogPlanTreeOptimizer ------ Before ApplyConnectorOptimization | |
| 2023-09-25T14:32:22.409+0530 INFO Query-20230925_090220_00000_asxxc-1169 com.facebook.presto.sql.planner.optimizations.LogPlanTreeOptimizer Plan : | |
| project, Assignments ({expr_449=SWITCH(true, WHEN(GREATER_THAN(count, 74129), avg), avg_64), expr_450=SWITCH(true, WHEN(GREATER_THAN(count_95, 122840), avg_127), avg_159), expr_451=SWITCH(true, WHEN(GREATER_THAN(count_190, 56580), avg_222), avg_254), expr_452=SWITCH(true, WHEN(GREATER_THAN(count_285, 10097), avg_317), avg_349), expr_453=SWITCH(true, WHEN(GREATER_THAN(count_380, 165306), avg_412), avg_444)}), Outputs ([expr_449, expr_450, expr_451, expr_452, expr_453]): | |
| join (INNER), Equi-join condition([]), Filter (Optional.empty), Outputs([r_reason_sk, count, avg, avg_64, count_95, avg_127, avg_159, count_190, avg_222, avg_254, count_285, avg_317, avg_349, count_380, avg_412, avg_44 |
aaneja
/ QuickStats_SelfJoin.json
Created
January 24, 2024 06:26
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Query Plan | |
| --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | |
| { | |
| "id" : "8", |
aaneja
/ cost_based.md
Last active
February 21, 2024 05:17
aaneja
/ cast_vs_nocast_multiple_runs.csv
Last active
March 19, 2024 04:15
Cast performance test for https://github.com/prestodb/presto/issues/22184#issuecomment-1996569271
We can make this file beautiful and searchable if this error is corrected: It looks like row 5 should actually have 9 columns, instead of 6 in line 4.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| "dt","query_id","query","schema_name","catalog_name","environment","query_wall_time_ms","total_split_cpu_time_ms","splits" | |
| "2024-03-19 03:53:16","20240319_035316_00019_bcy7w","explain analyze SELECT CAST(ss_quantity AS decimal(10,0)) FROM hive.tpcds_sf1000_parquet_varchar.store_sales | |
| ",tpcds_sf1000_parquet_varchar,hive,enganantb1022n,24113,153564,1066 | |
| "2024-03-19 03:53:42","20240319_035342_00020_bcy7w","explain analyze SELECT CAST(ss_quantity AS decimal(10,0)) FROM hive.tpcds_sf1000_parquet_varchar.store_sales | |
| ",tpcds_sf1000_parquet_varchar,hive,enganantb1022n,21210,159054,1066 | |
| "2024-03-19 03:54:05","20240319_035405_00021_bcy7w","explain analyze SELECT CAST(ss_quantity AS decimal(10,0)) FROM hive.tpcds_sf1000_parquet_varchar.store_sales | |
| ",tpcds_sf1000_parquet_varchar,hive,enganantb1022n,21156,162602,1065 | |
| "2024-03-19 03:54:28","20240319_035428_00022_bcy7w","explain analyze SELECT CAST(ss_quantity AS decimal(10,0)) FROM hive.tpcds_sf1000_parquet_varchar.store_sales | |
| ",tpcds_sf1000_parquet_varchar,hive,enganantb1 |
aaneja
/ cve_presto_jdk8.md
Created
November 20, 2024 06:52
| CVE-2024-6763 | jetty-http-9.4.54.v20240208.jar | Medium | /opt/presto-server-0.286/plugin/pinot/jetty-http-9.4.54.v20240208.jar |
|---|---|---|---|
| CVE-2012-5783 | commons-httpclient-3.1.jar | Medium | /tmp/ws-scm/presto/presto-pinot/pom.xml |
| CVE-2012-6153 | commons-httpclient-3.1.jar | Low | /tmp/ws-scm/presto/presto-pinot/pom.xml |
Critical and High CVEs regarding Springboot and Spring web dependencies.
| CVE-2022-22965 | spring-beans-4.1.6.RELEASE.jar | Critical | Transitive | /tmp/ws-scm/presto/presto-benchto-benchmarks/pom.xml | |
|---|---|---|---|---|---|
| CVE-2022-27772 | spring-boot-1.2.3.RELEASE.jar | High | Transitive | /tmp/ws-scm/presto/presto-benchto-benchmarks/pom.xml |