Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Explain from Hue doesn't work

Explain from Hue doesn't work

Contributor

Hi,

 

I have a cluster with CDH 5.4.0 with Kerberos Enabled and Hue works with LDAP for using the Active Directory Credentials. I'm using Oracle as backend DB.

 

When I try to execute the "EXPLAIN" form Impala, it doesn't work and I have this error:

 

Your query has the following error(s):

Restarting of fetch requires enabling of query result caching.

If I try the same query in Hive via Hue and from impala-shell it works

 

How can I solve this?

 

Many Thanks

Alessio

 

3 REPLIES 3

Re: Explain from Hue doesn't work

Expert Contributor
Hey,

I just tested and it seems like it might be a bug. If you run "explain <query>" as the query it should work though. Have you tried that? Filed this jira to get it looked at:

https://issues.cloudera.org/browse/HUE-2771
Highlighted

Re: Explain from Hue doesn't work

Contributor

Yes, It works if I execute the "explain" as query. Thanks

 

Alessio

Re: Explain from Hue doesn't work

This is fixed in later Hue or CDH5.4.1:
https://issues.cloudera.org/browse/HUE-2686

Romain

Don't have an account?
Coming from Hortonworks? Activate your account here