github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/opt/memo/testdata/stats_quality/tpch/q01 (about) 1 import file=tpch_schema 2 ---- 3 4 import file=tpch_stats 5 ---- 6 7 # -------------------------------------------------- 8 # Q1 9 # Pricing Summary Report 10 # Reports the amount of business that was billed, shipped, and returned. 11 # 12 # Provides a summary pricing report for all lineitems shipped as of a given 13 # date. The date is within 60 - 120 days of the greatest ship date contained in 14 # the database. The query lists totals for extended price, discounted extended 15 # price, discounted extended price plus tax, average quantity, average extended 16 # price, and average discount. These aggregates are grouped by RETURNFLAG and 17 # LINESTATUS, and listed in ascending order of RETURNFLAG and LINESTATUS. A 18 # count of the number of lineitems in each group is included. 19 # -------------------------------------------------- 20 save-tables database=tpch save-tables-prefix=q1 21 SELECT 22 l_returnflag, 23 l_linestatus, 24 sum(l_quantity) AS sum_qty, 25 sum(l_extendedprice) AS sum_base_price, 26 sum(l_extendedprice * (1 - l_discount)) AS sum_disc_price, 27 sum(l_extendedprice * (1 - l_discount) * (1 + l_tax)) AS sum_charge, 28 avg(l_quantity) AS avg_qty, 29 avg(l_extendedprice) AS avg_price, 30 avg(l_discount) AS avg_disc, 31 count(*) AS count_order 32 FROM 33 lineitem 34 WHERE 35 l_shipdate <= DATE '1998-12-01' - INTERVAL '90' DAY 36 GROUP BY 37 l_returnflag, 38 l_linestatus 39 ORDER BY 40 l_returnflag, 41 l_linestatus; 42 ---- 43 sort 44 ├── save-table-name: q1_sort_1 45 ├── columns: l_returnflag:9(char!null) l_linestatus:10(char!null) sum_qty:17(float!null) sum_base_price:18(float!null) sum_disc_price:20(float!null) sum_charge:22(float!null) avg_qty:23(float!null) avg_price:24(float!null) avg_disc:25(float!null) count_order:26(int!null) 46 ├── stats: [rows=6, distinct(9)=3, null(9)=0, distinct(10)=2, null(10)=0, distinct(17)=6, null(17)=0, distinct(18)=6, null(18)=0, distinct(20)=6, null(20)=0, distinct(22)=6, null(22)=0, distinct(23)=6, null(23)=0, distinct(24)=6, null(24)=0, distinct(25)=6, null(25)=0, distinct(26)=6, null(26)=0, distinct(9,10)=6, null(9,10)=0] 47 ├── key: (9,10) 48 ├── fd: (9,10)-->(17,18,20,22-26) 49 ├── ordering: +9,+10 50 └── group-by 51 ├── save-table-name: q1_group_by_2 52 ├── columns: l_returnflag:9(char!null) l_linestatus:10(char!null) sum:17(float!null) sum:18(float!null) sum:20(float!null) sum:22(float!null) avg:23(float!null) avg:24(float!null) avg:25(float!null) count_rows:26(int!null) 53 ├── grouping columns: l_returnflag:9(char!null) l_linestatus:10(char!null) 54 ├── stats: [rows=6, distinct(9)=3, null(9)=0, distinct(10)=2, null(10)=0, distinct(17)=6, null(17)=0, distinct(18)=6, null(18)=0, distinct(20)=6, null(20)=0, distinct(22)=6, null(22)=0, distinct(23)=6, null(23)=0, distinct(24)=6, null(24)=0, distinct(25)=6, null(25)=0, distinct(26)=6, null(26)=0, distinct(9,10)=6, null(9,10)=0] 55 ├── key: (9,10) 56 ├── fd: (9,10)-->(17,18,20,22-26) 57 ├── project 58 │ ├── save-table-name: q1_project_3 59 │ ├── columns: column19:19(float!null) column21:21(float!null) l_quantity:5(float!null) l_extendedprice:6(float!null) l_discount:7(float!null) l_returnflag:9(char!null) l_linestatus:10(char!null) 60 │ ├── stats: [rows=5925056.21, distinct(5)=50, null(5)=0, distinct(6)=925955, null(6)=0, distinct(7)=11, null(7)=0, distinct(9)=3, null(9)=0, distinct(10)=2, null(10)=0, distinct(19)=5925056.21, null(19)=0, distinct(21)=5925056.21, null(21)=0, distinct(9,10)=6, null(9,10)=0] 61 │ ├── select 62 │ │ ├── save-table-name: q1_select_4 63 │ │ ├── columns: l_quantity:5(float!null) l_extendedprice:6(float!null) l_discount:7(float!null) l_tax:8(float!null) l_returnflag:9(char!null) l_linestatus:10(char!null) l_shipdate:11(date!null) 64 │ │ ├── stats: [rows=5925056.21, distinct(5)=50, null(5)=0, distinct(6)=925955, null(6)=0, distinct(7)=11, null(7)=0, distinct(8)=9, null(8)=0, distinct(9)=3, null(9)=0, distinct(10)=2, null(10)=0, distinct(11)=2435, null(11)=0, distinct(6,7)=5925056.21, null(6,7)=0, distinct(9,10)=6, null(9,10)=0, distinct(6-8)=5925056.21, null(6-8)=0] 65 │ │ │ histogram(11)= 0 600 28805 2400 28205 1800 28805 2400 27605 3000 28805 1800 27605 3000 28805 1800 27605 2400 28205 4200 29405 1800 28205 2400 29405 2400 29405 4200 28205 4800 28805 1800 29405 1200 28805 1800 29405 5401 29405 3000 28805 2400 28205 1800 29405 3000 28205 1200 29405 2400 25205 6601 23404 7201 28205 3600 28205 3000 28205 2400 27605 3600 28205 3000 28805 2400 26405 4200 26405 3000 28805 2400 28205 1800 27605 1800 28805 600 28205 3000 27605 5401 27605 3600 28205 4800 25805 3600 27605 2400 28205 3600 25805 3600 27605 3000 26405 4200 28805 3000 28805 3000 28805 1200 25205 4200 25805 3600 25805 3600 26405 3600 28805 1200 27605 2400 27005 3600 28805 1200 27005 4800 28205 3000 25205 4800 28805 4800 28805 600 28205 1200 24604 6601 24604 4800 28205 3600 27605 3600 27005 4200 28205 2400 28205 4200 28805 1200 28205 1800 28205 1200 28205 3000 27005 4800 28805 600 27005 3600 25805 5401 27005 2400 28205 3000 27605 2400 24004 5401 28805 3600 27005 2400 28205 3000 27005 3600 28805 3600 28205 1800 28805 1800 28805 2400 25205 5401 27605 3600 28205 3000 27005 2400 28805 4800 27005 3000 28205 3600 28805 3000 26405 3000 27605 1800 28205 3600 28205 2400 28205 1200 28205 1200 27005 2400 25805 5401 27005 4800 24004 6001 27005 3000 28205 600 27005 3600 28205 2400 25805 3600 26405 4800 25805 3000 27005 3600 27005 3000 27605 3600 27005 5401 28205 2400 27005 3600 28205 600 24004 5401 28205 1200 27605 1800 26405 5401 28205 3600 26405 3600 28205 1200 27005 1800 27005 4800 28205 1200 26405 2400 26405 6601 26405 3000 27605 4200 26405 2400 28205 3000 27005 3600 27605 1200 26405 3600 25205 4800 27605 4200 25205 3000 27605 3000 26405 2400 24604 3600 26405 4800 26405 3600 24604 4200 26405 1800 27605 3600 27605 1800 27605 1200 26405 1800 26405 3000 25805 3000 25805 3000 24004 4200 27005 1800 27605 3000 25805 4200 26405 3600 25205 4200 25205 5401 26405 3600 27005 2400 26405 3000 24604 3000 26405 1800 25805 2400 24004 3600 25805 3000 25805 4200 25805 2400 24004 3600 25805 1800 26405 1800 27005 4200 26405 2400 26405 2400 25805 1800 26405 2400 25805 2400 25805 3000 26405 2400 25805 1200 23404 4200 25205 4200 25805 2400 24004 3000 25205 1800 26405 1800 25205 5401 0 1257 66 │ │ │ <--- '1992-01-03' ------- '1992-02-23' ------- '1992-03-18' ------- '1992-04-07' ------- '1992-04-22' ------- '1992-05-06' ------- '1992-05-19' ------- '1992-05-31' ------- '1992-06-15' ------- '1992-06-29' ------- '1992-07-11' ------- '1992-07-24' ------- '1992-08-05' ------- '1992-08-17' ------- '1992-08-29' ------- '1992-09-10' ------- '1992-09-24' ------- '1992-10-10' ------- '1992-10-22' ------- '1992-11-05' ------- '1992-11-17' ------- '1992-11-28' ------- '1992-12-10' ------- '1992-12-22' ------- '1993-01-02' ------- '1993-01-10' ------- '1993-01-24' ------- '1993-02-06' ------- '1993-02-20' ------- '1993-03-06' ------- '1993-03-19' ------- '1993-04-02' ------- '1993-04-17' ------- '1993-05-02' ------- '1993-05-13' ------- '1993-05-26' ------- '1993-06-07' ------- '1993-06-21' ------- '1993-07-06' ------- '1993-07-19' ------- '1993-08-02' ------- '1993-08-16' ------- '1993-08-30' ------- '1993-09-11' ------- '1993-09-21' ------- '1993-10-07' ------- '1993-10-19' ------- '1993-10-30' ------- '1993-11-11' ------- '1993-11-24' ------- '1993-12-09' ------- '1993-12-24' ------- '1994-01-02' ------- '1994-01-16' ------- '1994-01-30' ------- '1994-02-08' ------- '1994-02-18' ------- '1994-03-04' ------- '1994-03-15' ------- '1994-03-29' ------- '1994-04-10' ------- '1994-04-24' ------- '1994-05-03' ------- '1994-05-13' ------- '1994-05-24' ------- '1994-06-04' ------- '1994-06-13' ------- '1994-06-22' ------- '1994-07-05' ------- '1994-07-16' ------- '1994-07-29' ------- '1994-08-09' ------- '1994-08-22' ------- '1994-09-04' ------- '1994-09-15' ------- '1994-09-29' ------- '1994-10-10' ------- '1994-10-20' ------- '1994-11-03' ------- '1994-11-16' ------- '1994-11-29' ------- '1994-12-11' ------- '1994-12-25' ------- '1995-01-07' ------- '1995-01-18' ------- '1995-01-31' ------- '1995-02-12' ------- '1995-02-23' ------- '1995-03-04' ------- '1995-03-16' ------- '1995-03-29' ------- '1995-04-09' ------- '1995-04-22' ------- '1995-05-05' ------- '1995-05-20' ------- '1995-05-31' ------- '1995-06-13' ------- '1995-06-25' ------- '1995-07-07' ------- '1995-07-22' ------- '1995-08-04' ------- '1995-08-16' ------- '1995-08-29' ------- '1995-09-09' ------- '1995-09-20' ------- '1995-10-02' ------- '1995-10-16' ------- '1995-10-26' ------- '1995-11-03' ------- '1995-11-16' ------- '1995-11-28' ------- '1995-12-08' ------- '1995-12-19' ------- '1995-12-31' ------- '1996-01-12' ------- '1996-01-22' ------- '1996-02-01' ------- '1996-02-10' ------- '1996-02-21' ------- '1996-03-02' ------- '1996-03-13' ------- '1996-03-25' ------- '1996-04-06' ------- '1996-04-18' ------- '1996-04-29' ------- '1996-05-10' ------- '1996-05-21' ------- '1996-06-03' ------- '1996-06-15' ------- '1996-06-28' ------- '1996-07-08' ------- '1996-07-23' ------- '1996-08-05' ------- '1996-08-17' ------- '1996-08-29' ------- '1996-09-10' ------- '1996-09-20' ------- '1996-10-03' ------- '1996-10-15' ------- '1996-10-28' ------- '1996-11-10' ------- '1996-11-22' ------- '1996-12-02' ------- '1996-12-17' ------- '1996-12-26' ------- '1997-01-07' ------- '1997-01-19' ------- '1997-01-29' ------- '1997-02-11' ------- '1997-02-23' ------- '1997-03-07' ------- '1997-03-18' ------- '1997-03-28' ------- '1997-04-11' ------- '1997-04-24' ------- '1997-05-05' ------- '1997-05-15' ------- '1997-05-31' ------- '1997-06-10' ------- '1997-06-23' ------- '1997-07-07' ------- '1997-07-19' ------- '1997-07-30' ------- '1997-08-13' ------- '1997-08-23' ------- '1997-09-07' ------- '1997-09-15' ------- '1997-09-26' ------- '1997-10-06' ------- '1997-10-19' ------- '1997-10-30' ------- '1997-11-10' ------- '1997-11-22' ------- '1997-12-02' ------- '1997-12-14' ------- '1997-12-27' ------- '1998-01-06' ------- '1998-01-18' ------- '1998-01-29' ------- '1998-02-10' ------- '1998-02-24' ------- '1998-03-08' ------- '1998-03-19' ------- '1998-04-01' ------- '1998-04-14' ------- '1998-04-25' ------- '1998-05-06' ------- '1998-05-17' ------- '1998-05-29' ------- '1998-06-10' ------- '1998-06-22' ------- '1998-07-04' ------- '1998-07-15' ------- '1998-07-25' ------- '1998-08-05' ------- '1998-08-18' ------- '1998-09-01' --- '1998-09-02' 67 │ │ ├── scan lineitem 68 │ │ │ ├── save-table-name: q1_scan_5 69 │ │ │ ├── columns: l_quantity:5(float!null) l_extendedprice:6(float!null) l_discount:7(float!null) l_tax:8(float!null) l_returnflag:9(char!null) l_linestatus:10(char!null) l_shipdate:11(date!null) 70 │ │ │ └── stats: [rows=6001215, distinct(5)=50, null(5)=0, distinct(6)=925955, null(6)=0, distinct(7)=11, null(7)=0, distinct(8)=9, null(8)=0, distinct(9)=3, null(9)=0, distinct(10)=2, null(10)=0, distinct(11)=2526, null(11)=0, distinct(6,7)=6001215, null(6,7)=0, distinct(9,10)=6, null(9,10)=0, distinct(6-8)=6001215, null(6-8)=0] 71 │ │ │ histogram(11)= 0 600 28805 2400 28205 1800 28805 2400 27605 3000 28805 1800 27605 3000 28805 1800 27605 2400 28205 4200 29405 1800 28205 2400 29405 2400 29405 4200 28205 4800 28805 1800 29405 1200 28805 1800 29405 5401 29405 3000 28805 2400 28205 1800 29405 3000 28205 1200 29405 2400 25205 6601 23404 7201 28205 3600 28205 3000 28205 2400 27605 3600 28205 3000 28805 2400 26405 4200 26405 3000 28805 2400 28205 1800 27605 1800 28805 600 28205 3000 27605 5401 27605 3600 28205 4800 25805 3600 27605 2400 28205 3600 25805 3600 27605 3000 26405 4200 28805 3000 28805 3000 28805 1200 25205 4200 25805 3600 25805 3600 26405 3600 28805 1200 27605 2400 27005 3600 28805 1200 27005 4800 28205 3000 25205 4800 28805 4800 28805 600 28205 1200 24604 6601 24604 4800 28205 3600 27605 3600 27005 4200 28205 2400 28205 4200 28805 1200 28205 1800 28205 1200 28205 3000 27005 4800 28805 600 27005 3600 25805 5401 27005 2400 28205 3000 27605 2400 24004 5401 28805 3600 27005 2400 28205 3000 27005 3600 28805 3600 28205 1800 28805 1800 28805 2400 25205 5401 27605 3600 28205 3000 27005 2400 28805 4800 27005 3000 28205 3600 28805 3000 26405 3000 27605 1800 28205 3600 28205 2400 28205 1200 28205 1200 27005 2400 25805 5401 27005 4800 24004 6001 27005 3000 28205 600 27005 3600 28205 2400 25805 3600 26405 4800 25805 3000 27005 3600 27005 3000 27605 3600 27005 5401 28205 2400 27005 3600 28205 600 24004 5401 28205 1200 27605 1800 26405 5401 28205 3600 26405 3600 28205 1200 27005 1800 27005 4800 28205 1200 26405 2400 26405 6601 26405 3000 27605 4200 26405 2400 28205 3000 27005 3600 27605 1200 26405 3600 25205 4800 27605 4200 25205 3000 27605 3000 26405 2400 24604 3600 26405 4800 26405 3600 24604 4200 26405 1800 27605 3600 27605 1800 27605 1200 26405 1800 26405 3000 25805 3000 25805 3000 24004 4200 27005 1800 27605 3000 25805 4200 26405 3600 25205 4200 25205 5401 26405 3600 27005 2400 26405 3000 24604 3000 26405 1800 25805 2400 24004 3600 25805 3000 25805 4200 25805 2400 24004 3600 25805 1800 26405 1800 27005 4200 26405 2400 26405 2400 25805 1800 26405 2400 25805 2400 25805 3000 26405 2400 25805 1200 23404 4200 25205 4200 25805 2400 24004 3000 25205 1800 26405 1800 25205 5401 25205 1800 23404 1800 24604 600 72 │ │ │ <--- '1992-01-03' ------- '1992-02-23' ------- '1992-03-18' ------- '1992-04-07' ------- '1992-04-22' ------- '1992-05-06' ------- '1992-05-19' ------- '1992-05-31' ------- '1992-06-15' ------- '1992-06-29' ------- '1992-07-11' ------- '1992-07-24' ------- '1992-08-05' ------- '1992-08-17' ------- '1992-08-29' ------- '1992-09-10' ------- '1992-09-24' ------- '1992-10-10' ------- '1992-10-22' ------- '1992-11-05' ------- '1992-11-17' ------- '1992-11-28' ------- '1992-12-10' ------- '1992-12-22' ------- '1993-01-02' ------- '1993-01-10' ------- '1993-01-24' ------- '1993-02-06' ------- '1993-02-20' ------- '1993-03-06' ------- '1993-03-19' ------- '1993-04-02' ------- '1993-04-17' ------- '1993-05-02' ------- '1993-05-13' ------- '1993-05-26' ------- '1993-06-07' ------- '1993-06-21' ------- '1993-07-06' ------- '1993-07-19' ------- '1993-08-02' ------- '1993-08-16' ------- '1993-08-30' ------- '1993-09-11' ------- '1993-09-21' ------- '1993-10-07' ------- '1993-10-19' ------- '1993-10-30' ------- '1993-11-11' ------- '1993-11-24' ------- '1993-12-09' ------- '1993-12-24' ------- '1994-01-02' ------- '1994-01-16' ------- '1994-01-30' ------- '1994-02-08' ------- '1994-02-18' ------- '1994-03-04' ------- '1994-03-15' ------- '1994-03-29' ------- '1994-04-10' ------- '1994-04-24' ------- '1994-05-03' ------- '1994-05-13' ------- '1994-05-24' ------- '1994-06-04' ------- '1994-06-13' ------- '1994-06-22' ------- '1994-07-05' ------- '1994-07-16' ------- '1994-07-29' ------- '1994-08-09' ------- '1994-08-22' ------- '1994-09-04' ------- '1994-09-15' ------- '1994-09-29' ------- '1994-10-10' ------- '1994-10-20' ------- '1994-11-03' ------- '1994-11-16' ------- '1994-11-29' ------- '1994-12-11' ------- '1994-12-25' ------- '1995-01-07' ------- '1995-01-18' ------- '1995-01-31' ------- '1995-02-12' ------- '1995-02-23' ------- '1995-03-04' ------- '1995-03-16' ------- '1995-03-29' ------- '1995-04-09' ------- '1995-04-22' ------- '1995-05-05' ------- '1995-05-20' ------- '1995-05-31' ------- '1995-06-13' ------- '1995-06-25' ------- '1995-07-07' ------- '1995-07-22' ------- '1995-08-04' ------- '1995-08-16' ------- '1995-08-29' ------- '1995-09-09' ------- '1995-09-20' ------- '1995-10-02' ------- '1995-10-16' ------- '1995-10-26' ------- '1995-11-03' ------- '1995-11-16' ------- '1995-11-28' ------- '1995-12-08' ------- '1995-12-19' ------- '1995-12-31' ------- '1996-01-12' ------- '1996-01-22' ------- '1996-02-01' ------- '1996-02-10' ------- '1996-02-21' ------- '1996-03-02' ------- '1996-03-13' ------- '1996-03-25' ------- '1996-04-06' ------- '1996-04-18' ------- '1996-04-29' ------- '1996-05-10' ------- '1996-05-21' ------- '1996-06-03' ------- '1996-06-15' ------- '1996-06-28' ------- '1996-07-08' ------- '1996-07-23' ------- '1996-08-05' ------- '1996-08-17' ------- '1996-08-29' ------- '1996-09-10' ------- '1996-09-20' ------- '1996-10-03' ------- '1996-10-15' ------- '1996-10-28' ------- '1996-11-10' ------- '1996-11-22' ------- '1996-12-02' ------- '1996-12-17' ------- '1996-12-26' ------- '1997-01-07' ------- '1997-01-19' ------- '1997-01-29' ------- '1997-02-11' ------- '1997-02-23' ------- '1997-03-07' ------- '1997-03-18' ------- '1997-03-28' ------- '1997-04-11' ------- '1997-04-24' ------- '1997-05-05' ------- '1997-05-15' ------- '1997-05-31' ------- '1997-06-10' ------- '1997-06-23' ------- '1997-07-07' ------- '1997-07-19' ------- '1997-07-30' ------- '1997-08-13' ------- '1997-08-23' ------- '1997-09-07' ------- '1997-09-15' ------- '1997-09-26' ------- '1997-10-06' ------- '1997-10-19' ------- '1997-10-30' ------- '1997-11-10' ------- '1997-11-22' ------- '1997-12-02' ------- '1997-12-14' ------- '1997-12-27' ------- '1998-01-06' ------- '1998-01-18' ------- '1998-01-29' ------- '1998-02-10' ------- '1998-02-24' ------- '1998-03-08' ------- '1998-03-19' ------- '1998-04-01' ------- '1998-04-14' ------- '1998-04-25' ------- '1998-05-06' ------- '1998-05-17' ------- '1998-05-29' ------- '1998-06-10' ------- '1998-06-22' ------- '1998-07-04' ------- '1998-07-15' ------- '1998-07-25' ------- '1998-08-05' ------- '1998-08-18' ------- '1998-09-01' ------- '1998-09-22' ------- '1998-10-13' ------- '1998-11-26' 73 │ │ └── filters 74 │ │ └── l_shipdate:11 <= '1998-09-02' [type=bool, outer=(11), constraints=(/11: (/NULL - /'1998-09-02']; tight)] 75 │ └── projections 76 │ ├── l_extendedprice:6 * (1.0 - l_discount:7) [as=column19:19, type=float, outer=(6,7)] 77 │ └── (l_extendedprice:6 * (1.0 - l_discount:7)) * (l_tax:8 + 1.0) [as=column21:21, type=float, outer=(6-8)] 78 └── aggregations 79 ├── sum [as=sum:17, type=float, outer=(5)] 80 │ └── l_quantity:5 [type=float] 81 ├── sum [as=sum:18, type=float, outer=(6)] 82 │ └── l_extendedprice:6 [type=float] 83 ├── sum [as=sum:20, type=float, outer=(19)] 84 │ └── column19:19 [type=float] 85 ├── sum [as=sum:22, type=float, outer=(21)] 86 │ └── column21:21 [type=float] 87 ├── avg [as=avg:23, type=float, outer=(5)] 88 │ └── l_quantity:5 [type=float] 89 ├── avg [as=avg:24, type=float, outer=(6)] 90 │ └── l_extendedprice:6 [type=float] 91 ├── avg [as=avg:25, type=float, outer=(7)] 92 │ └── l_discount:7 [type=float] 93 └── count-rows [as=count_rows:26, type=int] 94 95 stats table=q1_sort_1 96 ---- 97 column_names row_count distinct_count null_count 98 {avg_disc} 4 4 0 99 {avg_price} 4 4 0 100 {avg_qty} 4 4 0 101 {count_order} 4 4 0 102 {l_linestatus} 4 2 0 103 {l_returnflag} 4 3 0 104 {sum_base_price} 4 4 0 105 {sum_charge} 4 4 0 106 {sum_disc_price} 4 4 0 107 {sum_qty} 4 4 0 108 ~~~~ 109 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 110 {avg_disc} 6.00 1.50 6.00 1.50 0.00 1.00 111 {avg_price} 6.00 1.50 6.00 1.50 0.00 1.00 112 {avg_qty} 6.00 1.50 6.00 1.50 0.00 1.00 113 {count_order} 6.00 1.50 6.00 1.50 0.00 1.00 114 {l_linestatus} 6.00 1.50 2.00 1.00 0.00 1.00 115 {l_returnflag} 6.00 1.50 3.00 1.00 0.00 1.00 116 {sum_base_price} 6.00 1.50 6.00 1.50 0.00 1.00 117 {sum_charge} 6.00 1.50 6.00 1.50 0.00 1.00 118 {sum_disc_price} 6.00 1.50 6.00 1.50 0.00 1.00 119 {sum_qty} 6.00 1.50 6.00 1.50 0.00 1.00 120 121 stats table=q1_group_by_2 122 ---- 123 column_names row_count distinct_count null_count 124 {avg_1} 4 4 0 125 {avg_2} 4 4 0 126 {avg} 4 4 0 127 {count_rows} 4 4 0 128 {l_linestatus} 4 2 0 129 {l_returnflag} 4 3 0 130 {sum_1} 4 4 0 131 {sum_2} 4 4 0 132 {sum_3} 4 4 0 133 {sum} 4 4 0 134 ~~~~ 135 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 136 {avg} 6.00 1.50 6.00 1.50 0.00 1.00 137 {avg_1} 6.00 1.50 6.00 1.50 0.00 1.00 138 {avg_2} 6.00 1.50 6.00 1.50 0.00 1.00 139 {count_rows} 6.00 1.50 6.00 1.50 0.00 1.00 140 {l_linestatus} 6.00 1.50 2.00 1.00 0.00 1.00 141 {l_returnflag} 6.00 1.50 3.00 1.00 0.00 1.00 142 {sum} 6.00 1.50 6.00 1.50 0.00 1.00 143 {sum_1} 6.00 1.50 6.00 1.50 0.00 1.00 144 {sum_2} 6.00 1.50 6.00 1.50 0.00 1.00 145 {sum_3} 6.00 1.50 6.00 1.50 0.00 1.00 146 147 stats table=q1_project_3 148 ---- 149 column_names row_count distinct_count null_count 150 {column19} 5916591 4150364 0 151 {column21} 5916591 5661182 0 152 {l_discount} 5916591 11 0 153 {l_extendedprice} 5916591 925955 0 154 {l_linestatus} 5916591 2 0 155 {l_quantity} 5916591 50 0 156 {l_returnflag} 5916591 3 0 157 ~~~~ 158 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 159 {column19} 5925056.00 1.00 5925056.00 1.43 0.00 1.00 160 {column21} 5925056.00 1.00 5925056.00 1.05 0.00 1.00 161 {l_discount} 5925056.00 1.00 11.00 1.00 0.00 1.00 162 {l_extendedprice} 5925056.00 1.00 925955.00 1.00 0.00 1.00 163 {l_linestatus} 5925056.00 1.00 2.00 1.00 0.00 1.00 164 {l_quantity} 5925056.00 1.00 50.00 1.00 0.00 1.00 165 {l_returnflag} 5925056.00 1.00 3.00 1.00 0.00 1.00 166 167 stats table=q1_select_4 168 ---- 169 column_names row_count distinct_count null_count 170 {l_discount} 5916591 11 0 171 {l_extendedprice} 5916591 925955 0 172 {l_linestatus} 5916591 2 0 173 {l_quantity} 5916591 50 0 174 {l_returnflag} 5916591 3 0 175 {l_shipdate} 5916591 2436 0 176 {l_tax} 5916591 9 0 177 ~~~~ 178 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 179 {l_discount} 5925056.00 1.00 11.00 1.00 0.00 1.00 180 {l_extendedprice} 5925056.00 1.00 925955.00 1.00 0.00 1.00 181 {l_linestatus} 5925056.00 1.00 2.00 1.00 0.00 1.00 182 {l_quantity} 5925056.00 1.00 50.00 1.00 0.00 1.00 183 {l_returnflag} 5925056.00 1.00 3.00 1.00 0.00 1.00 184 {l_shipdate} 5925056.00 1.00 2435.00 1.00 0.00 1.00 185 {l_tax} 5925056.00 1.00 9.00 1.00 0.00 1.00 186 187 stats table=q1_scan_5 188 ---- 189 column_names row_count distinct_count null_count 190 {l_discount} 6001215 11 0 191 {l_extendedprice} 6001215 925955 0 192 {l_linestatus} 6001215 2 0 193 {l_quantity} 6001215 50 0 194 {l_returnflag} 6001215 3 0 195 {l_shipdate} 6001215 2526 0 196 {l_tax} 6001215 9 0 197 ~~~~ 198 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 199 {l_discount} 6001215.00 1.00 11.00 1.00 0.00 1.00 200 {l_extendedprice} 6001215.00 1.00 925955.00 1.00 0.00 1.00 201 {l_linestatus} 6001215.00 1.00 2.00 1.00 0.00 1.00 202 {l_quantity} 6001215.00 1.00 50.00 1.00 0.00 1.00 203 {l_returnflag} 6001215.00 1.00 3.00 1.00 0.00 1.00 204 {l_shipdate} 6001215.00 1.00 2526.00 1.00 0.00 1.00 205 {l_tax} 6001215.00 1.00 9.00 1.00 0.00 1.00