Delete column in hive table

Question

I am working with hive version 0.9 and I need to remove the hive table columns. I searched in several beehive team manuals, but I only found commands for version 0.14. Can a hive table column be deleted in hive version 0.9? Which team? Thank.

Answer 1

We cannot just remove the table column from the hive table using the following statement, for example sql.

ALTER TABLE tbl_name drop column column_name ---- it will not work.

So, there is a shortcut to remove columns from the hive table.

Let's say we have a beehive table.

From this table I want to remove the Dob column. You can use the ALTER TABLE REPLACE statement to delete a column.

ALTER TABLE test_tbl REPLACE COLUMNS(ID STRING,NAME STRING,AGE STRING);   you have to give the column names which you want to keep in the table

Answer 2

Hive does not have a drop or delete column.

SELECT regex Hive 0.13.0 0.13.0 , hive.support.quoted.identifiers none.

, :

drop table if       exists database.table_name;
create table if not exists database.table_name as
select `(column_to_remove_1|...|column_to_remove_N)?+.+`
    from database.some_table
    where 
    ...
;

some_table, column_to_remove_1,..., to column_to_remove_N. .

Answer 3

ALTER TABLE table_name REPLACE COLUMNS ( c1 int, c2 String);

: . .

Answer 4

hive. ( ) ( ), . , ( ), :

show create table database_name.table_name;

( ). ,

Answer 5

empid, , , , . . REPLACE COLUMNS, jdbc: hive2://" > alter table employee (empid int, , dept, int);

Answer 6

, , alter.

Alter - replace .

: fooobar.com/questions/2254603/...

Answer 7

Thanks for the information ALTER TABLE test_tbl REPLACE COLUMNS (ID STRING, NAME STRING, AGE STRING); this command works for me