CODEWITHSUNDEEP
hive
Lin Ma
Lin Ma

Reputation: 10149

Advantages of non-partitioned table on hive?

Are there any advantages of non-partitioned table on Hive -- their special use cases comparing to partitioned table?

It will be great if anyone could help. :)

Upvotes: 0

Views: 410

Answers (1)

Samson Scharfrichter
Samson Scharfrichter

Reputation: 9067

Let's put it that way: in the database world, partitioning can be used to solve different kinds of problems. As long as you have no explicit problem, don't bother with partitions (i.e. "if it ain't broken, don't fix it"). Whenever you hit a problem, ask a DB architect to find a solution - may involve partitioning, maybe not.

But Hive is not a typical database. Partitions are everywhere, just because it's a crude workaround for the lack of indexes...

(Well, actually the ORC format has its own workaround [stores min/max values per column per stripe, which allows skipping useless stripes] so partitioning is less critical with that format)

Upvotes: 3

Related Questions