回复: Limit to the max number of fields in GROUPING SETS
Well, I must say sorry that there was a mistake in the last email. The maximum number of the valid keys is 32 in my test. Namely, key33~key50 get null values in the code. Still waiting for more details, thanks! Regards, 孙志禹 发件人: 孙志禹 发送时间: 2019-02-21 13:18 收件人: user@hive.apache.org 主题: Limit to the max number of fields in GROUPING SETS Dear all, by doing some tests, I found there is a limit to the number of fields used in GRPOUPING SETS. For example, in the code below, we can only get null value for key44~key50. In addition, if we change the order of the keys, we can always get null value for the last several keys. Can anyone give some more details about this limit? Thanks! SELECT key1,key2,key3,key4,key5,key6,key7,key8,key9,key10 ,key11,key12,key13,key14,key15,key16,key17,key18,key19,key20 ,key21,key22,key23,key24,key25,key26,key27,key28,key29,key30 ,key31,key32,key33,key34,key35,key36,key37,key38,key39,key40 ,key41,key42,key43,key44,key45,key46,key47,key48,key49,key50 FROM table1 GROUP BY key1,key2,key3,key4,key5,key6,key7,key8,key9,key10 ,key11,key12,key13,key14,key15,key16,key17,key18,key19,key20 ,key21,key22,key23,key24,key25,key26,key27,key28,key29,key30 ,key31,key32,key33,key34,key35,key36,key37,key38,key39,key40 ,key41,key42,key43,key44,key45,key46,key47,key48,key49,key50 grouping sets ( ( key1,key2,key3,key4,key5,key6,key7,key8,key9,key10 ,key11,key12,key13,key14,key15,key16,key17,key18,key19,key20 ,key21,key22,key23,key24,key25,key26,key27,key28,key29,key30 ,key31,key32,key33,key34,key35,key36,key37,key38,key39,key40 ,key41,key42,key43,key44,key45,key46,key47,key48,key49,key50 ) ) Regards, 孙志禹(Zhiyu Sun)
Limit to the max number of fields in GROUPING SETS
Dear all, by doing some tests, I found there is a limit to the number of fields used in GRPOUPING SETS. For example, in the code below, we can only get null value for key44~key50. In addition, if we change the order of the keys, we can always get null value for the last several keys. Can anyone give some more details about this limit? Thanks! SELECT key1,key2,key3,key4,key5,key6,key7,key8,key9,key10 ,key11,key12,key13,key14,key15,key16,key17,key18,key19,key20 ,key21,key22,key23,key24,key25,key26,key27,key28,key29,key30 ,key31,key32,key33,key34,key35,key36,key37,key38,key39,key40 ,key41,key42,key43,key44,key45,key46,key47,key48,key49,key50 FROM table1 GROUP BY key1,key2,key3,key4,key5,key6,key7,key8,key9,key10 ,key11,key12,key13,key14,key15,key16,key17,key18,key19,key20 ,key21,key22,key23,key24,key25,key26,key27,key28,key29,key30 ,key31,key32,key33,key34,key35,key36,key37,key38,key39,key40 ,key41,key42,key43,key44,key45,key46,key47,key48,key49,key50 grouping sets ( ( key1,key2,key3,key4,key5,key6,key7,key8,key9,key10 ,key11,key12,key13,key14,key15,key16,key17,key18,key19,key20 ,key21,key22,key23,key24,key25,key26,key27,key28,key29,key30 ,key31,key32,key33,key34,key35,key36,key37,key38,key39,key40 ,key41,key42,key43,key44,key45,key46,key47,key48,key49,key50 ) ) Regards, 孙志禹(Zhiyu Sun)
Announce: MR3 0.5 released (with Hive on Kubernetes)
I am pleased to announce the release of MR3 0.5. A new feature of MR3 0.5 is its native support for Kubernetes. Now the user can run Hive on Kubernetes by using MR3 as its execution engine. The documentation on Hive on Kubernetes can be found at: https://mr3.postech.ac.kr/hivek8s/home/ MR3 0.5 also supports Hive 3.1.1 and Hive 2.3.4. You can download MR3 0.5 at: https://mr3.postech.ac.kr/download/home/ --- Sungwoo Park