Breaking News
Loading...

Partitions





Partitions:
Table organized into partitions
•Divides a table into coarse-grained parts based on partition column
•A table can be partitioned in multiple dimensions
•Partitioning helps to do queries faster on slices of the data
Tables/Partitions can be further subdivided into Clusters
•Gives an additional structure to the data for more efficient queries

Step 1:  Create table with partitions

Step 2: Retrieve data using partition

 
- See more at: http://labstrikes.blogspot.in/2012/08/adsense-middle-blog-post.html#sthash.gQgSkqx8.dpuf
 
Toggle Footer