HUE 1.12 and Kylin 1.6.0, works (no path is needed):
[image: Inline images 1]
But have an exception:
An error occurred while calling o2222.execute. : java.sql.SQLException:
Error while executing SQL "*SHOW DATABASES"*: java.sql.SQLException:
java.io.IOException: POST failed, error code 500 and response: {"url":"
http://172.17.0.2:7070/kylin/api/query","exception":"Not Supported SQL."}
at
org.apache.kylin.jdbc.shaded.org.apache.calcite.avatica.Helper.createException(Helper.java:56)
at
org.apache.kylin.jdbc.shaded.org.apache.calcite.avatica.Helper.createException(Helper.java:41)
at
org.apache.kylin.jdbc.shaded.org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:147)
at
org.apache.kylin.jdbc.shaded.org.apache.calcite.avatica.AvaticaStatement.execute(AvaticaStatement.java:199)
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) at
java.lang.Thread.run(Thread.java:748) Caused by:
java.lang.RuntimeException: java.sql.SQLException: java.io.IOException:
POST failed, error code 500 and response: {"url":"
http://172.17.0.2:7070/kylin/api/query","exception":"Not Supported SQL."}
work? yes, but you must put the name cube in HUE config.
The connection is fixed to one cube
On 29 August 2016 at 18:10, Alberto Ramón <a.ramonporto...@gmail.com> wrote:
> Hi (This is ONLY a Idea - suggestion)
>
> I saw some problems integration between Kylin and HUE or Tableau, when try
> to discover metadata info, like: list of databases, list of tables and list
> of columns.
>
> The most clear example: HUE 4011
> <https://issues.cloudera.org/browse/HUE-4011>, only works with
> * Show Databases;
> * Show Tables;
> * Show Columns from X.Y
>
> The result is the same:
> [image: Imágenes integradas 1]
> Other programs, tyr "select * from tb", to return list of columns .... you
> know the result of this ;)
>
> Other programs:
> * start all querires with a "use dbName; select . . ."
> * or try "from dbName.tbName" (Nowadays there is a bug)
>
>
> Really: are small things... but complicate a lot the integration with
> others Apps
>
>
>
> A lot of thanks for all, Alb
>
>
