{"id":1854,"date":"2019-05-31T04:21:49","date_gmt":"2019-05-31T04:21:49","guid":{"rendered":"https:\/\/prwatech.in\/blog\/?p=1854"},"modified":"2020-07-10T05:18:37","modified_gmt":"2020-07-10T05:18:37","slug":"bucketing-in-hive-with-examples","status":"publish","type":"post","link":"https:\/\/prwatech.in\/blog\/hadoop\/bucketing-in-hive-with-examples\/","title":{"rendered":"Bucketing in Hive with Examples"},"content":{"rendered":"

 <\/p>\n

Bucketing in Hive with Examples<\/h1>\n

 <\/p>\n

Bucketing in Hive with Examples<\/strong>, are you looking for the information of bucketing in Hadoop hive? Or the one who is casually glancing for the best platform which is providing bucketing in a hive with examples for beginners or information on the creation of a bucketed table in Hive? Then you\u2019ve landed on the Right Platform which is packed with Tons of Tutorials of bucketing in Hadoop<\/a> hive. Follow the below mentioned Bucketing in Hive tutorial for Beginners which were originally designed by the world-class Trainers of Hadoop Training institute<\/a> Professionals.<\/p>\n

If you are the one who is a hunger to become the certified Pro Hadoop Developer<\/a>? Or the one who is looking for the best Hadoop Training institute which offering advanced tutorials and Hadoop certification course<\/a> to all the tech enthusiasts who are eager to learn the technology from starting Level to Advanced Level.<\/p>\n

 <\/p>\n

Creation of Bucketed Table in Hive<\/h2>\n

 <\/p>\n

Create Table: <\/strong>Create a table using below-mentioned columns and provide field and lines terminating delimiters.<\/p>\n

 <\/p>\n

\"Bucketing<\/p>\n

 <\/p>\n

Load Data into Table:<\/strong> Load data into a table from an external source by providing the path of the data file.<\/p>\n

 <\/p>\n

\"Bucketing<\/p>\n

\"Bucketing<\/p>\n

 <\/p>\n

Select data:<\/strong> Using the below-mentioned command to display the loaded data into table.<\/p>\n

 <\/p>\n

\"Bucketing<\/p>\n

 <\/p>\n

Properties setting:<\/strong> To populate the bucketed table, we have to set\u00a0hive.enforce.bucketing<\/strong>\u00a0property to \u2018true\u2019, so that the Hive knows to create the number of buckets declared in the table definition.<\/p>\n

 <\/p>\n

\"Bucketing<\/p>\n

 <\/p>\n

Inserting Data into bucket table:<\/strong> \u00a0Inserting data from previously created table (personal_info) into the bucket table.<\/p>\n

 <\/p>\n

\"Bucketing<\/p>\n

 <\/p>\n

As we can see below we have created two partitions and according to 4 buckets had been created.<\/p>\n

 <\/p>\n

\"Bucketing<\/p>\n

 <\/p>\n

Now as we navigated to our HDFS file system we can find the created \u201cbucket_table\u201d under mentioned below directory.<\/p>\n

 <\/p>\n

\"Bucketing<\/p>\n

 <\/p>\n

As we navigate further into the bucket_table directory we can see that two partitioned has been created depending on the data which was inserted.<\/p>\n

 <\/p>\n

\"Bucketing<\/p>\n

 <\/p>\n

And further, as we navigate we can see four buckets have been created for each partition.<\/p>\n

 <\/p>\n

\"Bucketing<\/p>\n

 <\/p>\n

Get success in your career as a Hadoop developer<\/a> by being a part of the Prwatech<\/a>, India’s leading Hadoop training institute in Bangalore<\/a>.<\/p>\n

 <\/p>\n