Hive Partitioning and Bucketing

[@DesiGirl_in_UK]

so good video, step wise derivation.

[@sdetpavan]

Thanks

[@NAVINKUMAR-vf8zd]

Easily understanding

[@sdetpavan]

Thanks

[@pandiyarajvaithinathan8795]

Is their any limitation to create the partition in hive single table. If it is their How much we can create in one table.

[@balabodhiy730]

Got the concept, simple and very good explanation

[@sdetpavan]

Thanks

[@sumonchattopadhyay4589]

I really liked the video till I reached the end of Bucketing. Something got messed in the data, but you didn't explain where or how it got incorrect data.

[@naveenkumarmaddala7830]

Thanks for sharing the video. I have one question here. Can you tell me one usecase where exactly we required bucketing?

[@naveenkumarmaddala7830]

What are the factors to be considered while deciding the number of buckets?

[@AmitKumar-qd6gb]

Very nicely explained

[@sdetpavan]

Thanks

[@naveenkumarmaddala7830]

Can you make video on Bucketing for partitioned table.ie., Need example on both partition and bucketing on the same data.

[@saikrishna-eb2vs]

Very Well Explained Thank You for this video

[@sdetpavan]

Welcome

[@chetanamohapatro4174]

thank you...it cleared the whole concept...

[@sdetpavan]

Welcome

[@jalendarch89]

Excellent !!

[@sdetpavan]

Thanks

[@ballyoracle]

excellent work . thank you

[@sdetpavan]

Welcome

[@kathyayinit8043]

Awesome Explanation !!!

[@nonie1107]

sir while creating partition table "row format delimited " is not required why????

[@cbitlife8437]

as our input file is in CSV format, we need to delimit it with comma(' , ')

[@ramkrishbeardjourney5153]

Awesome video

[@sdetpavan]

Thanks

[@balajivemula6552]

so when we create partition/bucket tables in hive, data will loaded from main table one more time additionally ? and again replicated 3 times on HDFS ?

[@Shiva-kz6tn]

otha mootu po

[@pradeepjadhav2886]

While creating table name all_student the data type for year of passing should be Int. In this example it is used as string. please explain .

[@v.smourya8005]

Nice teaching ! :)

[@sdetpavan]

Thanks

[@chaitanyaallada8649]

Thank you, I can now understand this concept clearly..

[@sdetpavan]

Welcome

[@saurabhw18]

Hello sir, I have one question. Is run time partitioning possible in hive?

[@beesettykalimahesh9373]

Thanks for clear explaination

[@sdetpavan]

Welcome

[@TheVikash620]

Hash value concept should have been included while bucketing.

[@bhavaniv1721]

how i will reach u for training...

[@yka2992]

s