NDV time comparision

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
1				Double for HllFinalEstimate								Float for HllFinalEstimate
2				NDV estimation		Time for Query with NDV (seconds)						NDV estimation		Time for Query with NDV (seconds)						average time	est error
3	Column Name	Column Type	count(distinct col)	ndv(col)	est error	t1	t2	t3	t4	t5	average	ndv(col)	est error	t1	t2	t3	t4	t5	average	change	change
4	l_orderkey	bigint	225,000,000	222,591,794	-2,408,206	4.53	4.65	4.63	4.53	4.52	4.572	222,591,808	-2,408,192	4.64	4.63	4.53	4.63	4.53	4.592	-0.02	14
5	l_partkey	bigint	30,000,000	29,529,401	-470,599	5.53	5.43	5.53	5.63	5.33	5.49	29,529,404	-470,596	5.65	5.54	5.54	5.43	5.53	5.538	-0.048	3
6	l_suppkey	bitint	1,500,000	1,586,165	86,165	5.53	5.63	5.33	5.53	5.64	5.532	1,586,165	86,165	5.13	5.53	5.43	5.53	5.53	5.43	0.102	0
7	l_linenumber	int	7	7	0	3.45	3.62	3.42	3.62	3.42	3.506	7	0	3.42	3.46	3.52	3.53	3.42	3.47	0.036	0
8	l_quantity	decimal(12,2)	50	51	1	3.22	3.22	3.22	3.22	3.23	3.222	51	1	3.22	3.33	3.33	3.22	3.43	3.306	-0.084	0
9	l_extendedprice	decimal(12,2)	3,789,645	3,651,382	-138,263	5.34	5.33	5.03	5.34	4.43	5.094	3,651,382	-138,263	5.44	4.83	5.43	4.93	5.03	5.132	-0.038	0
10	l_discount	decimal(12,2)	11	11	0	3.12	3.22	3.12	3.12	3.22	3.16	11	0	3.23	3.22	3.22	3.23	3.22	3.224	-0.064	0
11	l_tax	decimal(12,2)	9	9	0	3.12	3.22	3.22	3.12	3.22	3.18	9	0	3.22	3.24	3.37	3.22	3.22	3.254	-0.074	0
12	l_returnflag	string	3	3	0	4.12	4.13	4.12	4.12	4.13	4.124	3	0	4.22	4.23	4.13	4.13	4.12	4.166	-0.042	0
13	l_linestatus	string	2	2	0	4.22	4.23	4.23	4.12	4.22	4.204	2	0	4.32	4.33	4.22	4.32	4.32	4.302	-0.098	0
14	l_shipdate	string	2,526	2,629	103	5.43	5.43	5.43	5.43	5.44	5.432	2,629	103	5.33	5.43	5.32	5.33	5.43	5.368	0.064	0
15	l_commitdate	string	2,466	2,559	93	5.43	5.33	5.43	5.53	5.53	5.45	2,559	93	5.43	5.43	5.43	5.44	5.33	5.412	0.038	0
16	l_receiptdate	string	2,555	2,659	104	5.53	5.53	5.43	5.43	5.43	5.47	2,659	104	5.43	5.33	5.33	5.43	5.43	5.39	0.08	0
17	l_shipinstruct	string	4	4	0	5.63	5.73	5.63	5.63	5.53	5.63	4	0	5.63	5.63	5.53	5.53	5.53	5.57	0.06	0
18	l_shipmode	string	7	7	0	5.33	5.33	5.23	5.23	5.33	5.29	7	0	5.33	5.33	5.33	5.32	5.23	5.308	-0.018	0
19	l_comment	string	147,685,493	148,720,605	1,035,112	15.06	15.05	15.05	15.55	15.56	15.254	148,720,608	1,035,115	15.05	15.05	15.05	15.06	15.06	15.054	0.2	-3
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100