How to Decide [Bucket Count] in Hive

[@mohammadhaque1873]

Best tutorial for data engineering. Many of my doubts and questions were answered from your tutorial. Thanks a lot.

[@sakshamkansal6946]

I work in a MNC as fresher and I needed a course on BIG DATA. I searched whole youtube. I didn't got any good course, all were theory based. Your course is best. Good hands on experience and got to know the things which are needed in real time project and interview questions as well. Thanks a lot bro!

[@aneksingh4496]

Good hack ...few questions 1. Table size in Oracle /MySql and Table Size on HDFS differs because of file compression on HDFC let's say for parquet. Then how to calculate.table size efficiently for HDFS . 2. How did you get to know this 2*n formula ...how did u find that 2n only works ? Please try to answer as this will make concepts clear

[@keshavkumar7769]

how insert overwrite take care of partition column as you didn't mention the partition in insert statement

[@chandramouli1330]

thanks so much for the video!

[@dataengineeringvideos]

Glad it was helpful!

[@saqlainsayed2641]

What about hash function regarding bucket count.

[@vikaschavan6118]

Sir, If we want to change the partition column and bucket column name after creating table. Is it possible to change?. If Yes, How can we achieve this? Please answer

[@sekhargvvs]

Can you please help with a video on Sub-Partition vs Bucketing use cases

[@mohammedasif4349]

How can we check no of bucket for any HIve table?

[@shwetac2929]

plz do more video on hive

[@pulirajender17]

Super

[@mallikarjunyadav7839]

Nice

[@Vijay-sm3bj]

In case , First table query written by someone else, and I need to write the 2nd query..how I can find first table query

[@ririraman7]

metadata

[@localmartian9047]

SHOW CREATE TABLE table_name