You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@kylin.apache.org by Piotr Naszarkowski <pn...@gmail.com> on 2019/07/09 19:25:56 UTC
Kylin and Tableau JDBC
Dear Kylin Team,
I'm trying to connect Tableau (Desktop for now) to Apache Kylin using JDBC
driver. Connection fails with the error below.
[image: image.png]
I know that there are limitations regarding dialect from Tableau side (
https://onlinehelp.tableau.com/current/pro/desktop/en-us/examples_otherdatabases_jdbc.htm),
which might be the issue however I'm not sure about it.
The error messages in Tableau log files are not much of value, but I attach
the most meaningful log entry below:
{"ts":"2019-07-09T21:09:43.021","pid":11780,"tid":"2504","sev":"error","req":"-","sess":"-","site":"-","user":"-","k":"detailed-error-msg","e":{"category":"needs-classification","log-code":"bad0a3fa"},"v":{"details":["com.tableausoftware.jdbc.TableauJDBCException:
Error in isConnected","Generic JDBC connection
error","com.tableausoftware.jdbc.TableauJDBCException: Error in
isConnected\n"],"headline":"An error occurred while communicating with
Other Databases (JDBC).\n","shortMessage":"Bad Connection: Tableau could
not connect to the data source.","support-help-link":"
https://www.tableau.com/en-us/app/producthelp?build=20191.19.0213.2333&edition=pro&errorcode=&errormessage=&lang=en-us&platform=windows&type=redirect&version=2019.1
"}}
JDBC works fine with my installation from e.g. squirrelSQL.
Anybody has a clue how to make it work? Do you think that there is
something in the code of jdbc driver that can be checked/fixed or debugged?
Is there anything you would recommend?
Versions:
Tableau Desktop 2019.1 installed on Windows
Apache Kylin 2.6.2 installed from binaries on CentOS
Apache Kylin jdbc driver built locally from 2.6.3 revision/tag.
Thanks,
Piotr
Re: Kylin and Tableau JDBC
Posted by ShaoFeng Shi <sh...@apache.org>.
I'm afraid the JDBC doesn't work for Tableau (new approach, need
investigation). Almost all users are using ODBC driver with Tableau today.
Best regards,
Shaofeng Shi 史少锋
Apache Kylin PMC
Email: shaofengshi@apache.org
Apache Kylin FAQ: https://kylin.apache.org/docs/gettingstarted/faq.html
Join Kylin user mail group: user-subscribe@kylin.apache.org
Join Kylin dev mail group: dev-subscribe@kylin.apache.org
Piotr Naszarkowski <pn...@gmail.com> 于2019年7月10日周三 上午9:01写道：
> Dear Kylin Team,
>
> I'm trying to connect Tableau (Desktop for now) to Apache Kylin using JDBC
> driver. Connection fails with the error below.
> [image: image.png]
> I know that there are limitations regarding dialect from Tableau side (
> https://onlinehelp.tableau.com/current/pro/desktop/en-us/examples_otherdatabases_jdbc.htm),
> which might be the issue however I'm not sure about it.
>
> The error messages in Tableau log files are not much of value, but I
> attach the most meaningful log entry below:
> {"ts":"2019-07-09T21:09:43.021","pid":11780,"tid":"2504","sev":"error","req":"-","sess":"-","site":"-","user":"-","k":"detailed-error-msg","e":{"category":"needs-classification","log-code":"bad0a3fa"},"v":{"details":["com.tableausoftware.jdbc.TableauJDBCException:
> Error in isConnected","Generic JDBC connection
> error","com.tableausoftware.jdbc.TableauJDBCException: Error in
> isConnected\n"],"headline":"An error occurred while communicating with
> Other Databases (JDBC).\n","shortMessage":"Bad Connection: Tableau could
> not connect to the data source.","support-help-link":"
> https://www.tableau.com/en-us/app/producthelp?build=20191.19.0213.2333&edition=pro&errorcode=&errormessage=&lang=en-us&platform=windows&type=redirect&version=2019.1
> "}}
>
> JDBC works fine with my installation from e.g. squirrelSQL.
>
> Anybody has a clue how to make it work? Do you think that there is
> something in the code of jdbc driver that can be checked/fixed or debugged?
> Is there anything you would recommend?
>
> Versions:
> Tableau Desktop 2019.1 installed on Windows
> Apache Kylin 2.6.2 installed from binaries on CentOS
> Apache Kylin jdbc driver built locally from 2.6.3 revision/tag.
>
> Thanks,
> Piotr
>
Re: Kylin and Tableau JDBC
Posted by ShaoFeng Shi <sh...@apache.org>.
Hi Piotr,
Excellent! We will have committer to review and merge the PR. Thank you!
Best regards,
Shaofeng Shi 史少锋
Apache Kylin PMC
Email: shaofengshi@apache.org
Apache Kylin FAQ: https://kylin.apache.org/docs/gettingstarted/faq.html
Join Kylin user mail group: user-subscribe@kylin.apache.org
Join Kylin dev mail group: dev-subscribe@kylin.apache.org
Piotr Naszarkowski <pn...@gmail.com> 于2019年7月12日周五 上午8:05写道：
> Dear Kylin Team,
>
> I managed to debug and resolve the issue, it's due to Avatica 1.10 missing
> implementation of AvaticaConnection.isValid method. I've fixed this here by
> upgrading Avatica to 1.12: https://github.com/apache/kylin/pull/739
>
> Please consider adding this PR to your repository when it passes all your
> tests.
>
> Thanks,
> Piotr
>
>
> wt., 9 lip 2019 o 21:25 Piotr Naszarkowski <pn...@gmail.com>
> napisał(a):
>
>> Dear Kylin Team,
>>
>> I'm trying to connect Tableau (Desktop for now) to Apache Kylin using
>> JDBC driver. Connection fails with the error below.
>> [image: image.png]
>> I know that there are limitations regarding dialect from Tableau side (
>> https://onlinehelp.tableau.com/current/pro/desktop/en-us/examples_otherdatabases_jdbc.htm),
>> which might be the issue however I'm not sure about it.
>>
>> The error messages in Tableau log files are not much of value, but I
>> attach the most meaningful log entry below:
>> {"ts":"2019-07-09T21:09:43.021","pid":11780,"tid":"2504","sev":"error","req":"-","sess":"-","site":"-","user":"-","k":"detailed-error-msg","e":{"category":"needs-classification","log-code":"bad0a3fa"},"v":{"details":["com.tableausoftware.jdbc.TableauJDBCException:
>> Error in isConnected","Generic JDBC connection
>> error","com.tableausoftware.jdbc.TableauJDBCException: Error in
>> isConnected\n"],"headline":"An error occurred while communicating with
>> Other Databases (JDBC).\n","shortMessage":"Bad Connection: Tableau could
>> not connect to the data source.","support-help-link":"
>> https://www.tableau.com/en-us/app/producthelp?build=20191.19.0213.2333&edition=pro&errorcode=&errormessage=&lang=en-us&platform=windows&type=redirect&version=2019.1
>> "}}
>>
>> JDBC works fine with my installation from e.g. squirrelSQL.
>>
>> Anybody has a clue how to make it work? Do you think that there is
>> something in the code of jdbc driver that can be checked/fixed or debugged?
>> Is there anything you would recommend?
>>
>> Versions:
>> Tableau Desktop 2019.1 installed on Windows
>> Apache Kylin 2.6.2 installed from binaries on CentOS
>> Apache Kylin jdbc driver built locally from 2.6.3 revision/tag.
>>
>> Thanks,
>> Piotr
>>
>
Re: Kylin and Tableau JDBC
Posted by Piotr Naszarkowski <pn...@gmail.com>.
Dear Kylin Team,
I managed to debug and resolve the issue, it's due to Avatica 1.10 missing
implementation of AvaticaConnection.isValid method. I've fixed this here by
upgrading Avatica to 1.12: https://github.com/apache/kylin/pull/739
Please consider adding this PR to your repository when it passes all your
tests.
Thanks,
Piotr
wt., 9 lip 2019 o 21:25 Piotr Naszarkowski <pn...@gmail.com>
napisał(a):
> Dear Kylin Team,
>
> I'm trying to connect Tableau (Desktop for now) to Apache Kylin using JDBC
> driver. Connection fails with the error below.
> [image: image.png]
> I know that there are limitations regarding dialect from Tableau side (
> https://onlinehelp.tableau.com/current/pro/desktop/en-us/examples_otherdatabases_jdbc.htm),
> which might be the issue however I'm not sure about it.
>
> The error messages in Tableau log files are not much of value, but I
> attach the most meaningful log entry below:
> {"ts":"2019-07-09T21:09:43.021","pid":11780,"tid":"2504","sev":"error","req":"-","sess":"-","site":"-","user":"-","k":"detailed-error-msg","e":{"category":"needs-classification","log-code":"bad0a3fa"},"v":{"details":["com.tableausoftware.jdbc.TableauJDBCException:
> Error in isConnected","Generic JDBC connection
> error","com.tableausoftware.jdbc.TableauJDBCException: Error in
> isConnected\n"],"headline":"An error occurred while communicating with
> Other Databases (JDBC).\n","shortMessage":"Bad Connection: Tableau could
> not connect to the data source.","support-help-link":"
> https://www.tableau.com/en-us/app/producthelp?build=20191.19.0213.2333&edition=pro&errorcode=&errormessage=&lang=en-us&platform=windows&type=redirect&version=2019.1
> "}}
>
> JDBC works fine with my installation from e.g. squirrelSQL.
>
> Anybody has a clue how to make it work? Do you think that there is
> something in the code of jdbc driver that can be checked/fixed or debugged?
> Is there anything you would recommend?
>
> Versions:
> Tableau Desktop 2019.1 installed on Windows
> Apache Kylin 2.6.2 installed from binaries on CentOS
> Apache Kylin jdbc driver built locally from 2.6.3 revision/tag.
>
> Thanks,
> Piotr
>