Skip to content

Instantly share code, notes, and snippets.

@aaneja

aaneja/show_stats_all.sql

Last active August 15, 2022 18:48
Show Gist options
  • Save aaneja/ca9b6e9f7b1db37765bd821430953212 to your computer and use it in GitHub Desktop.
Save aaneja/ca9b6e9f7b1db37765bd821430953212 to your computer and use it in GitHub Desktop.
Download ZIP
Presto PR 18188 : SF100 Stats from TPCH connector v. Stats from materialized table
Raw
show_stats_all.sql
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;
Raw
tpchconnector_stats.csv
column_name data_size distinct_values_count nulls_fraction row_count low_value high_value
custkey 1.499975E7 0.0 1 15000000
name 2.7E8 1.4998473E7 0.0
address 3.74970931E8 1.5002076E7 0.0
nationkey 25.0 0.0 0 24
phone 2.25E8 1.4997799E7 0.0
acctbal 1100167.0 0.0 -999.99 9999.99
mktsegment 1.3500267E8 5.0 0.0
comment 1.087296976E9 1.4668583E7 0.0
1.5E7
column_name data_size distinct_values_count nulls_fraction row_count low_value high_value
orderkey 1.50095531E8 0.0 1 600000000
partkey 2.0000911E7 0.0 1 20000000
suppkey 1000029.0 0.0 1 1000000
linenumber 7.0 0.0 1 7
quantity 50.0 0.0 1.0 50.0
extendedprice 3786171.0 0.0 900.05 104948.5
discount 11.0 0.0 0.0 0.1
tax 9.0 0.0 0.0 0.08
returnflag 6.00037902E8 3.0 0.0
linestatus 6.00037902E8 2.0 0.0
shipdate 2526.0 0.0 1992-01-02 1998-12-01
commitdate 2466.0 0.0 1992-01-31 1998-10-31
receiptdate 2555.0 0.0 1992-01-03 1998-12-31
shipinstruct 7.200336912E9 4.0 0.0
shipmode 2.571562204E9 7.0 0.0
comment 1.5900892603E10 1.42684829E8 0.0
6.00037902E8
column_name data_size distinct_values_count nulls_fraction row_count low_value high_value
nationkey 25.0 0.0 0 24
name 177.0 25.0 0.0
regionkey 5.0 0.0 0 4
comment 1857.0 25.0 0.0
25.0
column_name data_size distinct_values_count nulls_fraction row_count low_value high_value
orderkey 1.50095531E8 0.0 1 600000000
custkey 9999299.0 0.0 1 14999999
orderstatus 1.5E8 3.0 0.0
totalprice 3.4698168E7 0.0 811.73 591036.15
orderdate 2406.0 0.0 1992-01-01 1998-08-02
orderpriority 1.260024804E9 5.0 0.0
clerk 2.25E9 100000.0 0.0
shippriority 1.0 0.0 0 0
comment 7.275038709E9 1.11649911E8 0.0
1.5E8
column_name data_size distinct_values_count nulls_fraction row_count low_value high_value
partkey 2.0000911E7 0.0 1 20000000
name 6.54983885E8 1.9984907E7 0.0
mfgr 2.8E8 5.0 0.0
brand 1.6E8 25.0 0.0
type 4.11999154E8 150.0 0.0
size 50.0 0.0 1 50
container 1.51492985E8 40.0 0.0
retailprice 119899.0 0.0 900.01 2098.99
comment 2.69975443E8 3945080.0 0.0
2.0E7
column_name data_size distinct_values_count nulls_fraction row_count low_value high_value
partkey 2.0000911E7 0.0 1 20000000
suppkey 1000029.0 0.0 1 1000000
availqty 9999.0 0.0 1 9999
supplycost 99901.0 0.0 1.0 1000.0
comment 9.880047603E9 7.1830185E7 0.0
8.0E7
column_name data_size distinct_values_count nulls_fraction row_count low_value high_value
regionkey 5.0 0.0 0 4
name 34.0 5.0 0.0
comment 330.0 5.0 0.0
5.0
column_name data_size distinct_values_count nulls_fraction row_count low_value high_value
suppkey 1000029.0 0.0 1 1000000
name 1.8E7 999962.0 0.0
address 2.499728E7 999787.0 0.0
nationkey 25.0 0.0 0 24
phone 1.5E7 999937.0 0.0
acctbal 656927.0 0.0 -999.99 9999.98
comment 6.2495624E7 997812.0 0.0
1000000.0
Raw
tpchconnector_stats_ctas.csv
column_name data_size distinct_values_count nulls_fraction row_count low_value high_value
custkey 1.5E7 0.0 1 15000000
name 2.7E8 1.4846457E7 0.0
address 3.74970931E8 1.5E7 0.0
nationkey 25.0 0.0 0 24
phone 2.25E8 1.5E7 0.0
acctbal 1106028.0 0.0 -999.99 9999.99
mktsegment 1.3500267E8 5.0 0.0
comment 1.087296976E9 1.5E7 0.0
1.5E7
column_name data_size distinct_values_count nulls_fraction row_count low_value high_value
orderkey 1.54258345E8 0.0 1 600000000
partkey 2.0E7 0.0 1 20000000
suppkey 981802.0 0.0 1 1000000
linenumber 7.0 0.0 1 7
quantity 50.0 0.0 1.0 50.0
extendedprice 3967846.0 0.0 900.05 104948.5
discount 11.0 0.0 0.0 0.1
tax 9.0 0.0 0.0 0.08
returnflag 6.00037902E8 3.0 0.0
linestatus 6.00037902E8 2.0 0.0
shipdate 2526.0 0.0 1992-01-02 1998-12-01
commitdate 2466.0 0.0 1992-01-31 1998-10-31
receiptdate 2555.0 0.0 1992-01-03 1998-12-31
shipinstruct 7.200336912E9 4.0 0.0
shipmode 2.571562204E9 7.0 0.0
comment 1.5900892603E10 1.41212774E8 0.0
6.00037902E8
column_name data_size distinct_values_count nulls_fraction row_count low_value high_value
nationkey 25.0 0.0 0 24
name 177.0 25.0 0.0
regionkey 5.0 0.0 0 4
comment 1857.0 25.0 0.0
25.0
column_name data_size distinct_values_count nulls_fraction row_count low_value high_value
orderkey 1.5E8 0.0 1 600000000
custkey 1.0165457E7 0.0 1 14999999
orderstatus 1.5E8 3.0 0.0
totalprice 3.4038282E7 0.0 811.73 591036.15
orderdate 2406.0 0.0 1992-01-01 1998-08-02
orderpriority 1.2600248040000002E9 5.0 0.0
clerk 2.25E9 100816.0 0.0
shippriority 1.0 0.0 0 0
comment 7.275038709E9 1.12463191E8 0.0
1.5E8
column_name data_size distinct_values_count nulls_fraction row_count low_value high_value
partkey 2.0E7 0.0 1 20000000
name 6.54983885E8 1.9686287E7 0.0
mfgr 2.8E8 5.0 0.0
brand 1.6E8 25.0 0.0
type 4.11999154E8 150.0 0.0
size 50.0 0.0 1 50
container 1.51492985E8 40.0 0.0
retailprice 123107.0 0.0 900.01 2098.99
comment 2.69975443E8 3873633.0 0.0
2.0E7
column_name data_size distinct_values_count nulls_fraction row_count low_value high_value
partkey 2.0E7 0.0 1 20000000
suppkey 981802.0 0.0 1 1000000
availqty 9999.0 0.0 1 9999
supplycost 99719.0 0.0 1.0 1000.0
comment 9.880047603E9 7.1268562E7 0.0
8.0E7
column_name data_size distinct_values_count nulls_fraction row_count low_value high_value
regionkey 5.0 0.0 0 4
name 34.0 5.0 0.0
comment 330.0 5.0 0.0
5.0
column_name data_size distinct_values_count nulls_fraction row_count low_value high_value
suppkey 981802.0 0.0 1 1000000
name 1.8E7 970862.0 0.0
address 2.499728E7 992449.0 0.0
nationkey 25.0 0.0 0 24
phone 1.5E7 1000000.0 0.0
acctbal 641174.0 0.0 -999.99 9999.98
comment 6.2495624E7 1000000.0 0.0
1000000.0
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment