Hive Partition with Bucket Explained

[@prasadadsul8703]

Hello Sir, I almost watched all of your videos from which I learned lot of concepts about big data.... Your content is very very awesome to any aspiring data engineer !!! I'm always eager to watch your new videos to learn something new.... Once again very big thank you!!!

[@dataengineeringvideos]

Thanks ❤️

[@chandramouli1330]

Very good explanation. thanks for the video.

[@dataengineeringvideos]

Thank you so much bro

[@localmartian9047]

Thank you for review videos🤗🤗 Here if we need dynamic partition by country we'll just need different insert right: Insert overwrite table partitioned_bucketed Partition(country) select pid, pname, drug, gender, tot_amount, country from table1 Mentioning fields of table1 to ensure country field of table1 is projected last. Also isn't country field missing in ddl of staging table1 in step 1

[@dataengineeringvideos]

Thanks , yes for dynamic partition the insert is diff and table1 will not have country column since i am passing it as a partition value from second table as static

[@prabhathkota107]

Can we do partition & bucket on same column?

[@AnanthaLakshmiAcademy]

Hi sir, Can you pls upload a video on the concept of hiding a partition from being queried in hive.