04-28-2016 09:39 PM
I find HUE is not available to change the schema of the HIVE table, is it ?
If I want to change the schema of a exist table, shall I delete the table and create again ?
Thanks you gus!
05-02-2016 11:11 AM
ALTER (DATABASE|SCHEMA) database_name SET DBPROPERTIES (property_name=property_value, ...); -- (Note: SCHEMA added in Hive 0.14.0)
ALTER (DATABASE|SCHEMA) database_name SET OWNER [USER|ROLE] user_or_role; -- (Note: Hive 0.13.0 and later; SCHEMA added in Hive 0.14.0)
05-02-2016 01:44 PM
Yeh, you can do it like this. But it is still like work in the backend. Actually if I want to change some column data type, it should be click on the specific column on a drag down menu and choose the right data type, then submit.