Hello everyone, I'm running Hive 0.12.0 and I thought that support for moving tables between database was added by using ALTER TABLE RENAME TO fully qualified name. Here is what I executing;
ALTER TABLE default.sale_reports RENAME TO sales_database.sale_reports; Thanks, Clay