Hive Alter table change Column Name

Question

I am trying to rename a columnName in Hive  Is there a way to rename column name in Hive    tableA  column1   c1  c2   to  tableA column1 column2 column3

User · Answer

Command works only if  use  -command has been first used to define the database where working in  Table column renaming syntax using DATABASE TABLE throws error and does not work  Version  HIVE 0 12   EXAMPLE   hive gt  ALTER TABLE databasename tablename CHANGE old column name new column name     MismatchedTokenException 49  90          at org antlr runtime BaseRecognizer recoverFromMismatchedToken BaseRecognizer java 617          at org antlr runtime BaseRecognizer match BaseRecognizer java 115          at org apache hadoop hive ql parse HiveParser alterStatementSuffixExchangePartition HiveParser java 11492               hive gt  use databasename   hive gt  ALTER TABLE tablename CHANGE old column name new column name   OK

User · Answer

In the comments  libjack mentioned a point which is really important  I would like to illustrate more into it  First  we can check what are the columns of our table by describe  lt table name gt   command   there is a double-column called  c1 and such columns are created by the hive itself when we moving data from one table to another  To address these columns we need to write it inside backticks   c1   Finally  the ALTER command will be  ALTER TABLE  lt table namr gt  CHANGE   lt system genarated column name gt    lt new column name gt   lt data type gt

User · Answer

alter table table name change old col name new col name new col type    Here is the example  hive gt  alter table test change userVisit userVisit2 STRING            OK     Time taken  0 26 seconds     hive gt  describe test                                            OK     uservisit2              string                                           category                string                                           uuid                    string                                           Time taken  0 213 seconds  Fetched  3 row s

User · Answer

Change Column Name Type Position Comment      ALTER TABLE table name CHANGE  COLUMN  col old name col new name column type  COMMENT col comment   FIRST AFTER column name    Example   CREATE TABLE test change  a int  b int  c int       will change column a s name to a1 ALTER TABLE test change CHANGE a a1 INT

[hive] Hive Alter table change Column Name

Examples related to hive

Examples related to alter-table

Examples related to alter