Support Questions
Find answers, ask questions, and share your expertise

How can i migrate HUE default repository database (SQLite) to oracle through commandline

Rising Star

Team ,

 

I have installed HUE using Ambari and by default it installed its metadata on SQLite . Now i want to move the metadata to oracle database . I don't have dump option as in cloudera manager has . please let me know how can i migrate through command line .

2 REPLIES 2

@bhara   There is a Sync Metastore option in the admin Actions drop down down in Ambari.  After making the change from default to external metastore,  try the Metastore Sync...  

Rising Star

Hi @stevenmatison when i change the default data base to oracle .HUE UI dose not come up .it give me below error .

 

Request Method:Request URL:Django Version:Exception Type:Exception Value:

GET
http://xxxxxxx:8888/
1.11.22
DatabaseError
ORA-00942: table or view does not exist
Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.