Reply
New Contributor
Posts: 3
Registered: ‎11-29-2017

HUE and Presto Integration Error on Page Load

Hi,

 

Trying to integrate HUE version 4 with Presto. Functionality-wise it is work, however when page loads we get an error on the top right corner. It seems that HUE tries to run this query when query editor is loaded:

 

SELECT DatabaseName FROM DBC.Databases

 

Any idea how I might disable this?

 

Stack trace:

 

An error occurred while calling o30.execute. : java.sql.SQLException: [Teradata][Presto](100050) Query failed: line 1:26: Schema dbc does not exist. at com.teradata.presto.PRUtils.parseError(Unknown Source) at com.teradata.presto.dataengine.PRResultSet.parseDataString(Unknown Source) at com.teradata.presto.dataengine.PRResultSet.execute(Unknown Source) at com.teradata.presto.dataengine.PRQueryExecutor.execute(Unknown Source) at com.teradata.jdbc.common.SStatement.executeNoParams(Unknown Source) at com.teradata.jdbc.common.SStatement.execute(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at py4j.reflection.MethodInvoker.invoke(MethodInvoker.java:231) at py4j.reflection.ReflectionEngine.invoke(ReflectionEngine.java:381) at py4j.Gateway.invoke(Gateway.java:259) at py4j.commands.AbstractCommand.invokeMethod(AbstractCommand.java:133) at py4j.commands.CallCommand.execute(CallCommand.java:79) at py4j.GatewayConnection.run(GatewayConnection.java:209) Caused by: com.teradata.support.exceptions.GeneralException: [Teradata][Presto](100050) Query failed: line 1:26: Schema dbc does not exist. ... 16 more

Cloudera Employee
Posts: 702
Registered: ‎07-30-2013

Re: HUE and Presto Integration Error on Page Load

New Contributor
Posts: 3
Registered: ‎11-29-2017

Re: HUE and Presto Integration Error on Page Load

Since it's configured under the notebook / interpreter, I would expect it to not run any query until I instruct it to, which is the behavior in HUE 3. Is there anyway I can have it not run that query at load?

 

Thanks.

Announcements