Miscellaneous

1. Hive supports two partitioning models:
            static and dynamic. When either is used, queries are run against only a portion of the data, providing significant performance gains. But what type of partitioning should you use, and when?

Static Partitioning—Used when the values for partition columns are known well in advance of loading the data into a Hive table.

Dynamic Partitioning—Used when the values for partition columns are known only during loading of the data into a Hive table .