You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
This should be as "simple" as replicating the content of the MySQL metastore database.
Nevertheless, we could be more ambitious and a database per user could be created, containing each database each user's tables. The owner of each table is indicated when describing a table in an extended or formatted way. If the owner is root/hive, this is because the table was created by the Hive server on behalf of Cygnus; in that case the owner is prefixing the table name.
This should be as "simple" as replicating the content of the MySQL metastore database.
Nevertheless, we could be more ambitious and a database per user could be created, containing each database each user's tables. The owner of each table is indicated when describing a table in an extended or formatted way. If the owner is root/hive, this is because the table was created by the Hive server on behalf of Cygnus; in that case the owner is prefixing the table name.
Some links helping on moving Hive tables:
http://stackoverflow.com/questions/23206551/transferring-hive-table-from-one-database-to-another
http://stackoverflow.com/questions/26636839/how-to-copy-all-hive-table-from-one-database-to-other-database
It seems the location is needed; this is also given by the describe extended/formatted command.
The text was updated successfully, but these errors were encountered: