Reputation: 111
Trying to upgrade EMR EC2 instance from 5.3 C4.4Xlarge(HIVE ver 2.1.1) to EMR 5.16.0 C5.4XLarge (Hive 2.3.3) My simple query select max(date) from table in 2.1.1 EMR 5.3.0 launches just 1 mapper and 1 reducer where as when I upgrade and run the same query it is launching 1300+ mappers.
Tried to compare the set properties of both and found no difference.
Could someone help me here.
Upvotes: 1
Views: 70
Reputation: 26
Try the setting below. Somewhere along the way from hive 2.1.1 to 2.3.3, they flipped it from true to false.
set hive.optimize.metadataonly=true;
Upvotes: 1