{"id":10147,"date":"2018-03-07T12:13:36","date_gmt":"2018-03-07T12:13:36","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=10147"},"modified":"2018-03-07T12:13:36","modified_gmt":"2018-03-07T12:13:36","slug":"hive-view-hive-index","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/hive-view-hive-index\/","title":{"rendered":"Apache Hive View and Hive Index"},"content":{"rendered":"<p><span style=\"font-weight: 400\">In our last article, we see <strong>Hive Built-in Functions<\/strong>. In this Hive index Tutorial, we will learn the whole concept of Hive Views and Indexing in Hive. <\/span><\/p>\n<p><span style=\"font-weight: 400\">Also, we will cover how to create Hive Index and hive Views, manage views and Indexing of hive, hive index types, hive index performance, and hive view performance. In addition, we will learn several examples to understand both. <\/span><\/p>\n<p><span style=\"font-weight: 400\">We can save any result set data as a view. Whereas Apache Hive Index is a pointer to a particular column of a table. However, \u00a0there is much more to learn about Apache Hive View and Indexing in <strong>Apache Hive<\/strong>.\u00a0<\/span><\/p>\n<h2><span style=\"font-weight: 400\">Apache Hive View and Index<\/span><\/h2>\n<p>In this Part of a tutorial, we are going to study definition and concept of Apache Hive View and Hive Index.<\/p>\n<h3><span style=\"font-weight: 400\">a. What is Hive view?<\/span><\/h3>\n<p><span style=\"font-weight: 400\">Basically, Apache Hive View is similar to Hive tables, that are generated on the basis of requirements.<\/span><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Hive-View.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-10150 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Hive-View.png\" alt=\"Hive View and Indexes\" width=\"1200\" height=\"628\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Hive-View.png 1200w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Hive-View-150x79.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Hive-View-300x157.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Hive-View-768x402.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Hive-View-1024x536.png 1024w\" sizes=\"auto, (max-width: 1200px) 100vw, 1200px\" \/><\/a><\/p>\n<p>Apache Hive View on External Table<\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">As a Hive view, we can save any result set data.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Well, we can say its usage is as same as the use of views in SQL.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Although, we can perform all type of DML operations on Hive views.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">In other words, Apache Hive View is a searchable object in a database which we can define by the query. However, we can not store data in the view. Still, some refer to as a view as \u201cvirtual tables\u201d. <\/span><\/p>\n<p><span style=\"font-weight: 400\">Hence, we can query a view like we can a table. Moreover, by using joins it is possible to combine data from or more table. Also, it contains a subset of information.\u00a0<\/span><\/p>\n<h4><span style=\"font-weight: 400\">i. Apache Hive View Syntax<\/span><\/h4>\n<p><b>Create VIEW &lt; VIEWNAME&gt; AS SELECT<\/b><\/p>\n<h4><span style=\"font-weight: 400\">ii. Creating a Hive View<\/span><\/h4>\n<p><span style=\"font-weight: 400\">However, at the time of executing a SELECT statement, we can create a view. So, to create Hive view Syntax is:<\/span><br \/>\n<b>CREATE VIEW [IF NOT EXISTS] view_name [(column_name [COMMENT column_comment], &#8230;) ]<\/b><br \/>\n<b>[COMMENT table_comment]<\/b><br \/>\n<b>AS SELECT &#8230;<\/b><\/p>\n<h4><span style=\"font-weight: 400\">iii. Apache Hive View Example<\/span><\/h4>\n<p><span style=\"font-weight: 400\">Let\u2019s suppose, an employee table. It includes fields Id, Name, Salary, Designation, and Dept. Now here we are generating a query to retrieve the employee details who earn a salary of more than Rs 35000. So, we store the result in a view named emp_30000.<\/span><br \/>\n<strong>Table 1- Apache Hive View<\/strong><\/p>\n<table>\n<tbody>\n<tr>\n<td><b>ID<\/b><\/td>\n<td><b>Name<\/b><\/td>\n<td><b>Salary<\/b><\/td>\n<td><b>Designation<\/b><\/td>\n<td><b>Dept<\/b><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">1201<\/span><\/td>\n<td><span style=\"font-weight: 400\">Michel <\/span><\/td>\n<td><span style=\"font-weight: 400\">45000<\/span><\/td>\n<td><span style=\"font-weight: 400\">Technical manager<\/span><\/td>\n<td><span style=\"font-weight: 400\">TP<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">1202<\/span><\/td>\n<td><span style=\"font-weight: 400\">Chandler<\/span><\/td>\n<td><span style=\"font-weight: 400\">45000<\/span><\/td>\n<td><span style=\"font-weight: 400\">Proofreader<\/span><\/td>\n<td><span style=\"font-weight: 400\">PR<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">1203<\/span><\/td>\n<td><span style=\"font-weight: 400\">Ross<\/span><\/td>\n<td><span style=\"font-weight: 400\">40000<\/span><\/td>\n<td><span style=\"font-weight: 400\">Technical writer<\/span><\/td>\n<td><span style=\"font-weight: 400\"> TP <\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">1204<\/span><\/td>\n<td><span style=\"font-weight: 400\">Joey<\/span><\/td>\n<td><span style=\"font-weight: 400\">40000<\/span><\/td>\n<td><span style=\"font-weight: 400\">Hr Admin<\/span><\/td>\n<td><span style=\"font-weight: 400\">HR<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">1205<\/span><\/td>\n<td><span style=\"font-weight: 400\">Monika<\/span><\/td>\n<td><span style=\"font-weight: 400\">35000<\/span><\/td>\n<td><span style=\"font-weight: 400\">Op Admin<\/span><\/td>\n<td><span style=\"font-weight: 400\">Admin<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Hence, using the above scenario here is the following query retrieves the employee details:<br \/>\n<b>hive&gt; CREATE VIEW emp_35000 AS<\/b><br \/>\n<b>SELECT * FROM employee<\/b><br \/>\n<b>WHERE salary&gt;35000<\/b><\/p>\n<h4><span style=\"font-weight: 400\">iv. Dropping a Hive View<\/span><\/h4>\n<p><span style=\"font-weight: 400\">However, to drop a Hive view, use the following syntax:<\/span><br \/>\n<b>DROP VIEW view_name<\/b><br \/>\n<b>The following query drops a view named as emp_35000:<\/b><br \/>\n<b>hive&gt; DROP VIEW emp_35000;<\/b><\/p>\n<h3><span style=\"font-weight: 400\">b. What is Apache Hive Index?<\/span><\/h3>\n<p><span style=\"font-weight: 400\">On defining indexing in Hive we can say these are pointers to particular column name of a table.<\/span><\/p>\n<div id=\"attachment_10151\" style=\"width: 1090px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Hive-Multi-level-Index.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-10151\" class=\"wp-image-10151 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Hive-Multi-level-Index.png\" alt=\"Hive View and Indexes\" width=\"1080\" height=\"1080\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Hive-Multi-level-Index.png 1080w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Hive-Multi-level-Index-150x150.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Hive-Multi-level-Index-300x300.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Hive-Multi-level-Index-768x768.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Hive-Multi-level-Index-1024x1024.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Hive-Multi-level-Index-100x100.png 100w\" sizes=\"auto, (max-width: 1080px) 100vw, 1080px\" \/><\/a><p id=\"caption-attachment-10151\" class=\"wp-caption-text\">Introduction &#8211; Apache Hive Index<\/p><\/div>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">However, the user has to manually define the Hive index<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Basically, we are creating the pointer to particular column name of the table, wherever we are creating Hive index. <\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">By using the Hive index value created on the column name, any Changes made to the column present in tables are stored.<\/span><\/li>\n<\/ul>\n<h4><span style=\"font-weight: 400\">i. Apache Hive index Syntax<\/span><\/h4>\n<p><b>Create INDEX &lt; INDEX_NAME&gt; ON TABLE &lt; TABLE_NAME(column names)&gt;<\/b><\/p>\n<h4><span style=\"font-weight: 400\">ii. Create an Indexing in Hive<\/span><\/h4>\n<p><span style=\"font-weight: 400\">However, creating a Apache Hive index means creating a pointer on a particular column of a table. So, to create an indexing in hive.<\/span><br \/>\n<span style=\"font-weight: 400\">Apache Hive Index Syntax is:<\/span><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">CREATE INDEX index_name\nON TABLE base_table_name (col_name, ...)\nAS 'index.handler.class.name'\n[WITH DEFERRED REBUILD]\n[IDXPROPERTIES (property_name=property_value, ...)]\n[IN TABLE index_table_name]\n[PARTITIONED BY (col_name, ...)]\n[\n  [ ROW FORMAT ...] STORED AS ...\n  | STORED BY ...\n]\n[LOCATION hdfs_path]\n[TBLPROPERTIES (...)]<\/pre>\n<h4><span style=\"font-weight: 400\">iii. Apache Hive Index Example<\/span><\/h4>\n<p><span style=\"font-weight: 400\">Let\u2019s suppose the same employee table which we had used earlier with the fields Id, Name, Salary, Designation, and Dept. So, here create an index named index_salary on the salary column of the employee table.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Hence, we use the following query to create a Hive index:<\/span><br \/>\n<b><\/b><\/p>\n<p><b>hive&gt; CREATE INDEX inedx_salary ON TABLE employee(salary)<\/b><br \/>\n<b>AS &#8216;org.apache.hadoop.hive.ql.index.compact.CompactIndexHandler&#8217;;<\/b><\/p>\n<p><span style=\"font-weight: 400\">However, it is a pointer to the salary column. Basically, the changes are stored using an index value, if the column is modified.<\/span><\/p>\n<h4><span style=\"font-weight: 400\">iv. Dropping an Index<\/span><\/h4>\n<p><span style=\"font-weight: 400\">Also, drop indexing in Hive we use the following syntax of Apache Hive Index:<\/span><br \/>\n<b>DROP INDEX &lt;index_name&gt; ON &lt;table_name&gt;<\/b><br \/>\n<span style=\"font-weight: 400\">Here, is the following query drops a Hive index named index_salary:<\/span><br \/>\n<b>hive&gt; DROP INDEX index_salary ON employee;<\/b><\/p>\n<h4><span style=\"font-weight: 400\">v. When to use Hive Indexing?<\/span><\/h4>\n<p><span style=\"font-weight: 400\">Under the following circumstances, we can use Indexing in Hive:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">While the dataset is very large.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Whenever the query execution is more amount of time than you expected.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">While we need a speedy query execution.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">While we build a data model.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">Hive Index is maintained in a separate table. Hence, it won\u2019t affect the data inside the table, which contains the data. There is one more advantage of it. That is for indexing in Hive is that index can also be partitioned depending on the size of the data we have.<\/span><\/p>\n<h4><span style=\"font-weight: 400\">vi. Types of Hive Index\u00a0<\/span><\/h4>\n<p>These two are Apache Hive Index types:<\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Compact Indexing in Hive<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Bitmap Indexing in Hive<\/span><\/li>\n<\/ul>\n<p>So, this was all about Apache Hive Index Tutorial. Hope you like our explanation of Indexing in Hive.<\/p>\n<h2><span style=\"font-weight: 400\">Conclusion<\/span><\/h2>\n<p><span style=\"font-weight: 400\">Hence, in this apache hive index, we studied what is Hive View and Hive Index. <\/span><\/p>\n<p><span style=\"font-weight: 400\">We have learned the whole concept of Apache Hive view with Syntax, how to create apache hive views with example, dropping a Hive view, Hive Index with Syntax, How to create Hive Index with Example, Dropping an Indexing in the hive, When to use Indexing in the hive, and types of Hive Index.<\/span><\/p>\n<p><span style=\"font-weight: 400\"> Well also including these features correctly in your Hive implementation will simplify and provide your users with a better experience and Knowing well. Still, if any doubt occurs feel free to ask in the comment section.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In our last article, we see Hive Built-in Functions. In this Hive index Tutorial, we will learn the whole concept of Hive Views and Indexing in Hive. Also, we will cover how to create&#46;&#46;&#46;<\/p>\n","protected":false},"author":7,"featured_media":13301,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[26],"tags":[815,3112,4080,4081,5720,5721,5800,5802,5803,6068,6069,6684,14044,14045,15057,16083],"class_list":["post-10147","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-hive","tag-apache-hive-view","tag-creating-a-hive-view","tag-dropping-a-hive-index","tag-dropping-a-hive-view","tag-hive-index","tag-hive-index-example","tag-hive-view","tag-hive-view-example","tag-hive-view-syntax","tag-how-to-create-hive-index","tag-how-to-create-hive-view","tag-indexing-in-hive","tag-syntax-of-hive-index","tag-syntax-of-hive-view","tag-types-of-hive-index","tag-when-to-use-hive-index"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Apache Hive View and Hive Index - DataFlair<\/title>\n<meta name=\"description\" content=\"Hive view,Hive index,how to create hive views and make indexing in hive,hive view syntax,hive indexes syntax,hive view &amp; index with example,hive index types\" \/>\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-view-hive-index\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Apache Hive View and Hive Index - DataFlair\" \/>\n<meta property=\"og:description\" content=\"Hive view,Hive index,how to create hive views and make indexing in hive,hive view syntax,hive indexes syntax,hive view &amp; index with example,hive index types\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/hive-view-hive-index\/\" \/>\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=\"2018-03-07T12:13:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/04\/Hive-view-INDEX-01-1.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=\"5 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Apache Hive View and Hive Index - DataFlair","description":"Hive view,Hive index,how to create hive views and make indexing in hive,hive view syntax,hive indexes syntax,hive view & index with example,hive index types","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-view-hive-index\/","og_locale":"en_US","og_type":"article","og_title":"Apache Hive View and Hive Index - DataFlair","og_description":"Hive view,Hive index,how to create hive views and make indexing in hive,hive view syntax,hive indexes syntax,hive view & index with example,hive index types","og_url":"https:\/\/data-flair.training\/blogs\/hive-view-hive-index\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-03-07T12:13:36+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/04\/Hive-view-INDEX-01-1.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":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/hive-view-hive-index\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/hive-view-hive-index\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/beb0cab24b7aa54423a3b50e669a9dcd"},"headline":"Apache Hive View and Hive Index","datePublished":"2018-03-07T12:13:36+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/hive-view-hive-index\/"},"wordCount":994,"commentCount":7,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/hive-view-hive-index\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/04\/Hive-view-INDEX-01-1.jpg","keywords":["Apache Hive View","Creating a Hive View","Dropping a Hive Index","Dropping a hive view","Hive Index","Hive Index Example","Hive View","hive view Example","Hive View Syntax","How to create Hive Index","How to create hive view","Indexing in Hive","Syntax of Hive Index","Syntax of hive view","Types of Hive Index","When to use Hive Index"],"articleSection":["Hive Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/hive-view-hive-index\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/hive-view-hive-index\/","url":"https:\/\/data-flair.training\/blogs\/hive-view-hive-index\/","name":"Apache Hive View and Hive Index - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/hive-view-hive-index\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/hive-view-hive-index\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/04\/Hive-view-INDEX-01-1.jpg","datePublished":"2018-03-07T12:13:36+00:00","description":"Hive view,Hive index,how to create hive views and make indexing in hive,hive view syntax,hive indexes syntax,hive view & index with example,hive index types","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/hive-view-hive-index\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/hive-view-hive-index\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/hive-view-hive-index\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/04\/Hive-view-INDEX-01-1.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/04\/Hive-view-INDEX-01-1.jpg","width":1200,"height":628,"caption":"Apache Hive View and Hive Index"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/hive-view-hive-index\/#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":"Apache Hive View and Hive Index"}]},{"@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\/10147","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=10147"}],"version-history":[{"count":0,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/10147\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/13301"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=10147"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=10147"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=10147"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}