Created on 07-19-2016 11:40 AM - edited 09-16-2022 03:30 AM
Hi All,
I've been using the guide on installing Mysql for Hue as posted here:
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
Created 07-19-2016 03:50 PM
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.
Created 07-19-2016 03:50 PM
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.