Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

HIVE don't display databases after re-creating cluster

Solved Go to solution
Highlighted

HIVE don't display databases after re-creating cluster

New Contributor

Hi,

I've created hadoop cluster on Azure HDinsight, next I've created some databases on hive. After deleting and re-creating cluster with connection to the same storage account hive is not showing all databases by 'show databases;' command, I see only three default databases (default, information_schema,sys) even though the databases I've created are visible in hdfs.

1 ACCEPTED SOLUTION

Accepted Solutions

Re: HIVE don't display databases after re-creating cluster

Master Collaborator

@Damian_S  Yes, I always use mysql/mariadb for hive metastore.  If you have the original data you can you just move it to the new location?  This should be part of your migration steps regardless of the backend for the metastore.

 


 


If this answer resolves your issue or allows you to move forward, please choose to ACCEPT this solution and close this topic. If you have further dialogue on this topic please comment here or feel free to private message me. If you have new questions related to your Use Case please create separate topic and feel free to tag me in your post.  


 


Thanks,



Steven

View solution in original post

3 REPLIES 3
Highlighted

Re: HIVE don't display databases after re-creating cluster

Master Collaborator

@Damian_S If you have re-created the cluster,  did you migrate the original hive metastore data?  This metastore would have stored details about the hive tables in hdfs.   If you no longer have this metastore data, you will need to recreate the hive schemas/databases, and re-execute the hive table create statements against the hdfs files.   

 

If the metastore is intact (not recreated, reset, etc) then you may be experiencing permission issues against the files in hdfs.  

 


 


If this answer resolves your issue or allows you to move forward, please choose to ACCEPT this solution and close this topic. If you have further dialogue on this topic please comment here or feel free to private message me. If you have new questions related to your Use Case please create separate topic and feel free to tag me in your post.  


 


Thanks,



Steven

Highlighted

Re: HIVE don't display databases after re-creating cluster

New Contributor

I haven't migrated the original metastore data. Is it possible to do this if I haven't put my metastore data outside the default database (I found information that by default metastore data is stored in derby database on the head node)? Or better way is to create some external database to keep metastore data and point the cluster to use this when re-creating?

Re: HIVE don't display databases after re-creating cluster

Master Collaborator

@Damian_S  Yes, I always use mysql/mariadb for hive metastore.  If you have the original data you can you just move it to the new location?  This should be part of your migration steps regardless of the backend for the metastore.

 


 


If this answer resolves your issue or allows you to move forward, please choose to ACCEPT this solution and close this topic. If you have further dialogue on this topic please comment here or feel free to private message me. If you have new questions related to your Use Case please create separate topic and feel free to tag me in your post.  


 


Thanks,



Steven

View solution in original post

Don't have an account?
Coming from Hortonworks? Activate your account here