How to add mysql database for Hue Query app?

0 votes
Hi. I want to add mysql database to the query app of Hue to make data transactions. Please help me on how to do it. And also tell me what properties I should add in this.
May 27 in Big Data Hadoop by Raj
14 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
0 votes

Hi. To add mysql database in the config, open the hue configuration file and search for the [[database]] section under the [librdbms] section. Then create a section [[[mysql]]] where you can add properties of MySql database. 

The properties you will have to add are:

# Name to show in the UI.      
## nice_name="My SQL DB"      

# For MySQL and PostgreSQL, name is the name of the database.      
# For Oracle, Name is instance of the Oracle server. For express edition      
# this is 'xe' by default.      
## name=mysqldb      

# Database backend to use. This can be:      
# 1. mysql      
# 2. postgresql      
# 3. oracle      
## engine=mysql      

# IP or hostname of the database to connect to.      
## host=localhost 
     
# Port the database server is listening to. Defaults are:      
# 1. MySQL: 3306      
# 2. PostgreSQL: 5432      
# 3. Oracle Express Edition: 1521      
## port=3306      

# Username to authenticate with when connecting to the database.      
## user=example     
 
# Password matching the username to authenticate with when      
# connecting to the database.      
## password=example
answered May 27 by Vasu

Related Questions In Big Data Hadoop

0 votes
1 answer

How to add filter for groups in Hue?

Open the Hue configuration file Search for [[ldap]] section Search for [[[groups]]] section Set the ...READ MORE

answered May 28 in Big Data Hadoop by Karan
8 views
0 votes
1 answer

How to create database in Mysql?

The command you can use is: create table ...READ MORE

answered Apr 15 in Big Data Hadoop by Gitika
• 14,110 points
20 views
0 votes
1 answer

How to create table inside database in MySql in Linux?

We can use this command to create ...READ MORE

answered Apr 15 in Big Data Hadoop by Gitika
• 14,110 points
50 views
0 votes
1 answer
0 votes
1 answer

Update hdfs data before stroring in MySql

Yes, you can update the data before ...READ MORE

answered Jan 27 in Big Data Hadoop by Omkar
• 66,880 points
18 views
0 votes
1 answer

Using Hadoop for Data Analytics.

Yes, your approach is correct - you ...READ MORE

answered Sep 28, 2018 in Big Data Hadoop by Frankie
• 9,710 points
23 views
0 votes
1 answer

How to open MySql console in Ubuntu?

sudo service mysqld restart mysql -u <username> root ...READ MORE

answered Dec 14, 2018 in Big Data Hadoop by Omkar
• 66,880 points
63 views
0 votes
1 answer

Facing the below error while installing mysql in VM

We would like to say that the ...READ MORE

answered Dec 21, 2018 in Big Data Hadoop by Omkar
• 66,880 points
44 views
0 votes
1 answer

How to set SQLite Query Configurations in Hue?

To set the query configurations, you will ...READ MORE

answered May 27 in Big Data Hadoop by Suri
10 views
0 votes
1 answer

How to set authentication for Kerberos in Hue?

To set the authentication for Solr clients ...READ MORE

answered May 27 in Big Data Hadoop by Jimmy
12 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.