Member since
12-30-2015
5
Posts
0
Kudos Received
1
Solution
My Accepted Solutions
Title | Views | Posted |
---|---|---|
2570 | 07-19-2016 03:50 PM |
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.
... View more
07-19-2016
11:40 AM
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
... View more
Labels: