Got it

Grouping sets size cannot be greater than 64 : Hive || getting issue under Hive 3.1.0 version (FI 6.5.1)

Created: Oct 6, 2020 04:55:38Latest reply: Feb 9, 2022 10:50:41 831 8 1 0 0
  HiCoins as reward: 0 (problem unresolved)
  • x
  • convention:

Featured Answers
wissal
MVE Created Oct 6, 2020 05:04:44

Hello,

Try to concatenate columns using delimiter in the subquery before aggregation as a workaround, I'm not sure will it help or not.

like this, using concat() or concat_ws or || operator:

select concat_ws ('~', col1, col2, col3, col4)
...
group by concat_ws ('~', col1, col2, col3, col4)

or

col1||'~'||col2||'~'||...||colN


Thanks

View more
  • x
  • convention:

srik
srik Created Oct 6, 2020 05:28:18 (0) (0)
Is it posiable to upgrade hive Hive 3.1.0 version, to Hive 4.0.0 in FI 6.5.1  
wissal
wissal Reply srik  Created Oct 6, 2020 05:31:47 (0) (0)
It's a bug in Hive 3.1.0 version, it is fixed in the Hive 4.0.0.  
srik
srik Reply wissal  Created Oct 6, 2020 05:34:12 (0) (0)
is it posiable to upgrade Hive 3.1.0 version, to Hive 4.0.0 in FI 6.5.1  
wissal
wissal Reply srik  Created Oct 6, 2020 06:08:30 (0) (0)
Yes.  
user_4400653
user_4400653 Created Feb 9, 2022 04:20:26 (0) (0)
 
All Answers
wissal
wissal MVE Created Oct 6, 2020 05:04:44

Hello,

Try to concatenate columns using delimiter in the subquery before aggregation as a workaround, I'm not sure will it help or not.

like this, using concat() or concat_ws or || operator:

select concat_ws ('~', col1, col2, col3, col4)
...
group by concat_ws ('~', col1, col2, col3, col4)

or

col1||'~'||col2||'~'||...||colN


Thanks

View more
  • x
  • convention:

srik
srik Created Oct 6, 2020 05:28:18 (0) (0)
Is it posiable to upgrade hive Hive 3.1.0 version, to Hive 4.0.0 in FI 6.5.1  
wissal
wissal Reply srik  Created Oct 6, 2020 05:31:47 (0) (0)
It's a bug in Hive 3.1.0 version, it is fixed in the Hive 4.0.0.  
srik
srik Reply wissal  Created Oct 6, 2020 05:34:12 (0) (0)
is it posiable to upgrade Hive 3.1.0 version, to Hive 4.0.0 in FI 6.5.1  
wissal
wissal Reply srik  Created Oct 6, 2020 06:08:30 (0) (0)
Yes.  
user_4400653
user_4400653 Created Feb 9, 2022 04:20:26 (0) (0)
 
user_4400653
user_4400653 Created Feb 9, 2022 04:20:32

good
View more
  • x
  • convention:

Saqibaz
Saqibaz Created Feb 9, 2022 10:50:41

Thanks
View more
  • x
  • convention:

Comment

You need to log in to comment to the post Login | Register
Comment

Notice: To protect the legitimate rights and interests of you, the community, and third parties, do not release content that may bring legal risks to all parties, including but are not limited to the following:
  • Politically sensitive content
  • Content concerning pornography, gambling, and drug abuse
  • Content that may disclose or infringe upon others ' commercial secrets, intellectual properties, including trade marks, copyrights, and patents, and personal privacy
Do not share your account and password with others. All operations performed using your account will be regarded as your own actions and all consequences arising therefrom will be borne by you. For details, see " User Agreement."

My Followers

Login and enjoy all the member benefits

Login

Block
Are you sure to block this user?
Users on your blacklist cannot comment on your post,cannot mention you, cannot send you private messages.
Reminder
Please bind your phone number to obtain invitation bonus.
Information Protection Guide
Thanks for using Huawei Enterprise Support Community! We will help you learn how we collect, use, store and share your personal information and the rights you have in accordance with Privacy Policy and User Agreement.