Hue’s Impala application supports interactive SQL and HiveQL queries from within your browser. Hue provides additional functionality with Impala that is not available from the command line such as parameterized queries, syntax highlighting, and saving queries.
For information about installing Impala, see Installing Impala on MapR.
To configure Hue to work with Impala, edit the
hue.ini file and change parameter values as necessary. The next section shows the default version of the Impala settings in
hue.ini. For instructions on how to change Impala settings, see Modifying the hue.ini File.
Default Impala Settings in
The default version of the
impala section of the
hue.ini file is shown below.
To configure Hue to work with Impala, change the values of the following parameters in the
The hostname or IP address of the Impala server
The port of the Impalad server
Turns the impersonation mechanism on or off when talking to Impala
server_hostis not localhost, change the hostname (and remove the ## characters to uncomment the line).
If you are not using the default server port (21050), change the
server_portsetting to the port you are using (and remove the ## characters to uncomment the line).
Enable impersonation in Impala so the user
maprcan impersonate any Linux PAM user on the cluster:
/opt/mapr/impala/impala-1.2.3/conf/env.shfile, and add the following property to the section
Enable impersonation for Impala in the
hue.inifile by setting
true(and remove the ## characters to uncomment the line).
Restart Hue so the changes will take effect.