in Big Data | Hadoop by
Q:
Why do we perform partitioning in Hive?

1 Answer

0 votes
by

Partitioning provides granularity in a Hive table and therefore, reduces the query latency by scanning only relevant partitioned data instead of the whole data set.

For example, we can partition a transaction log of an e – commerce website based on month like Jan, February, etc. So, any analytics regarding a particular month, say Jan, will have to scan the Jan partition (sub – directory) only instead of the whole table data.

Click here to read more about Loan/Mortgage
Click here to read more about Insurance

Related questions

0 votes
asked Apr 24, 2020 in Big Data | Hadoop by Hodge
0 votes
asked Jan 11, 2020 in Big Data | Hadoop by rajeshsharma
+1 vote
asked Feb 23, 2020 in Big Data | Hadoop by rahuljain1
0 votes
asked Jan 12, 2020 in Big Data | Hadoop by sharadyadav1986
0 votes
asked Mar 27, 2020 in Big Data | Hadoop by AdilsonLima
...