Unresponsive Script in HUE 3.10 with CDH 5.8

[Ben Sullins]

I'm running CDH 5.8 in VirtualBox on my mac and am receiving an unresponsive script error once I reach about 4 queries. I'm preparing this for an upcoming course on LinkedIn Learning and could use some help resolving it. 

I believe the issue is related to autocomplete as it occurs when I try to add columns to a select statement. You can see this happen in the video below. I'd love to try disabling the autocompleter but the shortcuts I've found to get to this setting don't seem to work on this VM. 

Any thoughts on what to try?

https://www.youtube.com/watch?v=6OHbcihiCKU

Thanks,

Ben

[Ben Sullins]

This is the script that is bombing out - /static/desktop/js/ace/ext-language_tools.3051c210c650.js

--
You received this message because you are subscribed to the Google Groups "Hue-Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to hue-user+unsubscribe@cloudera.org.

[Enrico Berti]

Hi,

unfortunately you are hitting https://issues.cloudera.org/browse/HUE-4209

Can you try to remove the comments from your query?

A workaround would be to copy the fixed files (from this commit: https://github.com/cloudera/hue/commit/cd345bd5efabfd9cd8244d203d568b1547279c93) to your VM

[Ben Sullins]

Strange, what I've done to work around is to reduce the amount of queries in the window to only 1 or maybe 2. Is this fix going in a release soon?

[Ben Sullins]

Is there an easy way to disable the autocomplete all togethere?

[Romain Rigaux]

To disable:

CTRL + ,

https://dl.dropboxusercontent.com/s/u7n9r3d7u7jzthk/HUE-4386.Editor.Autocompleter_settings.mp4?dl=0

https://issues.cloudera.org/browse/HUE-4386

And autocomplete was rewritten in Hue 3.11 or CDH 5.9 (should come at the end of this month)

[Ben Sullins]

I'm not seeing those options to disable the autocomplete. Here's what I see: https://db.tt/HdXvWI6l

[Romain Rigaux]

Johan, didn't we have a ini setting to set to 0 to disable it until 3.11?

[Johan Ahlen]

For 5.8 there's a setting to disable the table and column completion, editor_autocomplete_timeout = 0, but sadly no setting to disable it completely. It seems the other setting using CTRL + , went in 3.11 together with the new autocompleter.

Ben, was it caused by https://issues.cloudera.org/browse/HUE-4209? (comments with asterisks) If not, would you care to share the statements with me? (obfuscated would be fine) That way I can debug and let you know if we and when we fixed it.

Cheers,

Johan

[Ben Sullins]

Sure thing, here is the SQL. I don't have any asterisks in m comments, just plain text. My sales_all_years table is partitioned by Yr and has 35K rows, so pretty small...

https://gist.github.com/bsullins/e2bc321d5f50400a00f2c9f4162055b5

[Johan Ahlen]

I can reproduce it in the 5.8 Quickstart VM and I've verified that it was also fixed with HUE-4209. It's caused by the asterisk in the first statement and it's related to the length of the text in the editor, at a certain point the browser becomes unresponsive.

So if you can't wait for the 5.9 VM you can patch ext-language_tools.js with the contents of https://github.com/cloudera/hue/blob/cd345bd5efabfd9cd8244d203d568b1547279c93/desktop/core/src/desktop/static/desktop/js/ace/ext-language_tools.js or perhaps skip/adjust the first select statement for your course?

Cheers,

Johan

[Ben Sullins]

Thanks, I'll probably remove the asterisks from the query for now and wait for the next release. Thanks for the follow-up!