Reply
New Contributor
Posts: 7
Registered: ‎03-24-2016

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

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

Posts: 1,565
Kudos: 287
Solutions: 239
Registered: ‎07-31-2013

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

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'.
Backline Customer Operations Engineer
Announcements