{"id":12352,"date":"2018-03-31T05:05:16","date_gmt":"2018-03-31T05:05:16","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=12352"},"modified":"2021-05-09T13:11:12","modified_gmt":"2021-05-09T07:41:12","slug":"impala-alter-table-statement","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/impala-alter-table-statement\/","title":{"rendered":"Impala Alter Table Statement – HDFS Caching and Permissions"},"content":{"rendered":"

Basically, to change the structure or properties of an existing Impala<\/strong> table we use Impala Alter Table Statement. There are much more to know about Impala Alter Table Statement<\/strong>. Like Altering the name of a table,<\/span><\/p>\n

Adding columns to a table, Dropping columns from a table, Changing the name and type of a column or Altering a Table using Hue. So, in this article on Impala Alter Table Statement, we will discuss all of them. Also, we will include syntax and example to understand it well.<\/span><\/p>\n

Introduction to Impala Alter Table Statement?<\/span><\/h2>\n

While we need to change the structure or properties of an existing Impala table, we use Impala Alter Table Statement.<\/span>
\n<\/span>
\n<\/span>Basically, there is a primarily a logical operation that updates the table metadata in the Metastore database that Impala shares with \u00a0Hive,<\/strong> in Impala.<\/span> However, we can say most ALTER TABLE operations do not actually rewrite, move, and so on the actual data files.<\/p>\n

Although, the one exception is The RENAME TO clause it can cause HDFS<\/strong> files to be moved to different paths.<\/p>\n

Also, we typically need to perform corresponding physical filesystem operations, whenever we do an ALTER TABLE operation. Like rewriting the data files to include extra fields, or converting them to a different file format.<\/span><\/p>\n

To be very specific, to perform changes on a given table, we use Impala Alter table statement. In addition, we can add, delete, or modify columns in an existing table and we can also rename it, using this statement.<\/span><\/p>\n

Syntax of Impala Alter Table Statements<\/span><\/h2>\n

So, the syntax for using Impala Alter Table Statement is-<\/span>
\n<\/span><\/p>\n

ALTER TABLE [old_db_name.]old_table_name RENAME TO [new_db_name.]new_table_name\nALTER TABLE name ADD COLUMNS (col_spec[, col_spec ...])\nALTER TABLE name DROP [COLUMN] column_name\nALTER TABLE name CHANGE column_name new_name new_type\nALTER TABLE name REPLACE COLUMNS (col_spec[, col_spec ...])\nALTER TABLE name { ADD [IF NOT EXISTS] | DROP [IF EXISTS] } PARTITION (partition_spec) [PURGE]\nALTER TABLE name RECOVER PARTITIONS\nALTER TABLE name [PARTITION (partition_spec)]\n SET { FILEFORMAT file_format\n | LOCATION 'hdfs_path_of_directory'\n | TBLPROPERTIES (table_properties)\n | SERDEPROPERTIES (serde_properties) }\nALTER TABLE name colname\n ('statsKey'='val, ...)\nstatsKey ::= numDVs | numNulls | avgSize | maxSize\nALTER TABLE name [PARTITION (partition_spec)] SET { CACHED IN 'pool_name' [WITH REPLICATION = integer] | UNCACHED }\nnew_name ::= [new_database.]new_table_name\ncol_spec ::= col_name type_name\npartition_spec ::= partition_col=constant_value\ntable_properties ::= 'name'='value'[, 'name'='value' ...]\nserde_properties ::= 'name'='value'[, 'name'='value' ...]\nfile_format ::= { PARQUET | TEXTFILE | RCFILE | SEQUENCEFILE | AVRO }\n<\/pre>\n
Statement type<\/span><\/h2>\n
Impala Alter Table Statement is of DDL Type.<\/span><\/p>\n
Usage of Impala Alter Table Statements<\/span><\/h2>\n
 Let me now talk about the usage of Impala Alter Table Statement. <\/span>Make sure to include all the partitioning columns in the specification, while we specify partitions in an ALTER TABLE statement, through the PARTITION (partition_spec) clause.<\/span>
\n<\/span>
\nFor both internal as well as External tables, most of the ALTER TABLE operations work the same.<\/span> However, there is an exception, \u00a0the underlying data directory is not renamed or moved to an external table.<\/p>\n
Examples – Impala Alter table Statement<\/span><\/h2>\n
Let\u2019s suppose we have a table named Employees in Impala. Here, \u00a0is the data \u2212<\/span>
\n<\/span><\/p>\n\n\n\n\n\n\n\n\n\n
id<\/span><\/td>\nname<\/span><\/td>\nage<\/span><\/td>\naddress<\/span><\/td>\nsalary<\/span><\/td>\n<\/tr>\n
1<\/span><\/td>\nshubham<\/span><\/td>\n32<\/span><\/td>\ndelhi<\/span><\/td>\n20000<\/span><\/td>\n<\/tr>\n
2<\/span><\/td>\nmonika<\/span><\/td>\n25<\/span><\/td>\nmumbai<\/span><\/td>\n15000<\/span><\/td>\n<\/tr>\n
3<\/span><\/td>\nkajal<\/span><\/td>\n27<\/span><\/td>\nalirajpur<\/span><\/td>\n40000<\/span><\/td>\n<\/tr>\n
4<\/span><\/td>\nrevti<\/span><\/td>\n25<\/span><\/td>\nindore<\/span><\/td>\n35000<\/span><\/td>\n<\/tr>\n
5<\/span><\/td>\nshreyash<\/span><\/td>\n23<\/span><\/td>\npune<\/span><\/td>\n30000<\/span><\/td>\n<\/tr>\n
6<\/span><\/td>\nmehul<\/span><\/td>\n22<\/span><\/td>\nhyderabad<\/span><\/td>\n32000<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
Now, see the list of tables in the database my_db, where we \u00a0can find the Employees table
\n<\/span><\/p>\n
[quickstart.cloudera:21000] > show tables;\n<\/pre>\n
Query: show tables <\/span><\/p>\n\n\n\n\n\n\n\n
name<\/span><\/td>\n<\/tr>\n
Employees<\/span><\/td>\n<\/tr>\n
Employees 1<\/span><\/td>\n<\/tr>\n
Employees 2<\/span><\/td>\n<\/tr>\n
Employees 3<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
i. Altering the name of a table<\/span><\/p>\n
    \n
  • \n
    Syntax<\/span><\/h4>\n<\/li>\n<\/ul>\n
    ALTER TABLE [old_db_name.]old_table_name RENAME TO [new_db_name.]new_table_name<\/pre>\n
      \n
    • \n
      Example<\/span><\/h4>\n<\/li>\n<\/ul>\n
      For Example,
      \nSo, we are changing the name of the table Employees to Students.<\/span>
      \n<\/span><\/p>\n
      [quickstart.cloudera:21000] > ALTER TABLE my_db.Employees RENAME TO my_db.Students;<\/pre>\n
      Displaying the following message, \u00a0Impala changes the name of the table as required just after executing the above query.<\/span>
      \n<\/span><\/p>\n
      Query: alter TABLE my_db.Employees RENAME TO my_db.Students<\/pre>\n
      Now, you will see the table named Students instead of Employees.<\/span>
      \n<\/span>Query: show tables <\/span><\/p>\n\n\n\n\n\n\n\n
      name<\/span><\/td>\n<\/tr>\n
      Students<\/span><\/td>\n<\/tr>\n
      Employees 1<\/span><\/td>\n<\/tr>\n
      Employees 2<\/span><\/td>\n<\/tr>\n
      Employees 3<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
      Fetched 4 row(s) in 0.10s<\/span><\/p>\n
      ii. Adding columns to a table<\/span><\/h3>\n
        \n
      • \n
        Syntax<\/span><\/h4>\n<\/li>\n<\/ul>\n
        ALTER TABLE name ADD COLUMNS (col_spec[, col_spec ...])<\/pre>\n
        Example<\/span>
        \nFor Example,
        \nSo, \u00a0we are adding two columns account_no and phone_number (both are of bigint data type) to the Students table.<\/span>
        \n<\/span><\/p>\n
        [quickstart.cloudera:21000] > ALTER TABLE Students ADD COLUMNS (account_no BIGINT,\nphone_no BIGINT);<\/pre>\n
        Now, it will add the specified columns to the table named student, On executing the above query.<\/span><\/p>\n
        Query: alter TABLE Students ADD COLUMNS (account_no BIGINT, phone_no BIGINT)<\/pre>\n
        We can find the newly added columns since we verify the schema of the table Students in it as shown below.<\/span>
        \n<\/span><\/p>\n
        quickstart.cloudera:21000] > describe Students;\nQuery: describe Students<\/pre>\n\n\n\n\n\n\n\n\n\n\n
        name<\/span><\/td>\ntype<\/span><\/td>\ncomment<\/span><\/td>\n<\/tr>\n
        id<\/span><\/td>\nint<\/span><\/td>\n<\/td>\n<\/tr>\n
        name<\/span><\/td>\nstring<\/span><\/td>\n<\/td>\n<\/tr>\n
        age<\/span><\/td>\nint<\/span><\/td>\n<\/td>\n<\/tr>\n
        address<\/span><\/td>\nstring<\/span><\/td>\n<\/td>\n<\/tr>\n
        salary<\/span><\/td>\nbigint<\/span><\/td>\n<\/td>\n<\/tr>\n
        account_no<\/span><\/td>\nbigint<\/span><\/td>\n<\/td>\n<\/tr>\n
        phone_no<\/span><\/td>\nbigint<\/span><\/td>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
        Fetched 7 row(s) in 0.20s<\/span><\/p>\n
        iii. Dropping columns from a table<\/span><\/h3>\n
          \n
        • \n
          Syntax<\/span><\/h4>\n<\/li>\n<\/ul>\n
          ALTER TABLE name DROP [COLUMN] column_name<\/pre>\n
            \n
          • \n
            Example<\/span><\/h4>\n<\/li>\n<\/ul>\n
            For Example,
            \nSo, we are deleting the column named account_no.<\/span>
            \n<\/span>
            \n<\/span><\/p>\n
            [quickstart.cloudera:21000] > ALTER TABLE Students DROP account_no;\n<\/pre>\n
            On executing the above query, Impala deletes the column named account_no, <\/span><\/p>\n
            Query: alter TABLE Students DROP account_no<\/pre>\n
            However, we cannot find the column named account_no since it was deleted since you verify the schema of the table Students.<\/span>
            \n<\/span><\/p>\n
            [quickstart.cloudera:21000] > describe Students;\nQuery: describe Students<\/pre>\n\n\n\n\n\n\n\n\n\n
            name<\/span><\/td>\ntype<\/span><\/td>\ncomment<\/span><\/td>\n<\/tr>\n
            id<\/span><\/td>\nint<\/span><\/td>\n<\/td>\n<\/tr>\n
            name<\/span><\/td>\nstring<\/span><\/td>\n<\/td>\n<\/tr>\n
            age<\/span><\/td>\nint<\/span><\/td>\n<\/td>\n<\/tr>\n
            address<\/span><\/td>\nstring<\/span><\/td>\n<\/td>\n<\/tr>\n
            salary<\/span><\/td>\nbigint<\/span><\/td>\n<\/td>\n<\/tr>\n
            phone_no<\/span><\/td>\nbigint<\/span><\/td>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
            Fetched 6 row(s) in 0.11s<\/span>
            \nAny doubt yet in Impala Alter Statement? Please Comment.<\/p>\n
            Iv. Changing the name and type of a column<\/span><\/h3>\n
              \n
            • \n
              Syntax<\/span><\/h4>\n<\/li>\n<\/ul>\n
              syntax is- ALTER TABLE name CHANGE column_name new_name new_type<\/pre>\n
                \n
              • \n
                Example<\/span><\/h4>\n<\/li>\n<\/ul>\n
                For Example,
                \nSo, \u00a0we are changing the name of the column phone_no to email and it’s data type to string.<\/span>
                \n<\/span>
                \n<\/span><\/p>\n
                [quickstart.cloudera:21000] > ALTER TABLE Students CHANGE phone_no e_mail string;<\/pre>\n
                On executing the above query, Impala does the specified changes.<\/span>
                \n<\/span>
                \n<\/span><\/p>\n
                Query: alter TABLE Students CHANGE phone_no e_mail string<\/pre>\n
                By using the describe statement, we can verify the metadata of the table Students. Further, see the required changes to the specified column has done.<\/span>
                \n<\/span>
                \n<\/span><\/p>\n
                [quickstart.cloudera:21000] > describe Students;\nQuery: describe Students<\/pre>\n\n\n\n\n\n\n\n\n\n
                name<\/span><\/td>\ntype<\/span><\/td>\ncomment<\/span><\/td>\n<\/tr>\n
                id<\/span><\/td>\nint<\/span><\/td>\n<\/td>\n<\/tr>\n
                name<\/span><\/td>\nstring<\/span><\/td>\n<\/td>\n<\/tr>\n
                age<\/span><\/td>\nint<\/span><\/td>\n<\/td>\n<\/tr>\n
                address<\/span><\/td>\nstring<\/span><\/td>\n<\/td>\n<\/tr>\n
                salary<\/span><\/td>\nbigint<\/span><\/td>\n<\/td>\n<\/tr>\n
                e_mail<\/span><\/td>\nstring<\/span><\/td>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
                Fetched 6 row(s) in 0.11s<\/span><\/p>\n
                V. Altering a Table using Hue<\/span><\/h3>\n
                There are several steps you have to follow while using Hue. Such as:<\/span><\/p>\n
                  \n
                • At first, type the alter statement in Impala Query editor. Then click on the execute button.<\/span><\/li>\n
                • Now, it will change the name of the table Employees to Students, on executing the above query. Hence, we can execute all the alter queries, in the same way.<\/span><\/li>\n<\/ul>\n
                  Complex Type Considerations<\/span><\/h2>\n
                  The ALTER TABLE statement can change the metadata for tables containing complex types, in CDH 5.5 \/ Impala 2.3 and higher. Such as\u00a0 ARRAY, STRUCT, and MAP.\u00a0Basically, to modify the table layout for complex type columns we can use an ADD COLUMNS, DROP COLUMN, or CHANGE clause. <\/span><\/p>\n
                  Amazon S3 considerations<\/span><\/h2>\n
                  To make Impala query data from the Amazon S3 filesystem, we can specify an s3a:\/\/ prefix on the LOCATION attribute of a table or partition. <\/span><\/p>\n
                  However, whenever we issue ALTER TABLE statements with the ADD PARTITION or DROP PARTITION clauses, \u00a0Impala automatically handles creating or removing the associated folders, in CDH 5.8 \/ Impala 2.6 and higher.<\/span><\/p>\n
                  In addition, Impala DDL statements can create or remove folders as needed in the Amazon S3 system in CDH 5.8 \/ Impala 2.6 and higher.<\/span> Such as CREATE DATABASE, CREATE TABLE, DROP DATABASE CASCADE, DROP TABLE, and ALTER TABLE [ADD|DROP] PARTITION.<\/p>\n
                  Although, we had to create folders yourself and point Impala database, tables, or partitions at them, and manually remove folders when no longer needed before CDH 5.8 \/ Impala 2.6.
                  \n<\/span><\/p>\n
                  HDFS caching (CACHED IN clause)<\/span><\/h2>\n
                  However, any existing or future data files in the table directory or the partition subdirectories are designated to be loaded into memory with the HDFS caching mechanism, since we specify the CACHED IN clause.<\/span><\/p>\n
                  There is an optional WITH REPLICATION clause for CREATE TABLE and ALTER TABLE, \u00a0in Impala 2.2 \/ CDH 5.4 and higher. Basically, it lets you specify a replication factor, the number of hosts on which to cache the same data blocks. <\/span><\/p>\n
                  Moreover, Impala randomly selects a host that has a cached copy of that data block, when Impala processes a cached data block, also where the cache replication factor is greater than 1. <\/span><\/p>\n
                  Basically, we can enable the SYNC_DDL query option to make each DDL statement wait before returning If you connect to different Impala nodes within an impala-shell session for load-balancing purposes until the new or changed metadata has been received by all the Impala nodes.<\/span><\/p>\n
                  HDFS permissions<\/span><\/h2>\n
                  However, Many of the ALTER TABLE clauses do not actually read or write any HDFS files. Hence, they do not depend on specific HDFS permissions. <\/span><\/p>\n
                  Cancellation<\/span><\/h2>\n
                  It is not possible to cancel it. That implies it Cannot be canceled.<\/span>
                  \nThis was all in the Impala Alter Table Statement.<\/p>\n
                  Conclusion – Impala Alter Table Statement<\/span><\/h2>\n
                  As a result, we have seen the whole concept of Impala Alter Table Statement. Still, if any doubt occurs in how to create impala database, feel free to ask in the comment section.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"
                  Basically, to change the structure or properties of an existing Impala table we use Impala Alter Table Statement. There are much more to know about Impala Alter Table Statement. Like Altering the name of...<\/p>\n","protected":false},"author":6,"featured_media":35065,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[27],"tags":[441,16646,2799,16648,16647,6478],"class_list":["post-12352","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-impala","tag-alter-table-statement","tag-alter-table-statement-in-impala","tag-complex-type-considerations","tag-hdfs-caching","tag-how-to-use-impala-alter-table-statement","tag-impala-alter-table-statement"],"yoast_head":"\nImpala Alter Table Statement - HDFS Caching and Permissions - DataFlair<\/title>\n<meta name=\"description\" content=\"In this article, we will discuss the whole concept of Impala Alter Table Statement, with its syntax and example to understand it well.\" \/>\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-alter-table-statement\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Impala Alter Table Statement - HDFS Caching and Permissions - DataFlair\" \/>\n<meta property=\"og:description\" content=\"In this article, we will discuss the whole concept of Impala Alter Table Statement, with its syntax and example to understand it well.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/impala-alter-table-statement\/\" \/>\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-31T05:05:16+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-05-09T07:41:12+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Impala-Alter-Table-Statement-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=\"7 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Impala Alter Table Statement - HDFS Caching and Permissions - DataFlair","description":"In this article, we will discuss the whole concept of Impala Alter Table Statement, with its syntax and example to understand it well.","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-alter-table-statement\/","og_locale":"en_US","og_type":"article","og_title":"Impala Alter Table Statement - HDFS Caching and Permissions - DataFlair","og_description":"In this article, we will discuss the whole concept of Impala Alter Table Statement, with its syntax and example to understand it well.","og_url":"https:\/\/data-flair.training\/blogs\/impala-alter-table-statement\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-03-31T05:05:16+00:00","article_modified_time":"2021-05-09T07:41:12+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Impala-Alter-Table-Statement-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":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/impala-alter-table-statement\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/impala-alter-table-statement\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89"},"headline":"Impala Alter Table Statement – HDFS Caching and Permissions","datePublished":"2018-03-31T05:05:16+00:00","dateModified":"2021-05-09T07:41:12+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/impala-alter-table-statement\/"},"wordCount":1236,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/impala-alter-table-statement\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Impala-Alter-Table-Statement-01-1.jpg","keywords":["Alter Table Statement","Alter Table Statement in Impala","Complex type considerations","HDFS caching","How to use Impala Alter Table Statement","Impala Alter Table Statement"],"articleSection":["Impala Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/impala-alter-table-statement\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/impala-alter-table-statement\/","url":"https:\/\/data-flair.training\/blogs\/impala-alter-table-statement\/","name":"Impala Alter Table Statement - HDFS Caching and Permissions - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/impala-alter-table-statement\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/impala-alter-table-statement\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Impala-Alter-Table-Statement-01-1.jpg","datePublished":"2018-03-31T05:05:16+00:00","dateModified":"2021-05-09T07:41:12+00:00","description":"In this article, we will discuss the whole concept of Impala Alter Table Statement, with its syntax and example to understand it well.","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/impala-alter-table-statement\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/impala-alter-table-statement\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/impala-alter-table-statement\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Impala-Alter-Table-Statement-01-1.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Impala-Alter-Table-Statement-01-1.jpg","width":1200,"height":628,"caption":"Impala Alter Table Statement - HDFS Caching and Permissions"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/impala-alter-table-statement\/#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 Alter Table Statement – HDFS Caching and Permissions"}]},{"@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\/12352","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=12352"}],"version-history":[{"count":1,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/12352\/revisions"}],"predecessor-version":[{"id":94050,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/12352\/revisions\/94050"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/35065"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=12352"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=12352"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=12352"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}