Hello Durga sir and all,
We all know how to insert data dynamically into a partitioned table using Hive, as we seen in the videos, we inserted orders data into the orders table which is partitioned as per order_month, but what if instead of orders table we use a customers table and insert into a customers table partitioned in such a way where queriying on the state field would be easier. In orders table where we used order_month because order_date is given in the table, but how to partition the customers table here. Please help me with this, I am just trying to play with data but not knowing on what i have to partition the customers table if the requirement says queries on state field should be processed easier. Thank you.