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
85 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 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
14 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
• 25,340 points
31 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
• 25,340 points
65 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
• 67,480 points
27 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 in Big Data Hadoop by Gitika
• 25,340 points

edited Aug 7 by Gitika 29 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,810 points
35 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
20 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
40 views