Support Questions

Find answers, ask questions, and share your expertise

Hue Presto autocomplete not working 3.10.0

New Contributor

Hi,

 

I'm using Hue notebooks Presto quering through the JDBC driver.

 

Presto autcomplete isn't working most of the time(works in a small part of time).

 

the errors I see on the times it doesn't work are:

 

decorators   ERROR    error running <function autocomplete at 0x7fcdeef3db18>

Traceback (most recent call last):

  File "/usr/lib/hue/desktop/libs/notebook/src/notebook/decorators.py", line 81, in decorator

    return func(*args, **kwargs)

  File "/usr/lib/hue/desktop/libs/notebook/src/notebook/api.py", line 476, in autocomplete

    autocomplete_data = get_api(request, snippet).autocomplete(snippet, database, table, column, nested)

  File "/usr/lib/hue/desktop/libs/notebook/src/notebook/connectors/jdbc.py", line 47, in decorator

    raise QueryError(message)

QueryError: list index out of range

...

 

views        ERROR    Spark is not enabled

Traceback (most recent call last):

  File "/usr/lib/hue/desktop/libs/notebook/src/notebook/views.py", line 69, in notebook

    from spark.conf import LIVY_SERVER_SESSION_KIND

ImportError: No module named spark.conf

 

Any ideas?

 

Thanks,

YB

 

 

5 REPLIES 5

It is probably a problem with the Presto data returned for the describe
table/column.

Does it happen all the time on the same table?

New Contributor
Thank you Romain!

No, when it doesn't work it doesn't work for all tables (and when it does work occasionally, it works for all)...

Do you use it via EMR or your custom Hue? (EMR people could help
investigate, we mostly do testing with Impala/Hive for now)

New Contributor

It's EMR, I'll contact their support team.

 

is there any way to connect Presto query into the query editor tab instead of using it as a notebook?

Looks for the name of the Presto snippet in
127.0.0.1:8000/desktop/dump_config in Notebook

Then just replace hive by its name in
127.0.0.1:8000/notebook/editor?type=hive

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.