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, 2019 in Big Data Hadoop by Raj
1,312 views

1 answer to this question.

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, 2019 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, 2019 in Big Data Hadoop by Karan
262 views
0 votes
1 answer

How to create database in Mysql?

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

answered Apr 15, 2019 in Big Data Hadoop by Gitika
• 65,870 points
335 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 16, 2019 in Big Data Hadoop by Gitika
• 65,870 points
297 views
0 votes
1 answer

How to connect Sqoop to mysql Database?

Hi. You can connect Sqoop to MySql ...READ MORE

answered May 15, 2019 in Big Data Hadoop by Tina
1,806 views
0 votes
1 answer

Update hdfs data before stroring in MySql

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

answered Jan 27, 2019 in Big Data Hadoop by Omkar
• 69,210 points
305 views
0 votes
1 answer

Error: Hive show tables does not display table "sqooptest" , which was imported by SQOOP

Hi, You can follow the below-given solution. Just enter ...READ MORE

answered Aug 7, 2019 in Big Data Hadoop by Gitika
• 65,870 points

edited Aug 7, 2019 by Gitika 693 views
0 votes
1 answer

ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

Hi@akhtar, Before setting password in mysql, check the ...READ MORE

answered Feb 13, 2020 in Big Data Hadoop by MD
• 95,360 points
450 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, 2019 in Big Data Hadoop by Suri
328 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, 2019 in Big Data Hadoop by Jimmy
343 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP