Hi Kumar,
It’s likely that this is caused by the live autocomplete having too many suggestions, this can for instance happen in the filter clause when there are many tables in the query. The issue is tracked in
https://issues.cloudera.org/browse/HUE-6688
Until it’s been improved you can control the autocomplete behaviour by:
1. Click in the editor somewhere
2. Press ctrl/cmd - , (comma) and a settings panel should appear on the right
3. Uncheck “Enable Live Autocompletion”
The new syntax checker runs in a separate web worker and I don’t believe that it's causing the issue you’re describing, you can turn that off as well in the same config panel mentioned above by unchecking “Error Highlighting”. These settings are per user and stored in the browser.
If it’s still slow after any of these changes please let us know as there might be something else going on.
Thanks,
Johan