{"id":76760,"date":"2020-03-05T12:33:32","date_gmt":"2020-03-05T07:03:32","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=76760"},"modified":"2020-03-05T12:33:32","modified_gmt":"2020-03-05T07:03:32","slug":"hive-dml-commands","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/hive-dml-commands\/","title":{"rendered":"Top 7 Hive DML Commands with Syntax and Examples"},"content":{"rendered":"<p><strong>Wishing to load, insert, retrieve, update, or delete data in the Hive tables?<\/strong><\/p>\n<p>After learning basic <strong>Commands<\/strong> in Hive, let us now study Hive DML Commands. Hive <strong>D<\/strong>ata <strong>M<\/strong>anipulation <strong>L<\/strong>anguage commands are used for inserting, retrieving, modifying, deleting, and updating data in the Hive table.<\/p>\n<p>In this article, we will learn Hive DML commands. There are many Hive DML commands like LOAD, INSERT, UPDATE, etc. We will explore each of these DML commands individually, along with their syntax and examples.<\/p>\n<p>Before moving towards the Hive DML commands, let us first see the short introduction to Hive Query Language.<\/p>\n<h3>Hive Query Language(HQL)<\/h3>\n<p>Hive Query Language is a language used in Hive, similar to SQL, to process and analyze unstructured data.<\/p>\n<p>Hive Query Language is easy to use if you are familiar with <strong>SQL<\/strong>. The syntax of Hive QL is very similar to SQL with slight differences.<\/p>\n<p>Hive QL supports DDL, DML, and user-defined functions.<\/p>\n<h2>Introduction to Hive DML commands<\/h2>\n<p>Hive DML (Data Manipulation Language) commands are used to insert, update, retrieve, and delete data from the Hive table once the table and database schema has been defined using Hive DDL commands.<\/p>\n<p>The various Hive DML commands are:<\/p>\n<ol>\n<li><a class=\"_ps2id\" href=\"#LOAD-command\">LOAD<\/a><\/li>\n<li><a class=\"_ps2id\" href=\"#SELECT-command\">SELECT<\/a><\/li>\n<li><a class=\"_ps2id\" href=\"#INSERT-command\">INSERT<\/a><\/li>\n<li><a class=\"_ps2id\" href=\"#DELETE-command\">DELETE<\/a><\/li>\n<li><a class=\"_ps2id\" href=\"#UPDATE-command\">UPDATE<\/a><\/li>\n<li><a class=\"_ps2id\" href=\"#EXPORT-command\">EXPORT<\/a><\/li>\n<li><a class=\"_ps2id\" href=\"#IMPORT-command\">IMPORT<\/a><\/li>\n<\/ol>\n<p>Let us now learn each DML command individually.<\/p>\n<h3>[ps2id id=&#8217;LOAD-command&#8217; target=&#8221;\/]1. LOAD Command<\/h3>\n<p>The <strong>LOAD<\/strong> statement in Hive is used to move data files into the locations corresponding to Hive tables.<\/p>\n<ul>\n<li>If a <strong>LOCAL<\/strong> keyword is specified, then the LOAD command will look for the file path in the local filesystem.<\/li>\n<li>If the LOCAL keyword is not specified, then the Hive will need the absolute URI of the file.<\/li>\n<li>In case the keyword OVERWRITE is specified, then the contents of the target table\/partition will be deleted and replaced by the files referred by filepath.<\/li>\n<li>If the OVERWRITE keyword is not specified, then the files referred by filepath will be appended to the table.<\/li>\n<\/ul>\n<p><strong>Want to practice these Hive commands yourself?<\/strong> Follow the <strong>Hive-3.1.2 installation guide<\/strong> to install the latest Hive version on your system.<\/p>\n<p><strong>Syntax:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">LOAD DATA [LOCAL] INPATH 'filepath' [OVERWRITE] INTO TABLE tablename [PARTITION (partcol1=val1, partcol2=val2 ...)];<\/pre>\n<p><strong>Example:<\/strong><\/p>\n<p>Here we are trying to load data from the \u2018dab\u2019 file in the local filesystem to the \u2018emp_data\u2019 table.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/LOAD-statement-Hive-DML-Command1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-76762\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/LOAD-statement-Hive-DML-Command1.png\" alt=\"LOAD statement Hive DML Command\" width=\"1299\" height=\"635\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/LOAD-statement-Hive-DML-Command1.png 1299w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/LOAD-statement-Hive-DML-Command1-150x73.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/LOAD-statement-Hive-DML-Command1-300x147.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/LOAD-statement-Hive-DML-Command1-768x375.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/LOAD-statement-Hive-DML-Command1-1024x501.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/LOAD-statement-Hive-DML-Command1-520x254.png 520w\" sizes=\"auto, (max-width: 1299px) 100vw, 1299px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/SELECT_statment_to_view_data_loaded_in_hive_table-Hive-DML-Command2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-76763\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/SELECT_statment_to_view_data_loaded_in_hive_table-Hive-DML-Command2.png\" alt=\"SELECT_statment_to_view_data_loaded_in_hive_table Hive DML Command\" width=\"1299\" height=\"741\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/SELECT_statment_to_view_data_loaded_in_hive_table-Hive-DML-Command2.png 1299w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/SELECT_statment_to_view_data_loaded_in_hive_table-Hive-DML-Command2-150x86.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/SELECT_statment_to_view_data_loaded_in_hive_table-Hive-DML-Command2-300x171.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/SELECT_statment_to_view_data_loaded_in_hive_table-Hive-DML-Command2-768x438.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/SELECT_statment_to_view_data_loaded_in_hive_table-Hive-DML-Command2-1024x584.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/SELECT_statment_to_view_data_loaded_in_hive_table-Hive-DML-Command2-520x297.png 520w\" sizes=\"auto, (max-width: 1299px) 100vw, 1299px\" \/><\/a><\/p>\n<h3>[ps2id id=&#8217;SELECT-command&#8217; target=&#8221;\/]2. SELECT COMMAND<\/h3>\n<p>The SELECT statement in Hive is similar to the SELECT statement in SQL used for retrieving data from the database.<\/p>\n<p><strong>Syntax:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">SELECT col1,col2 FROM tablename;<\/pre>\n<p><strong>Example:<\/strong><\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/SELECT_statementHive-DML-Command3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-76764\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/SELECT_statementHive-DML-Command3.png\" alt=\"SELECT_statement - Hive-DML-Command\" width=\"1300\" height=\"687\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/SELECT_statementHive-DML-Command3.png 1300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/SELECT_statementHive-DML-Command3-150x79.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/SELECT_statementHive-DML-Command3-300x159.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/SELECT_statementHive-DML-Command3-768x406.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/SELECT_statementHive-DML-Command3-1024x541.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/SELECT_statementHive-DML-Command3-520x275.png 520w\" sizes=\"auto, (max-width: 1300px) 100vw, 1300px\" \/><\/a><\/p>\n<h3>[ps2id id=&#8217;INSERT-command&#8217; target=&#8221;\/]3. INSERT Command<\/h3>\n<p>The <strong>INSERT<\/strong> command in Hive loads the data into a Hive table. We can do insert to both the Hive table or partition.<\/p>\n<h4>a. INSERT INTO<\/h4>\n<p>The <strong>INSERT INTO<\/strong> statement appends the data into existing data in the table or partition. INSERT INTO statement works from Hive version 0.8.<\/p>\n<p><strong>Syntax:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">INSERT INTO TABLE tablename1 [PARTITION (partcol1=val1, partcol2=val2 ...)] select_statement1 FROM from_statement;<\/pre>\n<p><strong>Example:<\/strong><\/p>\n<p>Here in this example, we are trying to insert the data of \u2018emp_data\u2019 table created above into the table \u2018example\u2019.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/Creating_table_example-Hive-DML-Command4.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-76768\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/Creating_table_example-Hive-DML-Command4.png\" alt=\"Creating_table_example - Hive DML Commands\" width=\"1299\" height=\"741\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/Creating_table_example-Hive-DML-Command4.png 1299w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/Creating_table_example-Hive-DML-Command4-150x86.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/Creating_table_example-Hive-DML-Command4-300x171.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/Creating_table_example-Hive-DML-Command4-768x438.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/Creating_table_example-Hive-DML-Command4-1024x584.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/Creating_table_example-Hive-DML-Command4-520x297.png 520w\" sizes=\"auto, (max-width: 1299px) 100vw, 1299px\" \/><\/a><\/p>\n<p>INSERT statement to load data into table \u201cexample\u201d.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/INSERT_INTO_statement-Hive-DML-Command5.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-76765\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/INSERT_INTO_statement-Hive-DML-Command5.png\" alt=\"INSERT_INTO_statement - Hive-DML-Command\" width=\"1299\" height=\"149\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/INSERT_INTO_statement-Hive-DML-Command5.png 1299w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/INSERT_INTO_statement-Hive-DML-Command5-150x17.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/INSERT_INTO_statement-Hive-DML-Command5-300x34.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/INSERT_INTO_statement-Hive-DML-Command5-768x88.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/INSERT_INTO_statement-Hive-DML-Command5-1024x117.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/INSERT_INTO_statement-Hive-DML-Command5-520x60.png 520w\" sizes=\"auto, (max-width: 1299px) 100vw, 1299px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/Displaying_result_of_insert_into-Hive-DML-Command6.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-76769\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/Displaying_result_of_insert_into-Hive-DML-Command6.png\" alt=\"Displaying_result_of_insert_into - Hive DML Commands\" width=\"1299\" height=\"653\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/Displaying_result_of_insert_into-Hive-DML-Command6.png 1299w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/Displaying_result_of_insert_into-Hive-DML-Command6-150x75.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/Displaying_result_of_insert_into-Hive-DML-Command6-300x151.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/Displaying_result_of_insert_into-Hive-DML-Command6-768x386.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/Displaying_result_of_insert_into-Hive-DML-Command6-1024x515.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/Displaying_result_of_insert_into-Hive-DML-Command6-520x261.png 520w\" sizes=\"auto, (max-width: 1299px) 100vw, 1299px\" \/><\/a><\/p>\n<h4>b. INSERT OVERWRITE<\/h4>\n<p>The <strong>INSERT OVERWRITE<\/strong> table overwrites the existing data in the table or partition.<\/p>\n<p><strong>Syntax:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">INSERT OVERWRITE TABLE tablename1 [PARTITION (partcol1=val1, ..) [IF NOT EXISTS]] select_statement FROM from_statement;<\/pre>\n<p><strong>Example:<\/strong><\/p>\n<p>Here we are overwriting the existing data of the table \u2018example\u2019 with the data of table \u2018dummy\u2019 using INSERT OVERWRITE statement.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/INSERT_OVERWRITE_statement-Hive-DML-Command7.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-76770\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/INSERT_OVERWRITE_statement-Hive-DML-Command7.png\" alt=\"INSERT_OVERWRITE_statement - Hive DML Commands\" width=\"1299\" height=\"156\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/INSERT_OVERWRITE_statement-Hive-DML-Command7.png 1299w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/INSERT_OVERWRITE_statement-Hive-DML-Command7-150x18.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/INSERT_OVERWRITE_statement-Hive-DML-Command7-300x36.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/INSERT_OVERWRITE_statement-Hive-DML-Command7-768x92.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/INSERT_OVERWRITE_statement-Hive-DML-Command7-1024x123.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/INSERT_OVERWRITE_statement-Hive-DML-Command7-520x62.png 520w\" sizes=\"auto, (max-width: 1299px) 100vw, 1299px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/Executing_insert_overwrite-Hive-DML-Command8.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-76771\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/Executing_insert_overwrite-Hive-DML-Command8.png\" alt=\"Executing_insert_overwrite - Hive DML Commands\" width=\"1299\" height=\"741\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/Executing_insert_overwrite-Hive-DML-Command8.png 1299w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/Executing_insert_overwrite-Hive-DML-Command8-150x86.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/Executing_insert_overwrite-Hive-DML-Command8-300x171.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/Executing_insert_overwrite-Hive-DML-Command8-768x438.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/Executing_insert_overwrite-Hive-DML-Command8-1024x584.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/Executing_insert_overwrite-Hive-DML-Command8-520x297.png 520w\" sizes=\"auto, (max-width: 1299px) 100vw, 1299px\" \/><\/a><\/p>\n<p>By using the SELECT statement we can verify whether the existing data of the table \u2018example\u2019 is overwritten by the data of table \u2018dummy\u2019 or not.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/displaying_result_of_insert_overwrite-Hive-DML-Command9.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-76772\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/displaying_result_of_insert_overwrite-Hive-DML-Command9.png\" alt=\"displaying_result_of_insert_overwrite - Hive DML Command\" width=\"1299\" height=\"643\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/displaying_result_of_insert_overwrite-Hive-DML-Command9.png 1299w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/displaying_result_of_insert_overwrite-Hive-DML-Command9-150x74.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/displaying_result_of_insert_overwrite-Hive-DML-Command9-300x148.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/displaying_result_of_insert_overwrite-Hive-DML-Command9-768x380.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/displaying_result_of_insert_overwrite-Hive-DML-Command9-1024x507.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/displaying_result_of_insert_overwrite-Hive-DML-Command9-520x257.png 520w\" sizes=\"auto, (max-width: 1299px) 100vw, 1299px\" \/><\/a><\/p>\n<h4>c. INSERT .. VALUES<\/h4>\n<p>INSERT ..VALUES statement in Hive inserts data into the table directly from SQL. It is available from Hive 0.14.<\/p>\n<p><strong>Syntax:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">INSERT INTO TABLE tablename [PARTITION (partcol1[=val1], partcol2[=val2] ...)] VALUES values_row [, values_row ...];<\/pre>\n<p><strong>Example:<\/strong><\/p>\n<p>Inserting data into the \u2018student\u2019 table using INSERT ..VALUES statement.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/INSERT_VALUES_statement-Hive-DML-Command10.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-76774\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/INSERT_VALUES_statement-Hive-DML-Command10.png\" alt=\"INSERT_VALUES_statement - Hive DML Commands\" width=\"1299\" height=\"146\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/INSERT_VALUES_statement-Hive-DML-Command10.png 1299w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/INSERT_VALUES_statement-Hive-DML-Command10-150x17.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/INSERT_VALUES_statement-Hive-DML-Command10-300x34.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/INSERT_VALUES_statement-Hive-DML-Command10-768x86.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/INSERT_VALUES_statement-Hive-DML-Command10-1024x115.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/INSERT_VALUES_statement-Hive-DML-Command10-520x58.png 520w\" sizes=\"auto, (max-width: 1299px) 100vw, 1299px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/displaying_result_of_insert_values_statement-Hive-DML-Command11.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-76775\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/displaying_result_of_insert_values_statement-Hive-DML-Command11.png\" alt=\"displaying_result_of_insert_values_statement - Hive DML commands\" width=\"1299\" height=\"682\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/displaying_result_of_insert_values_statement-Hive-DML-Command11.png 1299w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/displaying_result_of_insert_values_statement-Hive-DML-Command11-150x79.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/displaying_result_of_insert_values_statement-Hive-DML-Command11-300x158.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/displaying_result_of_insert_values_statement-Hive-DML-Command11-768x403.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/displaying_result_of_insert_values_statement-Hive-DML-Command11-1024x538.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/displaying_result_of_insert_values_statement-Hive-DML-Command11-520x273.png 520w\" sizes=\"auto, (max-width: 1299px) 100vw, 1299px\" \/><\/a><\/p>\n<h3>[ps2id id=&#8217;DELETE-command&#8217; target=&#8221;\/]4. DELETE command<\/h3>\n<p>The DELETE statement in Hive deletes the table data. If the WHERE clause is specified, then it deletes the rows that satisfy the condition in where clause.<\/p>\n<p>The DELETE statement can only be used on the hive tables that support ACID.<\/p>\n<p><strong>Syntax:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">DELETE FROM tablename [WHERE expression];<\/pre>\n<p><strong>Example:<\/strong><\/p>\n<p>In the below example, we are deleting the data of the student from table \u2018student\u2019 whose roll_no is 105.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/DELETE_statement-Hive-DML-Command12.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-76776\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/DELETE_statement-Hive-DML-Command12.png\" alt=\"DELETE_statement - Hive DML Commands\" width=\"1299\" height=\"693\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/DELETE_statement-Hive-DML-Command12.png 1299w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/DELETE_statement-Hive-DML-Command12-150x80.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/DELETE_statement-Hive-DML-Command12-300x160.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/DELETE_statement-Hive-DML-Command12-768x410.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/DELETE_statement-Hive-DML-Command12-1024x546.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/DELETE_statement-Hive-DML-Command12-520x277.png 520w\" sizes=\"auto, (max-width: 1299px) 100vw, 1299px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/executing_DELETE_statement-Hive-DML-Command13.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-76777\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/executing_DELETE_statement-Hive-DML-Command13.png\" alt=\"executing_DELETE_statement - Hive DML Commands\" width=\"1299\" height=\"740\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/executing_DELETE_statement-Hive-DML-Command13.png 1299w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/executing_DELETE_statement-Hive-DML-Command13-150x85.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/executing_DELETE_statement-Hive-DML-Command13-300x171.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/executing_DELETE_statement-Hive-DML-Command13-768x438.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/executing_DELETE_statement-Hive-DML-Command13-1024x583.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/executing_DELETE_statement-Hive-DML-Command13-520x296.png 520w\" sizes=\"auto, (max-width: 1299px) 100vw, 1299px\" \/><\/a><\/p>\n<p>By using the SELECT statement we can verify whether the data of the student from table \u2018student\u2019 whose roll_no is 105 is deleted or not.<a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/displaying_result_after_delete-Hive-DML-Command14.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-76778\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/displaying_result_after_delete-Hive-DML-Command14.png\" alt=\"displaying_result_after_delete - Hive DML Commands\" width=\"1299\" height=\"741\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/displaying_result_after_delete-Hive-DML-Command14.png 1299w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/displaying_result_after_delete-Hive-DML-Command14-150x86.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/displaying_result_after_delete-Hive-DML-Command14-300x171.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/displaying_result_after_delete-Hive-DML-Command14-768x438.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/displaying_result_after_delete-Hive-DML-Command14-1024x584.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/displaying_result_after_delete-Hive-DML-Command14-520x297.png 520w\" sizes=\"auto, (max-width: 1299px) 100vw, 1299px\" \/><\/a><\/p>\n<h3>[ps2id id=&#8217;UPDATE-command&#8217; target=&#8221;\/]5. UPDATE Command<\/h3>\n<p>The update can be performed on the hive tables that support ACID.<\/p>\n<p>The UPDATE statement in Hive deletes the table data. If the WHERE clause is specified, then it updates the column of the rows that satisfy the condition in WHERE clause.<\/p>\n<p>Partitioning and <strong>Bucketing<\/strong> columns cannot be updated.<\/p>\n<p><strong>Syntax:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">UPDATE tablename SET column = value [, column = value ...] [WHERE expression];<\/pre>\n<p><strong>Example:<\/strong><\/p>\n<p>In this example, we are updating the branch of the student whose roll_no is 103 in the \u2018student\u2019 table using an UPDATE statement.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/UPDATE-statement-Hive-DML-Command15.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-76779\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/UPDATE-statement-Hive-DML-Command15.png\" alt=\"UPDATE-statement - Hive DML Commands\" width=\"1299\" height=\"664\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/UPDATE-statement-Hive-DML-Command15.png 1299w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/UPDATE-statement-Hive-DML-Command15-150x77.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/UPDATE-statement-Hive-DML-Command15-300x153.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/UPDATE-statement-Hive-DML-Command15-768x393.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/UPDATE-statement-Hive-DML-Command15-1024x523.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/UPDATE-statement-Hive-DML-Command15-520x266.png 520w\" sizes=\"auto, (max-width: 1299px) 100vw, 1299px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/executing_update_statement-Hive-DML-Command16.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-76780\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/executing_update_statement-Hive-DML-Command16.png\" alt=\"executing_update_statement - Hive DML Commands\" width=\"1299\" height=\"740\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/executing_update_statement-Hive-DML-Command16.png 1299w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/executing_update_statement-Hive-DML-Command16-150x85.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/executing_update_statement-Hive-DML-Command16-300x171.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/executing_update_statement-Hive-DML-Command16-768x438.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/executing_update_statement-Hive-DML-Command16-1024x583.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/executing_update_statement-Hive-DML-Command16-520x296.png 520w\" sizes=\"auto, (max-width: 1299px) 100vw, 1299px\" \/><\/a><\/p>\n<p>By using the SELECT statement we can verify whether the branch of the student whose roll_no is 103 in the \u2018student\u2019 table is updated or not.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/displaying_result_after_update-Hive-DML-Command17.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-76782\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/displaying_result_after_update-Hive-DML-Command17.png\" alt=\"displaying_result_after_update - Hive DML Commands\" width=\"1299\" height=\"740\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/displaying_result_after_update-Hive-DML-Command17.png 1299w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/displaying_result_after_update-Hive-DML-Command17-150x85.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/displaying_result_after_update-Hive-DML-Command17-300x171.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/displaying_result_after_update-Hive-DML-Command17-768x438.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/displaying_result_after_update-Hive-DML-Command17-1024x583.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/displaying_result_after_update-Hive-DML-Command17-520x296.png 520w\" sizes=\"auto, (max-width: 1299px) 100vw, 1299px\" \/><\/a><\/p>\n<h3>[ps2id id=&#8217;EXPORT-command&#8217; target=&#8221;\/]6. EXPORT Command<\/h3>\n<p>The Hive <strong>EXPORT<\/strong> statement exports the table or <strong>partition<\/strong> data along with the metadata to the specified output location in the HDFS.<\/p>\n<p>Metadata is exported in a <strong>_metadata<\/strong> file, and data is exported in a subdirectory <strong>\u2018data.\u2019<\/strong><\/p>\n<p><strong>Syntax:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">EXPORT TABLE tablename [PARTITION (part_column=\"value\"[, ...])]\nTO 'export_target_path' [ FOR replication('eventid') ];<\/pre>\n<p><strong>Example:<\/strong><\/p>\n<p>Here in this example, we are exporting the student table to the HDFS directory \u201cexport_from_hive\u201d.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/EXPORT-statement-Hive-DML-Command18.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-76783\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/EXPORT-statement-Hive-DML-Command18.png\" alt=\"EXPORT-statement - Hive DML Commands\" width=\"1299\" height=\"121\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/EXPORT-statement-Hive-DML-Command18.png 1299w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/EXPORT-statement-Hive-DML-Command18-150x14.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/EXPORT-statement-Hive-DML-Command18-300x28.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/EXPORT-statement-Hive-DML-Command18-768x72.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/EXPORT-statement-Hive-DML-Command18-1024x95.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/EXPORT-statement-Hive-DML-Command18-520x48.png 520w\" sizes=\"auto, (max-width: 1299px) 100vw, 1299px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/executing_export_statement-Hive-DML-Command19.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-76784\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/executing_export_statement-Hive-DML-Command19.png\" alt=\"executing_export_statement\" width=\"1299\" height=\"741\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/executing_export_statement-Hive-DML-Command19.png 1299w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/executing_export_statement-Hive-DML-Command19-150x86.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/executing_export_statement-Hive-DML-Command19-300x171.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/executing_export_statement-Hive-DML-Command19-768x438.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/executing_export_statement-Hive-DML-Command19-1024x584.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/executing_export_statement-Hive-DML-Command19-520x297.png 520w\" sizes=\"auto, (max-width: 1299px) 100vw, 1299px\" \/><\/a><\/p>\n<p>The table successfully exported. You can check for the _metadata file and data sub-directory using <strong>ls<\/strong> command.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/displaying_exported_table_directory_Hive-DML-Command20.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-76785\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/displaying_exported_table_directory_Hive-DML-Command20.png\" alt=\"displaying_exported_table_directory_Hive DML Commands\" width=\"1299\" height=\"248\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/displaying_exported_table_directory_Hive-DML-Command20.png 1299w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/displaying_exported_table_directory_Hive-DML-Command20-150x29.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/displaying_exported_table_directory_Hive-DML-Command20-300x57.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/displaying_exported_table_directory_Hive-DML-Command20-768x147.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/displaying_exported_table_directory_Hive-DML-Command20-1024x195.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/displaying_exported_table_directory_Hive-DML-Command20-520x99.png 520w\" sizes=\"auto, (max-width: 1299px) 100vw, 1299px\" \/><\/a><\/p>\n<h3>[ps2id id=&#8217;IMPORT-command&#8217; target=&#8221;\/]7. IMPORT Command<\/h3>\n<p>The Hive IMPORT command imports the data from a specified location to a new table or already existing table.<\/p>\n<p><strong>Syntax:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">IMPORT [[EXTERNAL] TABLE new_or_original_tablename [PARTITION (part_column=\"value\"[, ...])]]\nFROM 'source_path' [LOCATION 'import_target_path'];<\/pre>\n<p><strong>Example:<\/strong><\/p>\n<p>Here in this example, we are importing the data exported in the above example into a new Hive table \u2018imported_table\u2019.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/IMPORT-statement-Hive-DML-Command21.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-76786\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/IMPORT-statement-Hive-DML-Command21.png\" alt=\"IMPORT-statement-Hive-DML-Commands\" width=\"1299\" height=\"119\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/IMPORT-statement-Hive-DML-Command21.png 1299w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/IMPORT-statement-Hive-DML-Command21-150x14.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/IMPORT-statement-Hive-DML-Command21-300x27.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/IMPORT-statement-Hive-DML-Command21-768x70.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/IMPORT-statement-Hive-DML-Command21-1024x94.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/IMPORT-statement-Hive-DML-Command21-520x48.png 520w\" sizes=\"auto, (max-width: 1299px) 100vw, 1299px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/executing_import_statement-Hive-DML-Command22.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-76788\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/executing_import_statement-Hive-DML-Command22.png\" alt=\"executing_import_statement - Hive DML Commands\" width=\"1299\" height=\"664\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/executing_import_statement-Hive-DML-Command22.png 1299w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/executing_import_statement-Hive-DML-Command22-150x77.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/executing_import_statement-Hive-DML-Command22-300x153.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/executing_import_statement-Hive-DML-Command22-768x393.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/executing_import_statement-Hive-DML-Command22-1024x523.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/executing_import_statement-Hive-DML-Command22-520x266.png 520w\" sizes=\"auto, (max-width: 1299px) 100vw, 1299px\" \/><\/a><\/p>\n<p>Verifying whether the data is imported or not using hive SELECT statement.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/displaying_import_table_result-Hive-DML-Command23.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-76789\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/displaying_import_table_result-Hive-DML-Command23.png\" alt=\"displaying_import_table_result\" width=\"1299\" height=\"527\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/displaying_import_table_result-Hive-DML-Command23.png 1299w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/displaying_import_table_result-Hive-DML-Command23-150x61.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/displaying_import_table_result-Hive-DML-Command23-300x122.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/displaying_import_table_result-Hive-DML-Command23-768x312.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/displaying_import_table_result-Hive-DML-Command23-1024x415.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/displaying_import_table_result-Hive-DML-Command23-520x211.png 520w\" sizes=\"auto, (max-width: 1299px) 100vw, 1299px\" \/><\/a><\/p>\n<h2>Summary<\/h2>\n<p>After reading this article, I hope now you are familiar with the Hive DML commands.<\/p>\n<p>The article explained how to load data into the Hive table, insert data into the Hive table, and delete rows from the hive table. In addition, we have studied how to update the particular row column in a table. We have also seen the Hive IMPORT and EXPORT statement with the help of an example.<\/p>\n<p><strong>Do you love DataFlair efforts?<\/strong> Please review us <strong>here<\/strong>.<\/p>\n<p><strong>Any queries while practicing Hive commands?<\/strong><\/p>\n<p>Ask us freely.<\/p>\n<p>Keep Practicing!!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Wishing to load, insert, retrieve, update, or delete data in the Hive tables? After learning basic Commands in Hive, let us now study Hive DML Commands. Hive Data Manipulation Language commands are used for&#46;&#46;&#46;<\/p>\n","protected":false},"author":7,"featured_media":76795,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[26],"tags":[22072,5693,22050,22073,22076,22075,22074,22077],"class_list":["post-76760","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-hive","tag-dml-commands-in-hive","tag-hive-commands","tag-hive-commands-with-examples","tag-hive-dml-commands","tag-hive-insert-command","tag-hive-load-command","tag-hive-select-command","tag-hive-update-command"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Top 7 Hive DML Commands with Syntax and Examples - DataFlair<\/title>\n<meta name=\"description\" content=\"Explore How Hive Data Manipulation Language(DML) commands are used for inserting, retrieving, modifying, deleting, &amp; updating data in the Hive table.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/hive-dml-commands\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Top 7 Hive DML Commands with Syntax and Examples - DataFlair\" \/>\n<meta property=\"og:description\" content=\"Explore How Hive Data Manipulation Language(DML) commands are used for inserting, retrieving, modifying, deleting, &amp; updating data in the Hive table.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/hive-dml-commands\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2020-03-05T07:03:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/Hive-DML-Commands.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"802\" \/>\n\t<meta property=\"og:image:height\" content=\"420\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"10 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Top 7 Hive DML Commands with Syntax and Examples - DataFlair","description":"Explore How Hive Data Manipulation Language(DML) commands are used for inserting, retrieving, modifying, deleting, & updating data in the Hive table.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/data-flair.training\/blogs\/hive-dml-commands\/","og_locale":"en_US","og_type":"article","og_title":"Top 7 Hive DML Commands with Syntax and Examples - DataFlair","og_description":"Explore How Hive Data Manipulation Language(DML) commands are used for inserting, retrieving, modifying, deleting, & updating data in the Hive table.","og_url":"https:\/\/data-flair.training\/blogs\/hive-dml-commands\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2020-03-05T07:03:32+00:00","og_image":[{"width":802,"height":420,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/Hive-DML-Commands.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"10 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/hive-dml-commands\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/hive-dml-commands\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/beb0cab24b7aa54423a3b50e669a9dcd"},"headline":"Top 7 Hive DML Commands with Syntax and Examples","datePublished":"2020-03-05T07:03:32+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/hive-dml-commands\/"},"wordCount":1017,"commentCount":2,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/hive-dml-commands\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/Hive-DML-Commands.jpg","keywords":["dml commands in Hive","Hive Commands","hive commands with examples","Hive dml commands","Hive insert command","Hive load command","Hive select command","Hive update command"],"articleSection":["Hive Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/hive-dml-commands\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/hive-dml-commands\/","url":"https:\/\/data-flair.training\/blogs\/hive-dml-commands\/","name":"Top 7 Hive DML Commands with Syntax and Examples - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/hive-dml-commands\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/hive-dml-commands\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/Hive-DML-Commands.jpg","datePublished":"2020-03-05T07:03:32+00:00","description":"Explore How Hive Data Manipulation Language(DML) commands are used for inserting, retrieving, modifying, deleting, & updating data in the Hive table.","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/hive-dml-commands\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/hive-dml-commands\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/hive-dml-commands\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/Hive-DML-Commands.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/03\/Hive-DML-Commands.jpg","width":802,"height":420,"caption":"Hive DML Commands"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/hive-dml-commands\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"Hive Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/hive\/"},{"@type":"ListItem","position":3,"name":"Top 7 Hive DML Commands with Syntax and Examples"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/beb0cab24b7aa54423a3b50e669a9dcd","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/c322416204232f4dd97ef3901b0a499a5d34d7ba7fe333f4bfe53a907873d293?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/c322416204232f4dd97ef3901b0a499a5d34d7ba7fe333f4bfe53a907873d293?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322416204232f4dd97ef3901b0a499a5d34d7ba7fe333f4bfe53a907873d293?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"DataFlair Team specializes in creating clear, actionable content on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Backed by industry expertise, we make learning easy and career-oriented for beginners and pros alike.","url":"https:\/\/data-flair.training\/blogs\/author\/dfteam3\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/76760","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=76760"}],"version-history":[{"count":0,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/76760\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/76795"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=76760"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=76760"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=76760"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}