Re: Kylin and Tableau JDBC

[Temple Zhou <db...@gmail.com>]

Hi Piotr,

Thank you for your guide.

I have tested the JDBC driver that you provided and run smoothly with
tableau desktop 2019.1(Generic JDBC).

BTW:
How do you find that the KylinConnection class derived from
AvaticaConnection throws NonImplementedException?
The log of Tableau Desktop is very restricted.
The Apache Drill can provide more details?

On Mon, Jul 15, 2019 at 4:59 PM Piotr Naszarkowski <pn...@gmail.com>
wrote:

> Hi there,
>
> Steps are:
> 1) put the driver in the location you mentioned
> 2) restart tableau desktop
>
> If you're trying with the driver taken from the binary package of kylin
> 2.6.2 it does not work. For me it started to work:
> 1) when I built the jdbc module locally (it got bigger than from the
> binary package: ~7MB in local compilation vs ~5MB in the package)
> 2) when I upgraded the version of avatica, you can get the version I
> compiled and test it on your side: https://gofile.io/?c=jTOaYH
>
> Let me know if the version I provided works for you.
>
> Cheers,
> Piotr
>
> pon., 15 lip 2019 o 10:52 Temple Zhou <db...@gmail.com> napisał(a):
>
>> Hi Piotr,
>>
>> I'm trying to review the PR https://github.com/apache/kylin/pull/739
>>
>> The Tableau Desktop Version that I used is same with you, but the error
>> messages are:
>>
>> {"ts":"2019-07-15T15:53:03.204","pid":30168,"tid":"1038","sev":"warn","req":"-","sess":"-","site":"-","user":"-","k":"compute-task-error","v":{"msg":"com.tableausoftware.jdbc.TableauJDBCException:
>> java.sql.SQLException: No suitable driver\nNo suitable
>> driver\n","stack":"disabled","task-name":"class `anonymous
>> namespace'::ConstructProtocolTask"},"ctx":{"client-type":"desktop","procid":"59408","tid":"55508","version":"20191.19.0515.1028"}}
>> {"ts":"2019-07-15T15:53:03.204","pid":30168,"tid":"1038","sev":"warn","req":"-","sess":"-","site":"-","user":"-","k":"excp","v":{"class":"genericjdbc","dse-type":"NoDriver","excp-msg":"com.tableausoftware.jdbc.TableauJDBCException:
>> java.sql.SQLException: No suitable driver\nNo suitable
>> driver\n","excp-type":"DataSourceException","is-bad-request":false,"is-local-configuration-error":true,"is-remote-configuration-error":false,"msg":"DataSourceException::Throw"},"ctx":{"client-type":"desktop","procid":"59408","tid":"55508","version":"20191.19.0515.1028"}}
>>
>> My steps are as follows:
>> 1. Put the jdbc jar(kylin-jdbc-2.6.2.jar) under the dir (C:\Program
>> Files\Tableau\Drivers)
>> 2. Connect to Kylin with URI: jdbc:kylin://192.168.200.138:7070
>> [image: image.png]
>>
>> Can you share your steps to connect Kylin via Tableau JDBC ?
>> Is there any additional configuration?
>>
>> Thanks,
>> Temple Zhou
>>
>

Re: Kylin and Tableau JDBC

[nichunen <ni...@apache.org>]

Hi Piotr,


PR approved and merged, it will be in the scope of version 3.0.0-alpha2 which will be released soon.


Thanks for your contribution!


Thanks for Temple’s testing and verification.



Best regards,

 

Ni Chunen / George



On 07/16/2019 09:28，Temple Zhou<db...@gmail.com> wrote：
Hi Piotr,


I am sorry to reply you so late.


The PR will be merged quickly.


Thanks,
Temple Zhou

Re: Kylin and Tableau JDBC

[nichunen <ni...@apache.org>]

Hi Piotr,


PR approved and merged, it will be in the scope of version 3.0.0-alpha2 which will be released soon.


Thanks for your contribution!


Thanks for Temple’s testing and verification.



Best regards,

 

Ni Chunen / George



On 07/16/2019 09:28，Temple Zhou<db...@gmail.com> wrote：
Hi Piotr,


I am sorry to reply you so late.


The PR will be merged quickly.


Thanks,
Temple Zhou

Re: Kylin and Tableau JDBC

[Temple Zhou <db...@gmail.com>]

Hi Piotr,

I am sorry to reply you so late.

The PR will be merged quickly.

Thanks,
Temple Zhou

Re: Kylin and Tableau JDBC

[Temple Zhou <db...@gmail.com>]

Hi Piotr,

I am sorry to reply you so late.

The PR will be merged quickly.

Thanks,
Temple Zhou