Integrate Hue with Drill

Important: Hue integration with Drill is an experimental feature. In addition, this method of configuration works only with Hue 3.12 or later.
  1. In the hue.ini, go to the notebook section, and set dbproxy_extra_classpath parameter to contain the path to the Drill JDBC driver. For example:
    [notebook]
      ...
      ## Classpath to be appended to the default DBProxy server classpath.
      dbproxy_extra_classpath=/opt/mapr/drill/drill-1.10.0/jars/jdbc-driver/drill-jdbc-all-1.10.0.jar
    
  2. Add Drill interpreter to notebook.interpreters section in hue.ini. For example:
    [notebook]
      ...
      # One entry for each type of snippet.
      [[interpreters]]
        ...
        [[[drill]]]
          name=Drill JDBC
          interface=jdbc
          ## Specific options for connecting to the server.
          ## The JDBC connectors, e.g. mysql.jar, need to be in the CLASSPATH environment variable.
          ## If 'user' and 'password' are omitted, they will be prompted in the UI.
          options='{"url": "<drill-jdbc-url>", "driver": "org.apache.drill.jdbc.Driver", "user": "admin", "password": "admin"}'
    

    You can specify any valid Drill JDBC connection string as a <drill-jdbc-url> parameter. For more information, see Using the JDBC Connector in an Application.

  3. Restart Hue to apply the updated configuration:
    maprcli node services -name hue -action restart -nodes <node>

    Now you can use Drill JDBC snippets in Hue Notebooks.