Good information!
On Sun, Jul 9, 2017 at 9:21 AM, Alberto Ramón <a.ramonporto...@gmail.com>
wrote:
> 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
>>
>>
>
