Hue dumpdata returns "CommandError: Unable to serialize database: no such table: desktop_document2"

slavo — Tue, 21 Apr 2026 13:58:07 GMT

Hi,

I want to migrate the Hue database from sqlite3 to MySQL and dump the data from sqlite to a JSON file:

logged on as user "hue" (who is the "owner" of Hue)

$ /opt/cloudera/parcels/CDH-5.4.4-1.cdh5.4.4.p0.4/lib/hue/build/env/bin/hue dumpdata >hue_dumpdata.2015-07-20.json
CommandError: Unable to serialize database: no such table: desktop_document2

When I use sqlite to display the list of tables, I can see it there:

$ sqlite3 /var/hadoop/data/hue/desktop.db
SQLite version 3.6.20
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .tables '%';
auth_group oozie_datainput
auth_group_permissions oozie_dataoutput
...

desktop_document oozie_generic
desktop_document2 oozie_history
desktop_document2_dependencies oozie_hive

...

What's wrong with this?

Thanks in advance.

Regards,

Slavo

Re: Hue dumpdata returns "CommandError: Unable to serialize database: no such table: desktop_do

Romainr — Mon, 20 Jul 2015 16:19:02 GMT

Are you using CM?

If yes before running the command you need to:

*Note*:

If using CM, export this variable in order to point to the correct database:
1
2
3
HUE_CONF_DIR=/var/run/cloudera-scm-agent/process/-hue-HUE_SERVER-id
echo $HUE_CONF_DIR
export HUE_CONF_DIR

Where is the most recent ID in that process directory for
hue-HUE_SERVER.

http://gethue.com/export-and-import-your-oozie-workflows/

question Re: Hue dumpdata returns "CommandError: Unable to serialize database: no such table: desktop_do in Archives of Support Questions (Read Only)

Hue dumpdata returns "CommandError: Unable to serialize database: no such table: desktop_document2"

Re: Hue dumpdata returns "CommandError: Unable to serialize database: no such table: desktop_do