What is the right amount of data to store in each hive table partition to have optimized queries ?
I read somewhere that it was about 1gb of data per hive partition can someone please confirm what is the correct amount and also explain what happens in terms of performance if we have 20gb in one partition or 20 mb.
Thank you,
