Member since
09-18-2015
216
Posts
208
Kudos Received
49
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
948 | 09-13-2017 06:04 AM | |
1916 | 06-27-2017 06:31 PM | |
1888 | 06-27-2017 06:27 PM | |
8359 | 11-04-2016 08:02 PM | |
8986 | 05-25-2016 03:42 PM |
09-29-2015
03:20 AM
3 Kudos
Here is instruction for moving Hue from Sqlite to MySQL and same can be changed to work with Postgres. Self posting the answer after test. Create a new user in MySQL, and grant privileges to it to manage the database using the MySQL database admin utility. # mysql -u root -p
CREATE USER $HUEUSER IDENTIFIED BY ‘$HUEPASSWORD’;
GRANT ALL PRIVILEGES on *.* to ‘$HUEUSER’@’localhost’ WITH GRANT OPTION;
GRANT ALL on $HUEUSER.* to ‘$HUEUSER’@’localhost’ IDENTIFIED BY ‘$HUEPASSWORD’;
FLUSH PRIVILEGES;
Create the MySQL database for Hue. # mysql -u root -pCREATE DATABASE $DBNAME;
Stop Hue if it is running. /etc/init.d/hue stop
To migrate your existing data to MySQL, use the following command to dump the existing database data to a text file. Note that using the “.json” extension is required. /usr/lib/hue/build/env/bin/hue dumpdata > /tmp/hue_db_dump.json
Open the /etc/hue/conf/hue.ini file and edit the [[database]] section (modify for your MySQL setup). [[database]]
engine=mysql
host=$DATABASEIPADDRESSORHOSTNAME
port=$PORT
user=$HUEUSER
password=$HUEPASSWORD
name=$DBNAME
As the Hue user, configure Hue to load the existing data and create the necessary database tables. /usr/lib/hue/build/env/bin/hue syncdb --noinput
/usr/lib/hue/build/env/bin/hue migrate
/usr/lib/hue/build/env/bin/hue loaddata /tmp/hue_db_dump.json
Your system is now configured and you can start the Hue server as normal. /etc/init.d/hue start
... View more
09-29-2015
03:14 AM
1 Kudo
@schintalapani@hortonworks.com But service already exists in my case, what would be Ambari API call to register this service?
... View more
09-29-2015
01:51 AM
Labels:
- Labels:
-
Apache Hadoop
09-29-2015
01:41 AM
1 Kudo
Labels:
- Labels:
-
Apache Ambari
-
Apache YARN
09-29-2015
01:29 AM
1 Kudo
What are advantages and benefits of G1GC? Any benchmarks?
... View more
Labels:
- Labels:
-
Apache HBase
09-29-2015
01:20 AM
2 Kudos
Labels:
- Labels:
-
Apache Hadoop
-
Cloudera Hue
09-29-2015
01:14 AM
1 Kudo
I have upgraded Ambari to 2.1.0 and HDP to 2.2.6, now I want to manage Kafka using Ambari as it was not managed by Ambari in Ambari1.5.1. How to add Kafka service to Ambari?
... View more
Labels:
- Labels:
-
Apache Ambari
-
Apache Kafka
09-29-2015
01:10 AM
4 Kudos
Labels:
- Labels:
-
Apache Ambari
09-29-2015
01:05 AM
1 Kudo
Labels:
- Labels:
-
Apache Hadoop
-
Apache HBase
-
Apache Phoenix
09-29-2015
01:02 AM
Labels:
- Labels:
-
Apache Hadoop
-
Cloudera Hue
- « Previous
- Next »