Hive 0.6 has support for multiple databases/schemas. Is this feature mature enough to be used in production? Are there any particular features known to not work with databases (I know you cannot run queries using multiple databases at the same time)? Currently, there doesn't seem to be an easy way to move existing tables into a new database from CLI but it should be possible to do this directly by modifying the metastore right? Is there anything to watch out for?
Thanks, Vijay