{"id":12528,"date":"2018-04-10T06:09:18","date_gmt":"2018-04-10T06:09:18","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=12528"},"modified":"2021-05-09T13:11:00","modified_gmt":"2021-05-09T07:41:00","slug":"impala-with-clause","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/impala-with-clause\/","title":{"rendered":"Impala WITH Clause &#8211; A Quick Tour"},"content":{"rendered":"<p><span style=\"font-weight: 400\">There are times when a query is way too complex. At that time using <strong>Impala<\/strong> WITH Clause, we can define aliases to complex parts and include them in the query. Although, there is much more to learn about using Impala WITH Clause. <\/span><\/p>\n<p><span style=\"font-weight: 400\">So, in this article, we will discuss the whole concept of \u00a0Impala WITH Clause. Apart from its introduction, it includes its syntax, type as well as its example, to understand it well.<\/span><\/p>\n<h2><span style=\"font-weight: 400\">Impala WITH Clause<\/span><\/h2>\n<p><span style=\"font-weight: 400\">Basically, to define aliases for complicated expressions that are referenced multiple times within the body of the SELECT, it is a clause that can be added before a SELECT statement. <\/span><\/p>\n<p><span style=\"font-weight: 400\">Although, it is quite same as CREATE VIEW, with the only difference that the table and column names defined in the WITH clause do not persist after the query finishes. Also, it does not conflict with names used in actual tables or views. We also call it &#8220;subquery factoring&#8221;.<\/span><strong><a href=\"https:\/\/data-flair.training\/blogs\/impala-union-clause\/\"><br \/>\n<\/a><\/strong><span style=\"font-weight: 400\"><br \/>\n<\/span><span style=\"font-weight: 400\">Moreover, by using subqueries, we can rewrite a query to work the same as with the WITH clause. <\/span><br \/>\n<span style=\"font-weight: 400\">There are several purposes offered by WITH clause. They are:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">It provides ease of maintenance and convenience from less repetition with the body of the query. Also, we can use it along Various queries, \u00a0where the similar complicated expressions are referenced multiple times. Such as UNION, joins, or aggregation functions.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Also, abstracts the most complex part of the query into a separate block of SQL code to make it easier to read and understand.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Moreover, it enhances compatibility with SQL from other database systems that support the same clause. Like primarily Oracle Database.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">However, it is very important to note that this clause does not support recursive queries in the WITH. Even if those are supported in some other database systems.<\/span><\/p>\n<h3><span style=\"font-weight: 400\">a. Syntax<\/span><\/h3>\n<p><span style=\"font-weight: 400\">So, the syntax for Impala WITH Clause is-<\/span><span style=\"font-weight: 400\">\u00a0\u00a0<\/span><\/p>\n<pre class=\"EnlighterJSRAW\">with x as (select 1), y as (select 2) (select * from x union y);<\/pre>\n<h3><span style=\"font-weight: 400\">b. Standards Compliance<\/span><\/h3>\n<p><span style=\"font-weight: 400\">Basically, it was Introduced in SQL:1999.<\/span><\/p>\n<h2><span style=\"font-weight: 400\">Examples of Impala WITH Clause<\/span><\/h2>\n<p><span style=\"font-weight: 400\">Let\u2019s understand Impala WITH Clause with several Examples;<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Example1<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">&#8212; Define 2 subqueries that can be referenced from the body of a longer query.<\/span><span style=\"font-weight: 400\"><br \/>\n<\/span><\/p>\n<pre class=\"EnlighterJSRAW\">with t1 as (select 1), t2 as (select 2) insert into tab select * from t1 union all select * from t2;\n<\/pre>\n<p><span style=\"font-weight: 400\">&#8212; Define one subquery at the outer level, and another at the inner level as part of the<\/span><span style=\"font-weight: 400\"><br \/>\n<\/span><span style=\"font-weight: 400\">&#8212; initial stage of the UNION ALL query.<\/span><span style=\"font-weight: 400\"><br \/>\n<\/span><\/p>\n<pre class=\"EnlighterJSRAW\">with t1 as (select 1) (with t2 as (select 2) select * from t2) union all select * from t1;<\/pre>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Example2 \u00a0\u00a0\u00a0\u00a0<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">For Example,<\/span><span style=\"font-weight: 400\"><br \/>\n<\/span><span style=\"font-weight: 400\"><br \/>\n<\/span><span style=\"font-weight: 400\">Let us suppose we have a table named <\/span><b>Students<\/b><span style=\"font-weight: 400\"> in the database my_db. Its contents are \u2212<\/span><span style=\"font-weight: 400\"><br \/>\n<\/span><span style=\"font-weight: 400\"><br \/>\n<\/span><b>[quickstart.cloudera:21000] &gt; select * from Students;<\/b><b><br \/>\n<\/b><b>Query: select * from Students <\/b><\/p>\n<table>\n<tbody>\n<tr>\n<td><b>id<\/b><\/td>\n<td><b>name<\/b><\/td>\n<td><b>age<\/b><\/td>\n<td><b>address<\/b><\/td>\n<td><b>salary<\/b><\/td>\n<\/tr>\n<tr>\n<td><b>1<\/b><\/td>\n<td><b>shubham<\/b><\/td>\n<td><b>32<\/b><\/td>\n<td><b>delhi<\/b><\/td>\n<td><b>20000<\/b><\/td>\n<\/tr>\n<tr>\n<td><b>9<\/b><\/td>\n<td><b>Pulkit<\/b><\/td>\n<td><b>23<\/b><\/td>\n<td><b>Gandhi nagar<\/b><\/td>\n<td><b>28000<\/b><\/td>\n<\/tr>\n<tr>\n<td><b>2<\/b><\/td>\n<td><b>monika<\/b><\/td>\n<td><b>25<\/b><\/td>\n<td><b>mumbai<\/b><\/td>\n<td><b>15000<\/b><\/td>\n<\/tr>\n<tr>\n<td><b>4<\/b><\/td>\n<td><b>revti<\/b><\/td>\n<td><b>25<\/b><\/td>\n<td><b>indore<\/b><\/td>\n<td><b>35000<\/b><\/td>\n<\/tr>\n<tr>\n<td><b>7<\/b><\/td>\n<td><b>Vaishnavi<\/b><\/td>\n<td><b>25<\/b><\/td>\n<td><b>Goa<\/b><\/td>\n<td><b>23000<\/b><\/td>\n<\/tr>\n<tr>\n<td><b>6<\/b><\/td>\n<td><b>mehul<\/b><\/td>\n<td><b>22<\/b><\/td>\n<td><b>hyderabad<\/b><\/td>\n<td><b>32000<\/b><\/td>\n<\/tr>\n<tr>\n<td><b>8<\/b><\/td>\n<td><b>Rishabh<\/b><\/td>\n<td><b>22<\/b><\/td>\n<td><b>chennai<\/b><\/td>\n<td><b>31000<\/b><\/td>\n<\/tr>\n<tr>\n<td><b>5<\/b><\/td>\n<td><b>shreyash<\/b><\/td>\n<td><b>23<\/b><\/td>\n<td><b>pune<\/b><\/td>\n<td><b>30000<\/b><\/td>\n<\/tr>\n<tr>\n<td><b>3<\/b><\/td>\n<td><b>kajal<\/b><\/td>\n<td><b>27<\/b><\/td>\n<td><b>alirajpur<\/b><\/td>\n<td><b>40000<\/b><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><b>Fetched 9 row(s) in 0.59s<\/b><span style=\"font-weight: 400\"><br \/>\n<\/span><br \/>\n<span style=\"font-weight: 400\">Similarly, \u00a0assume we have another table named <\/span><b>Users<\/b><span style=\"font-weight: 400\">. Its contents are \u2212<\/span><span style=\"font-weight: 400\"><br \/>\n<\/span><span style=\"font-weight: 400\"><br \/>\n<\/span><b>[quickstart.cloudera:21000] &gt; select * from Users ; <\/b><b><br \/>\n<\/b><b>Query: select * from Users \u00a0<\/b><b><\/b><\/p>\n<table>\n<tbody>\n<tr>\n<td><b>id<\/b><\/td>\n<td><b>name<\/b><\/td>\n<td><b>age<\/b><\/td>\n<td><b>address<\/b><\/td>\n<td><b>salary<\/b><\/td>\n<\/tr>\n<tr>\n<td><b>3<\/b><\/td>\n<td><b>vishal<\/b><\/td>\n<td><b>54<\/b><\/td>\n<td><b>Banglore<\/b><\/td>\n<td><b>55000<\/b><\/td>\n<\/tr>\n<tr>\n<td><b>2<\/b><\/td>\n<td><b>Shubham<\/b><\/td>\n<td><b>44<\/b><\/td>\n<td><b>Banglore<\/b><\/td>\n<td><b>50000<\/b><\/td>\n<\/tr>\n<tr>\n<td><b>4<\/b><\/td>\n<td><b>Mansi<\/b><\/td>\n<td><b>64<\/b><\/td>\n<td><b>kolkata<\/b><\/td>\n<td><b>60000<\/b><\/td>\n<\/tr>\n<tr>\n<td><b>1<\/b><\/td>\n<td><b>Ankur<\/b><\/td>\n<td><b>34<\/b><\/td>\n<td><b>kolkata<\/b><\/td>\n<td><b>40000<\/b><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><b>Fetched 4 row(s) in 0.59s<\/b><br \/>\n<span style=\"font-weight: 400\">So, here is an example of the Impala WITH clause. Basically, \u00a0using the UNION clause, we are displaying the records from both <\/span><b>Users<\/b> and <b>Students<\/b><span style=\"font-weight: 400\"> whose age is greater than 25.<\/span><span style=\"font-weight: 400\"><br \/>\n<\/span><b><br \/>\n<\/b><b>[quickstart.cloudera:21000] &gt; <\/b><b><br \/>\n<\/b><b> \u00a0\u00a0with t1 as (select * from Students where age&gt;25), <\/b><b><br \/>\n<\/b><b> \u00a0\u00a0t2 as (select * from Users \u00a0where age&gt;25) <\/b><b><br \/>\n<\/b><b> \u00a0\u00a0(select * from t1 union select * from t2);<\/b><\/p>\n<p><span style=\"font-weight: 400\">Hence, we get the following output, on executing the above query.<br \/>\n<\/span><br \/>\n<b>Query: with t1 as (select * from Students where age&gt;25), t2 as (select * from Users \u00a0where age&gt;25) <\/b><b><br \/>\n<\/b><b> \u00a0\u00a0(select * from t1 union select * from t2)<\/b><\/p>\n<table>\n<tbody>\n<tr>\n<td><b>id<\/b><\/td>\n<td><b>name<\/b><\/td>\n<td><b>age<\/b><\/td>\n<td><b>address<\/b><\/td>\n<td><b>salary<\/b><\/td>\n<\/tr>\n<tr>\n<td><b>3<\/b><\/td>\n<td><b>vishal<\/b><\/td>\n<td><b>54<\/b><\/td>\n<td><b>Banglore<\/b><\/td>\n<td><b>55000<\/b><\/td>\n<\/tr>\n<tr>\n<td><b>1<\/b><\/td>\n<td><b>Ankur<\/b><\/td>\n<td><b>34<\/b><\/td>\n<td><b>kolkata<\/b><\/td>\n<td><b>40000<\/b><\/td>\n<\/tr>\n<tr>\n<td><b>2<\/b><\/td>\n<td><b>Shubham<\/b><\/td>\n<td><b>44<\/b><\/td>\n<td><b>Banglore<\/b><\/td>\n<td><b>50000<\/b><\/td>\n<\/tr>\n<tr>\n<td><b>5<\/b><\/td>\n<td><b>shreyash<\/b><\/td>\n<td><b>23<\/b><\/td>\n<td><b>pune<\/b><\/td>\n<td><b>30000<\/b><\/td>\n<\/tr>\n<tr>\n<td><b>4<\/b><\/td>\n<td><b>Mansi<\/b><\/td>\n<td><b>64<\/b><\/td>\n<td><b>kolkata<\/b><\/td>\n<td><b>60000<\/b><\/td>\n<\/tr>\n<tr>\n<td><b>1<\/b><\/td>\n<td><b>shubham<\/b><\/td>\n<td><b>32<\/b><\/td>\n<td><b>delhi<\/b><\/td>\n<td><b>20000<\/b><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><b>Fetched 6 row(s) in 1.73s<\/b><br \/>\nSo, this was all about Impala with Clause. Hope you like our explanation.<\/p>\n<h2><span style=\"font-weight: 400\">Conclusion<\/span><\/h2>\n<p><span style=\"font-weight: 400\">Hence, in this article, we have seen how to use Impala WITH Clause properly. However, if you want to ask any doubt, feel free to ask in the comment section.we will definitely respond.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>There are times when a query is way too complex. At that time using Impala WITH Clause, we can define aliases to complex parts and include them in the query. Although, there is much&#46;&#46;&#46;<\/p>\n","protected":false},"author":6,"featured_media":19146,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[27],"tags":[4239,6579,6580,6581,13738,14034],"class_list":["post-12528","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-impala","tag-example-for-impala-with-clause","tag-impala-with-clause","tag-impala-with-clause-example","tag-impala-with-clause-syntax","tag-standards-compliance","tag-syntax-for-impala-with-clause"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Impala WITH Clause - A Quick Tour - DataFlair<\/title>\n<meta name=\"description\" content=\"Impala WITH Clause- what is With clause in Impala, Example of Impala WITH Clause, WITH Clause in impala Syntax,Standards Compliance\" \/>\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\/impala-with-clause\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Impala WITH Clause - A Quick Tour - DataFlair\" \/>\n<meta property=\"og:description\" content=\"Impala WITH Clause- what is With clause in Impala, Example of Impala WITH Clause, WITH Clause in impala Syntax,Standards Compliance\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/impala-with-clause\/\" \/>\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-04-10T06:09:18+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-05-09T07:41:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/Impala-WITH-Clause-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=\"4 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Impala WITH Clause - A Quick Tour - DataFlair","description":"Impala WITH Clause- what is With clause in Impala, Example of Impala WITH Clause, WITH Clause in impala Syntax,Standards Compliance","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\/impala-with-clause\/","og_locale":"en_US","og_type":"article","og_title":"Impala WITH Clause - A Quick Tour - DataFlair","og_description":"Impala WITH Clause- what is With clause in Impala, Example of Impala WITH Clause, WITH Clause in impala Syntax,Standards Compliance","og_url":"https:\/\/data-flair.training\/blogs\/impala-with-clause\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-04-10T06:09:18+00:00","article_modified_time":"2021-05-09T07:41:00+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/Impala-WITH-Clause-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":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/impala-with-clause\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/impala-with-clause\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89"},"headline":"Impala WITH Clause &#8211; A Quick Tour","datePublished":"2018-04-10T06:09:18+00:00","dateModified":"2021-05-09T07:41:00+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/impala-with-clause\/"},"wordCount":637,"commentCount":3,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/impala-with-clause\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/Impala-WITH-Clause-01-1.jpg","keywords":["Example for Impala WITH Clause","Impala WITH Clause","Impala WITH Clause example","Impala WITH Clause Syntax","Standards Compliance","Syntax for Impala WITH Clause"],"articleSection":["Impala Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/impala-with-clause\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/impala-with-clause\/","url":"https:\/\/data-flair.training\/blogs\/impala-with-clause\/","name":"Impala WITH Clause - A Quick Tour - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/impala-with-clause\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/impala-with-clause\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/Impala-WITH-Clause-01-1.jpg","datePublished":"2018-04-10T06:09:18+00:00","dateModified":"2021-05-09T07:41:00+00:00","description":"Impala WITH Clause- what is With clause in Impala, Example of Impala WITH Clause, WITH Clause in impala Syntax,Standards Compliance","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/impala-with-clause\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/impala-with-clause\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/impala-with-clause\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/Impala-WITH-Clause-01-1.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/Impala-WITH-Clause-01-1.jpg","width":1200,"height":628,"caption":"Impala WITH Clause - A Quick Tour"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/impala-with-clause\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"Impala Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/impala\/"},{"@type":"ListItem","position":3,"name":"Impala WITH Clause &#8211; A Quick Tour"}]},{"@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\/2c58ecb4f73a39f0ef993f1ddfcd7b89","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"The DataFlair Team provides industry-driven content on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Our expert educators focus on delivering value-packed, easy-to-follow resources for tech enthusiasts and professionals.","url":"https:\/\/data-flair.training\/blogs\/author\/dfteam2\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/12528","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\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=12528"}],"version-history":[{"count":1,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/12528\/revisions"}],"predecessor-version":[{"id":94036,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/12528\/revisions\/94036"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/19146"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=12528"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=12528"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=12528"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}