{"id":1866,"date":"2019-05-31T07:35:35","date_gmt":"2019-05-31T07:35:35","guid":{"rendered":"https:\/\/prwatech.in\/blog\/?p=1866"},"modified":"2024-04-06T09:54:28","modified_gmt":"2024-04-06T09:54:28","slug":"hadoop-hive-test-case","status":"publish","type":"post","link":"https:\/\/prwatech.in\/blog\/hadoop\/hive\/hadoop-hive-test-case\/","title":{"rendered":"Hadoop Hive Test case"},"content":{"rendered":"

Hadoop Hive Test Case<\/strong><\/h1>\n

 <\/p>\n

Hadoop Hive Test Case<\/strong>, Welcome to the world of advanced Tutorials on test cases on Hadoop<\/a> Hive. Are you looking forward to the Hadoop Hive test case<\/a> Platform? Or looking for some help on the Hive client test case? Then you\u2019ve landed on the Right Path which providing advanced tutorial Based concepts on the Hadoop Hive. In this tutorial, one can easily explore apache Hadoop Hive test cases with step by step explanation.<\/p>\n

If you are the one who wanted to become an expert in Hadoop technology? Or the one who wanted to explore the technology like a Pro under the certified experts with world-class classroom training environment, then asks your Hadoop Training institute<\/a> experts who offer Advanced advanced Hadoop training. Follow the below-mentioned Hadoop Hive test case tutorial and enhance your skills to become a professional Hadoop Developer<\/a>.<\/p>\n

 <\/p>\n

Description:<\/strong>\u00a0The basic objective of this project is to create a petrol consumption database using Hive in such a way that we can easily extract data for a particular set of instructions on the basis of the column. Using this technique we can easily sort and extract data from our database using a particular column as a reference.<\/p>\n

 <\/p>\n

Columns to Create<\/strong><\/h3>\n

 <\/p>\n

\u00a01. Column 1: <\/strong>Pump ID<\/p>\n

2. Column 2:<\/strong> Distributor Name<\/p>\n

3. Column 3:<\/strong> Buy Rate(Per million)<\/p>\n

4. Column 4:<\/strong> Sell Rate(Per million)<\/p>\n

5. Column 5:<\/strong> VolumeIN(million cubic litter)<\/p>\n

6. Column 6:<\/strong> VolumeOUT(million cubic litter)<\/p>\n

7. Column 7:<\/strong> Year<\/p>\n

 <\/p>\n

Create table<\/strong>: Create a table with above-mentioned column names<\/h3>\n

 <\/p>\n

CREATE TABLE if not exists petrol_info (distributer_id STRING,distributer_name STRING,amt_IN STRING,amy_OUT STRING,vol_IN INT,vol_OUT INT,year INT)<\/strong><\/p>\n

 <\/p>\n

ROW FORMAT DELIMITED<\/strong><\/p>\n

FIELDS TERMINATED BY \u2018,\u2019<\/strong><\/p>\n

LINES TERMINATED BY \u2018\\n\u2019<\/strong><\/p>\n

STORED AS TEXTFILE;<\/strong><\/p>\n

 <\/p>\n

\"Hadoop<\/p>\n

 <\/p>\n

Load Data from an external source:<\/strong> Load data into a table from an external source into the above-created table.<\/h3>\n

 <\/p>\n

LOAD DATA LOCAL INPATH \u2018\/home\/cloudera\/Desktop\/petrol.txt\u2019 into table petrol_info;<\/strong><\/p>\n

 <\/p>\n

Data Source: <\/strong><\/h3>\n

https:\/\/drive.google.com\/file\/d\/11Yle65LsT5H5uRAHrhgSRZHaZSTiUbH-\/view?usp=sharing<\/strong><\/a><\/p>\n

 <\/p>\n

\"Hadoop<\/p>\n

 <\/p>\n

Case 1:<\/strong> What is the total amount of petrol in volume sold by every distributor<\/p>\n

SOLUTION : SELECT distributer_name,SUM(vol_OUT) FROM petrol_info GROUP BY distributer_name;<\/strong><\/h3>\n

 <\/p>\n

\u00a0\"Hadoop<\/strong><\/p>\n

\"Hadoop<\/strong><\/p>\n

 <\/p>\n

Case 2: <\/strong>Which are the top 10 distributors ID for selling petrol and also display the amount of petrol sold in volume by them individually?<\/p>\n

 <\/p>\n

SOLUTION: SELECT distributer_id,vol_OUT FROM petrol_info order by vol_OUT desc limit 10;<\/strong><\/h3>\n

 <\/p>\n

\u00a0\"Hadoop<\/strong><\/p>\n

\"Hadoop<\/p>\n

 <\/p>\n

Case 3: <\/strong>Find 10 distributor name who sold petrol in the least amount.<\/p>\n

 <\/p>\n

SOLUTION: SELECT distributer_id,vol_OUT FROM petrol_info order by vol_OUT limit 10;<\/strong><\/h3>\n

 <\/p>\n

\"Hadoop<\/p>\n

 <\/p>\n

Hadoop Hive Test Case 2<\/strong><\/h2>\n

 <\/p>\n

Description:<\/strong>\u00a0The basic objective of this project is to create an IPL statistic database using Hive in such a way that we can easily extract data for a particular set of instructions on the basis of the column. Using this technique we can easily sort and extract data from our database using a particular column as a reference.<\/p>\n

Columns to Create<\/strong><\/h3>\n

Player id<\/p>\n

Jersey number<\/p>\n

Player name<\/p>\n

DOB<\/p>\n

Handed<\/p>\n

Matched Played<\/p>\n

Run Rate<\/p>\n

Runs<\/p>\n

Country<\/p>\n

 <\/p>\n

Create table<\/strong>: Create a table with above-mentioned column names<\/h3>\n

 <\/p>\n

CREATE TABLE if not exists ipl_info (player id INT,jersy_number INT,name STRING,DOB STRING,handed STRING,matches_played INT,run_rate INT,runs INT,country STRING)<\/strong><\/p>\n

ROW FORMAT DELIMITED<\/strong><\/p>\n

FIELDS TERMINATED BY \u2018,\u2019<\/strong><\/p>\n

LINES TERMINATED BY \u2018\\n\u2019<\/strong><\/p>\n

STORED AS TEXTFILE;<\/strong><\/p>\n

 <\/p>\n

\u00a0\"Hadoop<\/strong><\/p>\n

\u00a0<\/strong><\/p>\n

Load Data from an external source:<\/strong>\u00a0Load data into the table from an external source into the above-created table.<\/h3>\n

 <\/p>\n

LOAD DATA LOCAL INPATH \u2018\/home\/cloudera\/Desktop\/IPL.txt\u2019 into table ipl_info;<\/strong><\/p>\n

Data Source:<\/h3>\n

 <\/p>\n

https:\/\/drive.google.com\/file\/d\/1rFQzqbS6CEqrM0TMrDMQBEP4sRm1yoCc\/view?usp=sharing<\/a><\/p>\n

 <\/p>\n

\"Hadoop<\/p>\n

 <\/p>\n

Case 1: <\/strong>Display name and runs of all batsmen with right-handed<\/p>\n

Solution: select name,runs from ipl_info where handed = ‘Right-hand bat’;<\/strong><\/h3>\n

 <\/p>\n

\"Hadoop<\/p>\n

\"Hadoop<\/p>\n

 <\/p>\n

Case 2: <\/strong>Display the detail of all batsmen with strike rate greater than 130<\/p>\n

Solution : select jersy_number,country from ipl_info where run_rate > 130;<\/strong><\/h3>\n

 <\/p>\n

\u00a0\"Hadoop <\/strong><\/p>\n

\"Hadoop<\/strong><\/p>\n

 <\/p>\n

Case 3: <\/strong>Display the name,runs scored by batsman of the same country<\/p>\n

Solution : select jersy_number,runs from ipl_info where country = ‘India’;<\/strong><\/h3>\n

 <\/p>\n

\"Hadoop<\/p>\n

\"Hadoop<\/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","protected":false},"excerpt":{"rendered":"

Hadoop Hive Test Case   Hadoop Hive Test Case, Welcome to the world of advanced Tutorials on test cases on Hadoop Hive. Are you looking forward to the Hadoop Hive test case Platform? Or looking for some help on the Hive client test case? Then you\u2019ve landed on the Right Path which providing advanced tutorial […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17,1643],"tags":[1855,342,1857,1854,1856],"class_list":["post-1866","post","type-post","status-publish","format-standard","hentry","category-hadoop","category-hive","tag-automated-testing-in-apache-hive","tag-hadoop-hive-test-case","tag-hadoop-hive-test-case-hive-tutorial-on-testcase","tag-hadoop-test-case-scenarios","tag-unit-testing-with-hive-file-based"],"acf":[],"yoast_head":"\nHadoop Hive Test Case | Hive tutorial on testcase | Prwatech<\/title>\n<meta name=\"description\" content=\"Explore the Hadoop Hive test case tutorial with detailed information, one can Learn Advanced Tutorials on Hadoop Hive from Prwatech\" \/>\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Hadoop Hive Test Case | Hive tutorial on testcase | Prwatech\" \/>\n<meta property=\"og:description\" content=\"Explore the Hadoop Hive test case tutorial with detailed information, one can Learn Advanced Tutorials on Hadoop Hive from Prwatech\" \/>\n<meta property=\"og:url\" content=\"https:\/\/prwatech.in\/blog\/hadoop\/hive\/hadoop-hive-test-case\/\" \/>\n<meta property=\"og:site_name\" content=\"Prwatech\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/prwatech.in\/\" \/>\n<meta property=\"article:published_time\" content=\"2019-05-31T07:35:35+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-06T09:54:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/05\/1-10.png\" \/>\n<meta name=\"author\" content=\"Prwatech\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@Eduprwatech\" \/>\n<meta name=\"twitter:site\" content=\"@Eduprwatech\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Prwatech\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/prwatech.in\/blog\/hadoop\/hive\/hadoop-hive-test-case\/\",\"url\":\"https:\/\/prwatech.in\/blog\/hadoop\/hive\/hadoop-hive-test-case\/\",\"name\":\"Hadoop Hive Test Case | Hive tutorial on testcase | Prwatech\",\"isPartOf\":{\"@id\":\"https:\/\/prwatech.in\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/prwatech.in\/blog\/hadoop\/hive\/hadoop-hive-test-case\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/prwatech.in\/blog\/hadoop\/hive\/hadoop-hive-test-case\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/05\/1-10.png\",\"datePublished\":\"2019-05-31T07:35:35+00:00\",\"dateModified\":\"2024-04-06T09:54:28+00:00\",\"author\":{\"@id\":\"https:\/\/prwatech.in\/blog\/#\/schema\/person\/db90baff7744090b2288bbc98fea87f3\"},\"description\":\"Explore the Hadoop Hive test case tutorial with detailed information, one can Learn Advanced Tutorials on Hadoop Hive from Prwatech\",\"breadcrumb\":{\"@id\":\"https:\/\/prwatech.in\/blog\/hadoop\/hive\/hadoop-hive-test-case\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/prwatech.in\/blog\/hadoop\/hive\/hadoop-hive-test-case\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/prwatech.in\/blog\/hadoop\/hive\/hadoop-hive-test-case\/#primaryimage\",\"url\":\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/05\/1-10.png\",\"contentUrl\":\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/05\/1-10.png\",\"width\":624,\"height\":133},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/prwatech.in\/blog\/hadoop\/hive\/hadoop-hive-test-case\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/prwatech.in\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hadoop Hive Test case\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/prwatech.in\/blog\/#website\",\"url\":\"https:\/\/prwatech.in\/blog\/\",\"name\":\"Prwatech\",\"description\":\"Share Ideas, Start Something Good.\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/prwatech.in\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/prwatech.in\/blog\/#\/schema\/person\/db90baff7744090b2288bbc98fea87f3\",\"name\":\"Prwatech\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/prwatech.in\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c00bafc1b04045f31eda917de39891456c44fa47c092b9bb6be0f860a3a30a2f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c00bafc1b04045f31eda917de39891456c44fa47c092b9bb6be0f860a3a30a2f?s=96&d=mm&r=g\",\"caption\":\"Prwatech\"},\"url\":\"https:\/\/prwatech.in\/blog\/author\/prwatech123\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Hadoop Hive Test Case | Hive tutorial on testcase | Prwatech","description":"Explore the Hadoop Hive test case tutorial with detailed information, one can Learn Advanced Tutorials on Hadoop Hive from Prwatech","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"en_US","og_type":"article","og_title":"Hadoop Hive Test Case | Hive tutorial on testcase | Prwatech","og_description":"Explore the Hadoop Hive test case tutorial with detailed information, one can Learn Advanced Tutorials on Hadoop Hive from Prwatech","og_url":"https:\/\/prwatech.in\/blog\/hadoop\/hive\/hadoop-hive-test-case\/","og_site_name":"Prwatech","article_publisher":"https:\/\/www.facebook.com\/prwatech.in\/","article_published_time":"2019-05-31T07:35:35+00:00","article_modified_time":"2024-04-06T09:54:28+00:00","og_image":[{"url":"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/05\/1-10.png","type":"","width":"","height":""}],"author":"Prwatech","twitter_card":"summary_large_image","twitter_creator":"@Eduprwatech","twitter_site":"@Eduprwatech","twitter_misc":{"Written by":"Prwatech","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/prwatech.in\/blog\/hadoop\/hive\/hadoop-hive-test-case\/","url":"https:\/\/prwatech.in\/blog\/hadoop\/hive\/hadoop-hive-test-case\/","name":"Hadoop Hive Test Case | Hive tutorial on testcase | Prwatech","isPartOf":{"@id":"https:\/\/prwatech.in\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/prwatech.in\/blog\/hadoop\/hive\/hadoop-hive-test-case\/#primaryimage"},"image":{"@id":"https:\/\/prwatech.in\/blog\/hadoop\/hive\/hadoop-hive-test-case\/#primaryimage"},"thumbnailUrl":"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/05\/1-10.png","datePublished":"2019-05-31T07:35:35+00:00","dateModified":"2024-04-06T09:54:28+00:00","author":{"@id":"https:\/\/prwatech.in\/blog\/#\/schema\/person\/db90baff7744090b2288bbc98fea87f3"},"description":"Explore the Hadoop Hive test case tutorial with detailed information, one can Learn Advanced Tutorials on Hadoop Hive from Prwatech","breadcrumb":{"@id":"https:\/\/prwatech.in\/blog\/hadoop\/hive\/hadoop-hive-test-case\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prwatech.in\/blog\/hadoop\/hive\/hadoop-hive-test-case\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/prwatech.in\/blog\/hadoop\/hive\/hadoop-hive-test-case\/#primaryimage","url":"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/05\/1-10.png","contentUrl":"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/05\/1-10.png","width":624,"height":133},{"@type":"BreadcrumbList","@id":"https:\/\/prwatech.in\/blog\/hadoop\/hive\/hadoop-hive-test-case\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/prwatech.in\/blog\/"},{"@type":"ListItem","position":2,"name":"Hadoop Hive Test case"}]},{"@type":"WebSite","@id":"https:\/\/prwatech.in\/blog\/#website","url":"https:\/\/prwatech.in\/blog\/","name":"Prwatech","description":"Share Ideas, Start Something Good.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/prwatech.in\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/prwatech.in\/blog\/#\/schema\/person\/db90baff7744090b2288bbc98fea87f3","name":"Prwatech","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/prwatech.in\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c00bafc1b04045f31eda917de39891456c44fa47c092b9bb6be0f860a3a30a2f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c00bafc1b04045f31eda917de39891456c44fa47c092b9bb6be0f860a3a30a2f?s=96&d=mm&r=g","caption":"Prwatech"},"url":"https:\/\/prwatech.in\/blog\/author\/prwatech123\/"}]}},"_links":{"self":[{"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/posts\/1866","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/comments?post=1866"}],"version-history":[{"count":10,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/posts\/1866\/revisions"}],"predecessor-version":[{"id":11281,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/posts\/1866\/revisions\/11281"}],"wp:attachment":[{"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/media?parent=1866"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/categories?post=1866"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/tags?post=1866"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}