HIVE-18359: Extend grouping set limits from int to long (Prasanth Jayachandran review...
[hive.git] / ql / src / test / queries / clientnegative / groupby_grouping_sets8.q
1 create table facts (val string);
2
3 insert into facts values ('abcdefghijklmnopqrstuvwxyz0123456789');
4
5 create table groupingsets65 as
6 select 
7 c00,c01,c02,c03,c04,c05,c06,c07,c08,c09,
8 c10,c11,c12,c13,c14,c15,c16,c17,c18,c19,
9 c20,c21,c22,c23,c24,c25,c26,c27,c28,c29,
10 c30,c31,c32,c33,c34,c35,c36,c37,c38,c39,
11 c40,c41,c42,c43,c44,c45,c46,c47,c48,c49,
12 c50,c51,c52,c53,c54,c55,c56,c57,c58,c59,
13 c60,c61,c62,c63,c64
14 ,count(*) as n from (
15 select
16 substring(val,01,1) as c00,
17 substring(val,02,1) as c01,
18 substring(val,03,1) as c02,
19 substring(val,04,1) as c03,
20 substring(val,05,1) as c04,
21 substring(val,06,1) as c05,
22 substring(val,07,1) as c06,
23 substring(val,08,1) as c07,
24 substring(val,09,1) as c08,
25 substring(val,10,1) as c09,
26 substring(val,11,1) as c10,
27 substring(val,12,1) as c11,
28 substring(val,13,1) as c12,
29 substring(val,14,1) as c13,
30 substring(val,15,1) as c14,
31 substring(val,16,1) as c15,
32 substring(val,17,1) as c16,
33 substring(val,18,1) as c17,
34 substring(val,19,1) as c18,
35 substring(val,20,1) as c19,
36 substring(val,21,1) as c20,
37 substring(val,22,1) as c21,
38 substring(val,23,1) as c22,
39 substring(val,24,1) as c23,
40 substring(val,25,1) as c24,
41 substring(val,26,1) as c25,
42 substring(val,27,1) as c26,
43 substring(val,28,1) as c27,
44 substring(val,29,1) as c28,
45 substring(val,30,1) as c29,
46 substring(val,31,1) as c30,
47 substring(val,32,1) as c31,
48 substring(val,01,1) as c32,
49 substring(val,02,1) as c33,
50 substring(val,03,1) as c34,
51 substring(val,04,1) as c35,
52 substring(val,05,1) as c36,
53 substring(val,06,1) as c37,
54 substring(val,07,1) as c38,
55 substring(val,08,1) as c39,
56 substring(val,09,1) as c40,
57 substring(val,10,1) as c41,
58 substring(val,11,1) as c42,
59 substring(val,12,1) as c43,
60 substring(val,13,1) as c44,
61 substring(val,14,1) as c45,
62 substring(val,15,1) as c46,
63 substring(val,16,1) as c47,
64 substring(val,17,1) as c48,
65 substring(val,18,1) as c49,
66 substring(val,19,1) as c50,
67 substring(val,20,1) as c51,
68 substring(val,21,1) as c52,
69 substring(val,22,1) as c53,
70 substring(val,23,1) as c54,
71 substring(val,24,1) as c55,
72 substring(val,25,1) as c56,
73 substring(val,26,1) as c57,
74 substring(val,27,1) as c58,
75 substring(val,28,1) as c59,
76 substring(val,29,1) as c60,
77 substring(val,30,1) as c61,
78 substring(val,31,1) as c62,
79 substring(val,32,1) as c63,
80 substring(val,32,1) as c64
81 from facts ) x
82 group by
83 c00,c01,c02,c03,c04,c05,c06,c07,c08,c09,
84 c10,c11,c12,c13,c14,c15,c16,c17,c18,c19,
85 c20,c21,c22,c23,c24,c25,c26,c27,c28,c29,
86 c30,c31,c32,c33,c34,c35,c36,c37,c38,c39,
87 c40,c41,c42,c43,c44,c45,c46,c47,c48,c49,
88 c50,c51,c52,c53,c54,c55,c56,c57,c58,c59,
89 c60,c61,c62,c63,c64
90 grouping sets (
91 c00,c01,c02,c03,c04,c05,c06,c07,c08,c09,
92 c10,c11,c12,c13,c14,c15,c16,c17,c18,c19,
93 c20,c21,c22,c23,c24,c25,c26,c27,c28,c29,
94 c30,c31,c32,c33,c34,c35,c36,c37,c38,c39,
95 c40,c41,c42,c43,c44,c45,c46,c47,c48,c49,
96 c50,c51,c52,c53,c54,c55,c56,c57,c58,c59,
97 c60,c61,c62,c63,c64
98 );