Downloading query results from Hue takes long time

If downloading query results from the Hue web UI is taking a long time or if the operation exists with the "Invalid query handle" message, then you can improve the speed by increasing the number of threads used by the Hue web server. To increase the thread count:

  1. Sign in to Cloudera Manager as an administrator.
  2. Go to Clusters > $Hue service > Configuration and search the cherrypy_server_threads property.

    The Hue Web Server Threads field is displayed.

  3. Increase the thread count to 100 or a higher value.

    The default Hue web server thread count is 50.

  4. Click Save Changes.
  5. Restart the Hue service.