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.

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

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

New Contributor

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
Highlighted

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

Master Guru
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'.