Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

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

avatar
Explorer

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

 

 

1 ACCEPTED SOLUTION

avatar
Explorer

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.

 

View solution in original post

1 REPLY 1

avatar
Explorer

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.