I am testing 2.0 beta using the sample data set using Tableau 10.2, and SQL server 2016 linked server.
--ISSUE1: In Tableau 10.2, with custom sql, the preview works, but the full query returns only 1 row with nulls for the following sample query: select part_dt, sum(price) as total_selled, count(distinct seller_id) as sellers from kylin_sales group by part_dt order by part_dt --ISSUE2: After adding Kylin as a linked server using Microsoft OLE provider for ODBC and pre-configured DSN "KYLIN". For whatever reason, there are 5 defaultCatalog displayed there. When expanded, multiple duplicated ACCOUNT tables are displayed. When running the following linked server query, got error message, no row returned, but column header was retrieved. Is the 2.0 beta issue, or 1.6 version of ODBC driver issue? Do you plan to release a 2.0 version of ODBC driver? I use the linked server approach so that I can use Superset with pymssql and extra sql server security for querying Kylin OLAP data. I appreciate your help. select * from openquery(KYLIN, 'select part_dt, sum(price) as total_selled, count(distinct seller_id) as sellers from kylin_sales group by part_dt order by part_dt') [image: Inline image 3] Msg 7399, Level 16, State 1, Line 1 The OLE DB provider "MSDASQL" for linked server "KYLIN" reported an error. The provider did not give any information about the error. Msg 7330, Level 16, State 2, Line 1 Cannot fetch a row from OLE DB provider "MSDASQL" for linked server "KYLIN". [image: Inline image 2][image: Inline image 1]
