Friday, 8 July 2022

Hive: Replace columns of a table

  Syntax 

ALTER TABLE name REPLACE COLUMNS (col_spec[, col_spec ...])

 

Example

ALTER TABLE employee REPLACE COLUMNS ( 
emp_id INT,  
emp_name STRING);

 

Above snippet delete all the columns from the employee table and replaces it with emp_id, emp_name columns. You can use ‘REPLACE COLUMNS’ statement to delete a column.

hive> DESC employee;
OK
id                  	int                 	                    
name                	string              	                    
organization        	string              	Organization name in the compay
age                 	int                 	employee age        
Time taken: 0.073 seconds, Fetched: 4 row(s)
hive> ;
hive> ;
hive> ALTER TABLE employee REPLACE COLUMNS ( 
    > emp_id INT,  
    > emp_name STRING);
OK
Time taken: 0.088 seconds
hive> ;
hive> ;
hive> DESC employee;
OK
emp_id              	int                 	                    
emp_name            	string              	                    
Time taken: 0.102 seconds, Fetched: 2 row(s)



Previous                                                    Next                                                    Home

No comments:

Post a Comment