USE tpch1;
select cidx, cbigint, avg(cbigint) from datatypetestm group by cidx, cbigint order by 1;
cidx	cbigint	avg(cbigint)
1	-72036854775806	-72036854775806.0000
2	-72036854775805	-72036854775805.0000
3	-72036854775804	-72036854775804.0000
4	-72036854775803	-72036854775803.0000
5	-72036854775802	-72036854775802.0000
6	72036854775803	72036854775803.0000
7	72036854775804	72036854775804.0000
8	72036854775805	72036854775805.0000
9	72036854775806	72036854775806.0000
10	72036854775807	72036854775807.0000
11	0	0.0000
select avg(cbigint) from datatypetestm where cidx=1;
avg(cbigint)
-72036854775806.0000