Home

Monitoring Impala Queries Through the Impala Daemon

It's best practice to use Cloudera Manager (CM) as the data source for Impala queries, but if you prefer to use the impala daemon (impalad), follow these instructions. These instructions don't require CM credentials. However, if the impalad web interface is secure as indicated in Cloudera's Securing the Impala Web User Interfacel and Impala Web User Interface for Debugging, then you need to use CM as the data source.

Note

Before following these instructions, follow the steps in Step 1: Install Unravel Server on CDH+CM.

On Unravel Server, set the following properties in /usr/local/unravel/etc/unravel.properties. If you don't find them, add them. Be sure to set com.unraeldata.source to impalad

Property/Description

Set By User

Unit

Default

com.unraveldata.data.source

Can be cm or impalad.

 

cm

com.unraveldata.impalad.nodes

Node list in the form of ip:port,ip:port,ip:port.

Required

CSL

com.unraveldata.data.source=impalad 
com.unraveldata.impalad.nodes=ip:port,ip:port,ip:port
Change the Impala Lookback Window

By default, when Unravel Server starts, it retrieves the last 5 days of Impala queries. To change this, do the following:

  1. Open unravel.properties on Unravel Server.

  2. Change com.unraveldata.cloudera.manager.impala.look.back.day.

    For example,

    com.unraveldata.cloudera.manager.impala.look.back.days=-7

    Note

    Include a minus sign in front of the new value.

  3. Restart unravel_us daemon. In the example below the default is set to 7 days.

References