Hive Partition [ Static Vs Dynamic]

[@ponnlaksmi2903]

Thanks bro. I was searching for one hour to get clear definition. No one have explained like u. Thanks a lot. you saved my time

[@peace-ye2lm]

this playlist of yours is really very helpful.thanks for creating such good contents . one request can you come up with a series on pyspark and mini projects on it.

[@dataengineeringvideos]

Sure bro, thanks

[@Dora-td3si]

​@@dataengineeringvideos bro , could u pls provide series for pyspark..

[@lakshminarayanavanapalli6769]

Pls do a vedio on file formats.... parquet avro etc.,

[@asmaajerd8591]

Thank you for the effort it really helped me understanding partitions within Hive

[@chandramouli1330]

Very Informative. thanks for the video

[@mkjaswanth3956]

Hi Gowtham, Thanks for the detailed explanation. It would be great if you can share the scripts. Thanks

[@pradhyumansinghmandloi8240]

insert into user_data_dynamic partition (city) select sno , sname , city from user_data_no_partion; what will be the result of it ? do it will autimatically the different partition for each unique city name automatically?

[@dineshjothiram3677]

Good explanation.

[@Mona10YT]

Please do a video on skew and salting..great video by the way .

[@melwinmpk]

Can we create the table first and later set the property "set hive.exec.dynamic.partition.mode=nonstrict;" for Dynamic Partition to work ?

[@skarthikamca]

Wonderful explanation

[@bharathibavana3673]

I have seen video on Hive Architecture and Internals from Your channel,there you mentioned hive metadata like tables ,schema will store in either derbi or rdbms if we choose for rdbms like mysql or oracle.But in this video you are showing your hive tables inside hdfs. Either tables should be in derbe or rdbms right?

[@dataengineeringvideos]

Table data will store in hdfs and Metadata of the table will store in mysql or derby

[@bharathibavana3673]

@@dataengineeringvideos Okay Thank you

[@sivamani7711]

hi bro , Great video but I am not able to load a device file to hive. Can you please share detailed process

[@NaveenKumar-fm5yg]

is paypal asked about dsa for you while attend interview for paypal sir

[@ishasingh9906]

In some business scenario we asuume we have 140 sales organization (countries) Some countries are very big compared to other countries. For example, some sales organization make 30 percent of sales transaction compared to the other 139 sales organization. how to partition data in such scenarios.

[@pavithrasrividhya7489]

Sir can we do add partition to dynamic partition??

[@ammu3041]

The partition comments are same or similar for both hive nd sqoop or sqoop has completely different comments? Any one who knows this concept kindly response!

[@subee128]

Thanks

[@prabue4142]

Hi bro!, Is it possible partition table to retrieve data?

[@u.hemanthkumargowd826]

nice bro,tell me bucketing also

[@rohansingh99]

Can anyone explain me the difference between views and partition in Hive.

[@kuntamukkulapoornima1551]

can we not load data into static partitioned table in this way? LOAD DATA INPATH '/hdfs/path/somthing' INTO TABLE Table_name PARTITION(country ="xx")

[@prakashchaudhary3993]

I know we can use LOAD command for loading data into static partitioned tables from files.... please correct that. I've tested it.

[@dataengineeringvideos]

The load command will work but the Data won't be get partitioned , pls run show partition command and test it ,u will not see the Data partitioned

[@dineshughade6741]

It had better if you provide that text file. It request for you. Thank you in advnace.

[@jaffarahamed6089]

Hi I need favor, I have a date column as MM/dd/yyyy hh:mm:ss AM Can you tell me how to partition date format as Year, Month, Day

[@proplayerzone5122]

First bro