Error on importing data into Mysql from Sqlite3 for external db use with Hue

023586 — Tue, 21 Apr 2026 13:50:35 GMT

Hi All,

I've been using the guide on installing Mysql for Hue as posted here:

http://www.cloudera.com/documentation/enterprise/5-5-x/topics/cdh_ig_hue_database.html#concept_id1_wkj_zj__section_pmx_plj_zj

I'm at the point (Step 18) where you import the data into Mysql with:

<HUE_HOME>/build/env/bin/hue loaddata <some-temporary-file>.json

This fails with:

django.db.utils.IntegrityError: Problem installing fixtures: The row in table 'beeswax_queryhistory' with primary key '225' has an invalid foreign key: beeswax_queryhistory.owner_id contains a value '3' that does not have a corresponding value in auth_user.id.

CDH Version info:

Cloudera Express 5.7.1

Mysql Version info:

MySQL-python.x86_64 1.2.3-0.3.c1.1.el6
mysql.x86_64 5.1.73-7.el6
mysql-connector-java.noarch 1:5.1.17-6.el6
mysql-devel.x86_64 5.1.73-7.el6
mysql-libs.x86_64 5.1.73-7.el6
mysql-server.x86_64 5.1.73-7.el6
perl-DBD-MySQL.x86_64 4.013-3.el6

OS Version info:

CentOS release 6.8 (Final)

Thoughts?

Regards

TimW

Re: Resolved - Error on importing data into Mysql from Sqlite3 for external db use with Hue

023586 — Tue, 19 Jul 2016 22:50:33 GMT

Issue has been resolved by using the the CDH manager and changing the config for Hue's database from Sqlite3 to Mysql and adding the appropriate user info. I'm skipping the import since there wasn't much in it.

question Error on importing data into Mysql from Sqlite3 for external db use with Hue in Archives of Support Questions (Read Only)

Error on importing data into Mysql from Sqlite3 for external db use with Hue

Re: Resolved - Error on importing data into Mysql from Sqlite3 for external db use with Hue