Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

CommandError: Unable to serialize database: no such table: search_facet

avatar
Explorer

Trying to convert MySQl Lite DB to MySQL by following the steps from: (poorly written)

http://www.cloudera.com/documentation/cdh/5-1-x/CDH5-Installation-Guide/cdh5ig_hue_database.html

 

 

$ sudo -u hue <HUE_HOME>/build/env/bin/hue dumpdata > <some-temporary-file>.json

 

The steps says : 

But it should be like this below and when I run the command I am getting this error.

 

 

/opt/cloudera/parcels/CDH-5.5.2-1.cdh5.5.2.p0.4/lib/hue/build/env/bin/hue dumpdata >hue_dumpdata.2017-10-30.json CommandError: Unable to serialize database: no such table: search_facet

 

After searching in Google, I went to this link where it says this problem got solved but again the steps are not written in a way anyone can understand

 

http://community.cloudera.com/t5/Web-UI-Hue-Beeswax/Hue-dumpdata-returns-quot-CommandError-Unable-to...

 

So someone please help me.

 

Thanks

1 REPLY 1

avatar
Mentor
If you're managing your Hue service via Cloudera Manager, you can do the dump and load via the UI.

Stop the Hue service with the SQLite configuration, then click 'Dump Database' under the Hue service page's Actions button. Next, reconfigure the stopped Hue service to use your new MySQL DB, and before starting it go back to the Actions button and click 'Load Database'.