Hive Practical - 2 | Partitioning in Hive | Hindi
Вставка
- Опубліковано 15 вер 2024
- Partitioning
Why partitioning is used
Types of partitioning
Create partitioned table
Create partitioned table
Get records from table
Enable dynamic partitioning
create normal table
create partitioned table
Insert data in partitioned table
Where to use partitioning
![[Hindi] Bucketing in Hive , Map side join , Data Sampling](http://i.ytimg.com/vi/ObuCKKd_5Aw/mqdefault.jpg)
For Online classes Visit our website
technologicalgeeks.com/
Course Details : ua-cam.com/video/KBK85ETH5nI/v-deo.html
Kudos to your editing...This way of teaching is very unique.... Literally can't believe this was 5 years ago
Bhai.. Super Like, Jumbo Subscribed, and Shining Shared.. means.. HATTS OFF TO YOU SANDEEP. for presnting this training such interesting and Illustrative manner.
Munendra Mishra u r 100% right
Hi Sandip. These videos are fabulous. This is some really wonderful content. Simple. Elegant. Full with fun quirks that keeps one attentive for the complete duration of the video. Had seen so many videos for Hadoop and Hive and you just cut through the crap and talk about the real stuff. Great Work. Subscribed right away !!. Quick Suggestion, Please number your videos (Like Part 1, Part 2 etc.) it would help in finding them easily. Thanks :)
bhai tumhare teaching technique bahut accha hai. end to end course banao na jyada maja ayaga
@sandeep looks like you too fan of carryminati......cleared all my doubts in 20 mins...hatts offf......keep bringing more stuff on hadoop.
smooth explanation in an entertaining way👌👌👌👌👌
Jabardast
Best explanation
great concept explanation.... Keep it up one of the nicest explanation on youtube for hive concepts👍👍👍👍👍👍
+raj kumar Thank you very much Raj sir 😊
Really Very Nice video Sandeep sir . Thankyou
Hahahaha.... Khatarnak video
amazing explanation with meme trick
Very nice video and presentation.. Thanks
Nice explanation, helpful for me in my exam times.
very nicely explain great work sir
hats off u
+Aman Singh Thank you brother 😊
Hi Sandip ,could you pls add videos related with Oozie ,Kafka ,and spark programming
gud explanation bro ...plz don't stop making this type of video it help us alot.........plz explain more regarding hive topic
+aatish nigam Thank you bro 😊 , will be uploading new videos soon 😊
best tutorial
Sandeep Bhai nice to watch all your videos.... I have seen all your videos on Hive, Pig, Spark etc. You have explained all topics in a very way....But Hadoop architecture part still not very clear. If possible please make 2-3 more videos on Hadoop architecture... Thanks.
nice explanation about partition, please also provide other topics video in hive like ORC, SerDelike jasonSerde,regrexSerde, etc
+sonu chaurasia sure 😊😊
The video of hive is excellent.Please provide other topics video in hive like ORC, json, avro etc.
Thank you ...
Will be uploading new videos soon
very nice explanation sir.keep it up
Very nice tutorial Sandeep. Could you please share one video related to hive msck repair table command. Thanks in advance.
Nice tutorials.....thanks
haha funny with great clear understanding.thanks sandeep xam example haha
Nice explanation in fun way..great thanks Sir ji...:) ..wanted to know .. how partition work for external table ...As we create external table with existed data in HDFS ,so how it will create the directory structure for partition in external table .if possible please add a videos regarding the same .
very nice and useful video it is!!
please provide some latest hadoop videos sir ji!
Good Videos Bro , I hope u get more subscribers
Thank you sandeep sir :D
Sandeep, firse kuch upload karo yaar? spark ka upar karo , switch karna hain yaar :P
nije nije por sala
it would be great when you will provide the file link too for practice. Ty
Superb Sandeep 😎
I have to drop one partition which has duplicate entry
I have tried to drop it through -
Alter table tablename partition{partitoncolumn}
But here I can’t use where condition.
Nice explanation. Thank you :)
Amazing video Sandeep Ji, I really liked it. Please can You Upload bucketing & SerDe concept video with Practical...Please Explain these 2 also.
+Raj Veerma Thank you Bhai 😊 working on next videos will be uploading them soon 😊
good explanation
From where we can get data sets
for doing partition we need to first filter the dataset and then keep the filtered records separately and then create partition table and load it there? isnt it lengthy?
Also when should we use dynamic and static partition?
+Ankit Srivastava we can simply put complete dataset in one table , create another partitioned table and insert data into it using the concept of dynamic partitioning.
pls include dataset to
accha laga , mogembo khus huya ;)
Bhaisaab ji mysql table ka data delete karke waps waps recover kese kare.??? in hadoop...
hey sandeep, it's really a very informatic videos....
only issue i m facing is, i am a beginner and doing practical on VM, but non of the command is working for me. i am also not to check hadoop daemons using jps command. can you please help me with this.
Version : Hadoop 2.6.0-cdh5.12.0.
Output : jps:
[cloudera@quickstart ~]$ jps
11478 Jps
9301 RunJar
Hi Sandeep,
Which one is better dynamic and static partitions ?
jab phle se hi statewise datafile h to partioning kyu?
nice video sir I want dataset
bro please share the data file to do this practicle
Hi !!!!
Can you please share a video session for Bucketing in Hive
+Dinesh Maurya Sure brother will be uploading within a week 😊
i beg you please explain MapReduce/Hadoop, In- database Analytics, MADlib and Advanced SQL Tools.
Sure Achin sir ...
Consider we have two files. In one file i have thousand of records and in another file i have millions of record so how will i collaborate these two files together and get a particular output from it? for example : in one file i have all the names of the people and the second file contains all the mobile numbers. so inorder to find a particular person's mobile number associated with a particular person, how will that process we will look into ? Kindly share your answers.
First you have to learn joining and second there must be a common column like id or something in order to get number of particular name. You can done so by joining
For my case its worked like
insert into table stud_part where your code worked like insert into stud_part, strange! version issue probably
pok pok
nice presentation XD
Thank you ...
dataset ka link bi dedo sir
sir still waiting for ur next videoss....
+prashant sharma Will be uploading a video today. 😊
Technological Geeks Hindi thnku sir... 😊😊
file upload kar dete dataset ki..
bhai tum aurangabad se ho kya
Yes Brother , Aurangabad Maharashtra ..
sir please upload video on pig
+Aman Singh Sure 😊
pagle uttarakhand bhi bolna tha waha champions k champions hote h waha 6th class m newspaper m name aa jata