{"id":81111,"date":"2020-08-25T14:03:09","date_gmt":"2020-08-25T08:33:09","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=81111"},"modified":"2020-08-25T14:03:09","modified_gmt":"2020-08-25T08:33:09","slug":"apache-hive-create-table","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/apache-hive-create-table\/","title":{"rendered":"Hive Create Table Commands and Examples"},"content":{"rendered":"<p>In this article, we will learn how to create tables in Apache Hive. The article explains the syntax for creating Hive Non-ACID transaction tables as well as ACID transaction tables in Hive.<\/p>\n<p>You will also explore the properties which you have to set true for creating an ACID Hive transaction table. Firstly we will see how to create a Non-ACID transaction table. Then we will see how to create ACID hive transaction tables.<\/p>\n<p>&nbsp;<\/p>\n<h3>What are ACID Transactions?<\/h3>\n<p>ACID stands for the 4 traits of the database transactions that are Atomicity, Consistency, Isolation, and Durability.<\/p>\n<ul>\n<li><strong>Atomicity:<\/strong> It ensures that an operation will either succeed completely or fails. No operation will leave partial data.<\/li>\n<li><strong>Consistency:<\/strong> It ensures that once an application performs an operation then the results of that particular operation is visible to it in its every subsequent operation.<\/li>\n<li><strong>Isolation:<\/strong> It ensures that the incomplete operation by one user does not cause any unexpected side effects for other users.<\/li>\n<li><strong>Durability:<\/strong> It ensures that once an operation is complete then it will be preserved even in the case of machine or system failure.<\/li>\n<\/ul>\n<p>Up until Hive 0.13, at the partition level, atomicity, consistency, and durability were provided. Isolation can be provided by starting any locking mechanisms like ZooKeeper or in memory. The transaction was added in Hive 0.13 that provides full ACID support at the row level.<\/p>\n<p>Thus, one application can add rows while the other is reading data from the same partition without getting interfering with each other.<\/p>\n<h3>Create Non-ACID transaction Hive Table<\/h3>\n<p>The syntax for creating Non-ACID transaction table in Hive is:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">CREATE TABLE [IF NOT EXISTS] [db_name.] table_name [(col_name data_type [COMMENT col_comment], ... [COMMENT col_comment])] [COMMENT table_comment] [ROW FORMAT row_format] [FIELDS TERMINATED BY \u201c\u201d] [STORED AS file_format] [LOCATION hdfs_path];\n<\/pre>\n<p>In the above syntax:<\/p>\n<ul>\n<li><strong>ROW FORMAT DELIMITED<\/strong> specifies Hive that when it encounters a new line character, then that means a new record.<\/li>\n<li><strong>FIELDS TERMINATED BY \u2018,\u2019 <\/strong>informs Hive about what delimiter we are using in our data files to separate each column.<\/li>\n<li><strong>STORED AS TEXTFILE<\/strong> informs Hive about what type of file to expect.<\/li>\n<\/ul>\n<h3>Example of Hive Non- ACID Transaction Table<\/h3>\n<p>For creating a table, first we have to use the database in which we want to create the table. In this example, I am creating a table in the database \u201cdataflair\u201d.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image10.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-81124\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image10.png\" alt=\"\" width=\"1366\" height=\"576\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image10.png 1366w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image10-300x127.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image10-1024x432.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image10-150x63.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image10-768x324.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image10-520x219.png 520w\" sizes=\"auto, (max-width: 1366px) 100vw, 1366px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Now I am creating a table name \u201cemploy_detail\u201d in the database \u201cdataflair\u201d.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image3-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-81117\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image3-1.png\" alt=\"\" width=\"1366\" height=\"292\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image3-1.png 1366w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image3-1-300x64.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image3-1-1024x219.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image3-1-150x32.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image3-1-768x164.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image3-1-520x111.png 520w\" sizes=\"auto, (max-width: 1366px) 100vw, 1366px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image6.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-81120\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image6.png\" alt=\"\" width=\"1366\" height=\"744\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image6.png 1366w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image6-300x163.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image6-1024x558.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image6-150x82.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image6-768x418.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image6-520x283.png 520w\" sizes=\"auto, (max-width: 1366px) 100vw, 1366px\" \/><\/a><\/p>\n<p>You can insert data into the Non-ACID transaction table by using LOAD command. I am inserting data into my employ_detail as:<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image7.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-81121\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image7.png\" alt=\"\" width=\"1366\" height=\"690\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image7.png 1366w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image7-300x152.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image7-1024x517.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image7-150x76.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image7-768x388.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image7-520x263.png 520w\" sizes=\"auto, (max-width: 1366px) 100vw, 1366px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>Now to see the data in the table, you can use the SELECT statement as:<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image2-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-81116\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image2-2.png\" alt=\"hive create table\" width=\"1366\" height=\"136\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image2-2.png 1366w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image2-2-300x30.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image2-2-1024x102.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image2-2-150x15.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image2-2-768x76.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image2-2-520x52.png 520w\" sizes=\"auto, (max-width: 1366px) 100vw, 1366px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image8.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-81122\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image8.png\" alt=\"\" width=\"1366\" height=\"744\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image8.png 1366w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image8-300x163.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image8-1024x558.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image8-150x82.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image8-768x418.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image8-520x283.png 520w\" sizes=\"auto, (max-width: 1366px) 100vw, 1366px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>In this way, we can create Non-ACID transaction Hive tables.<\/p>\n<p>Let us now see how to create an ACID transaction table in Hive.<\/p>\n<h3>Create ACID Transaction Hive Table<\/h3>\n<p>For creating ACID transaction tables in Hive we have to first set the below mentioned configuration parameters for turning on the transaction support in Hive.<\/p>\n<h4>1. Setting Configuration Parameters<\/h4>\n<p>At client side:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">SET hive.support.concurrency=true;\nSET hive.enforce.bucketing=true;\nSET hive.exec.dynamic.partition.mode=nonstrict;\nSet hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;\n<\/pre>\n<p>At server side (Metastore):<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">SET hive.compactor.initiator.on=true;\nSET hive.compactor.worker.threads=1;\n<\/pre>\n<p>You can set these configuration properties either in the hive-site.xml file or in the start of the session before any query runs.<\/p>\n<h4>2. Table Properties<\/h4>\n<p>For using a table in ACID writes ( such as insert, update, delete) then we have to set the table property &#8220;transactional=true&#8221;. Once we define a table as an ACID table via TBLPROPERTIES (&#8220;transactional&#8221;=&#8221;true&#8221;), then we cannot convert it back to a non-ACID table by changing TBLPROPERTIES (&#8220;transactional&#8221;=&#8221;false&#8221;). This is not allowed.<\/p>\n<p>Syntax for Creating ACID Transaction Hive Table:<\/p>\n<p>The ACID transaction Hive table currently supports only ORC format.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">CREATE TABLE [IF NOT EXISTS] table_name (Colm_name datatype, Colm_name datatype, \u2026...) CLUSTERED BY (col_name, col_name, ...) [SORTED BY (col_name [ASC|DESC], ...)] INTO num_buckets BUCKETS STORED AS ORC TBLPROPERTIES (transaction=true, ...);\n<\/pre>\n<p>Let us now see an example where we create a Hive ACID transaction table and perform INSERT.<\/p>\n<h3>Example of Hive ACID transaction Table<\/h3>\n<p>In the below example, we are creating a Hive ACID transaction table name \u201cemploy\u201d.<\/p>\n<p>For creating a Hive table, we will first set the above-mentioned configuration properties before running queries.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image1-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-81115\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image1-2.png\" alt=\"create table in hive\" width=\"1366\" height=\"520\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image1-2.png 1366w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image1-2-300x114.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image1-2-1024x390.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image1-2-150x57.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image1-2-768x292.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image1-2-520x198.png 520w\" sizes=\"auto, (max-width: 1366px) 100vw, 1366px\" \/><\/a><\/p>\n<p>Now, we will create \u2018employ\u2019 table as:<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image5-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-81119\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image5-1.png\" alt=\"\" width=\"1366\" height=\"200\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image5-1.png 1366w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image5-1-300x44.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image5-1-1024x150.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image5-1-150x22.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image5-1-768x112.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image5-1-520x76.png 520w\" sizes=\"auto, (max-width: 1366px) 100vw, 1366px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image9.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-81123\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image9.png\" alt=\"\" width=\"1366\" height=\"668\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image9.png 1366w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image9-300x147.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image9-1024x501.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image9-150x73.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image9-768x376.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image9-520x254.png 520w\" sizes=\"auto, (max-width: 1366px) 100vw, 1366px\" \/><\/a><\/p>\n<p>Now, we will insert data into the employ table using INSERT INTO statement as:<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image4-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-81118\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image4-1.png\" alt=\"SELECT Statement in Hive\" width=\"1366\" height=\"176\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image4-1.png 1366w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image4-1-300x39.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image4-1-1024x132.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image4-1-150x19.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image4-1-768x99.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/image4-1-520x67.png 520w\" sizes=\"auto, (max-width: 1366px) 100vw, 1366px\" \/><\/a><\/p>\n<p>Using select statement to check the data is inserted or not:<\/p>\n<p>Thus, in this manner we can create ACID transactions tables in Hive.<\/p>\n<h2>Summary<\/h2>\n<p>I hope after reading this Hive Create Table article, you now understand what the ACID transaction is? And how we can create Non-ACID and ACID transaction tables in Hive. The article explains the syntax and the configuration parameters to be set for creating an ACID table through an example. You can implement this example in your own system.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this article, we will learn how to create tables in Apache Hive. The article explains the syntax for creating Hive Non-ACID transaction tables as well as ACID transaction tables in Hive. You will&#46;&#46;&#46;<\/p>\n","protected":false},"author":7,"featured_media":81114,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[26],"tags":[23050,23049],"class_list":["post-81111","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-hive","tag-create-table-in-apache-hive","tag-hive-create-table"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Hive Create Table Commands and Examples - DataFlair<\/title>\n<meta name=\"description\" content=\"Learn Hive Create Table Commands and Examples - Learn the syntax for creating Hive Non-ACID transaction tables as well as ACID transaction tables in Hive\" \/>\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\/apache-hive-create-table\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Hive Create Table Commands and Examples - DataFlair\" \/>\n<meta property=\"og:description\" content=\"Learn Hive Create Table Commands and Examples - Learn the syntax for creating Hive Non-ACID transaction tables as well as ACID transaction tables in Hive\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/apache-hive-create-table\/\" \/>\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-08-25T08:33:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/Hive-Create-Table.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\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=\"6 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Hive Create Table Commands and Examples - DataFlair","description":"Learn Hive Create Table Commands and Examples - Learn the syntax for creating Hive Non-ACID transaction tables as well as ACID transaction tables in Hive","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\/apache-hive-create-table\/","og_locale":"en_US","og_type":"article","og_title":"Hive Create Table Commands and Examples - DataFlair","og_description":"Learn Hive Create Table Commands and Examples - Learn the syntax for creating Hive Non-ACID transaction tables as well as ACID transaction tables in Hive","og_url":"https:\/\/data-flair.training\/blogs\/apache-hive-create-table\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2020-08-25T08:33:09+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/Hive-Create-Table.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":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/apache-hive-create-table\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/apache-hive-create-table\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/beb0cab24b7aa54423a3b50e669a9dcd"},"headline":"Hive Create Table Commands and Examples","datePublished":"2020-08-25T08:33:09+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/apache-hive-create-table\/"},"wordCount":731,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/apache-hive-create-table\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/Hive-Create-Table.jpg","keywords":["create table in apache hive","Hive Create Table"],"articleSection":["Hive Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/apache-hive-create-table\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/apache-hive-create-table\/","url":"https:\/\/data-flair.training\/blogs\/apache-hive-create-table\/","name":"Hive Create Table Commands and Examples - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/apache-hive-create-table\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/apache-hive-create-table\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/Hive-Create-Table.jpg","datePublished":"2020-08-25T08:33:09+00:00","description":"Learn Hive Create Table Commands and Examples - Learn the syntax for creating Hive Non-ACID transaction tables as well as ACID transaction tables in Hive","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/apache-hive-create-table\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/apache-hive-create-table\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/apache-hive-create-table\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/Hive-Create-Table.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2020\/08\/Hive-Create-Table.jpg","width":1200,"height":628,"caption":"Hive Create Table"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/apache-hive-create-table\/#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":"Hive Create Table Commands 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\/81111","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=81111"}],"version-history":[{"count":0,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/81111\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/81114"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=81111"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=81111"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=81111"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}