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

[#1]

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_w...

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

[#2 · Accepted solution]

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.