hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kristof Vanbecelaere <>
Subject select list for dynamic partition insert
Date Tue, 22 Jul 2014 20:07:16 GMT
While playing with the movielens data set to learn about dynamic partitions
I ran

from u_data insert overwrite table u_data_p partition (rating) select *

This failed with

[Error 20004]: Fatal error occurred when node tried to create too many
dynamic partitions. The maximum number of dynamic partitions is controlled
by hive.exec.max.dynamic.partitions and
hive.exec.max.dynamic.partitions.pernode. Maximum was set to: 100

Apparently select * cannot be used and one should explicitly list the
fields in the select list. I guess a beter error message is required here.

View raw message