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,581 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
413 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,910 points
397 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,910 points
355 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
2,121 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,190 points
399 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,910 points

edited Aug 7, 2019 by Gitika 889 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,440 points
560 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
468 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
449 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP