Thanks for reporting. Let me try reproduce. On Thu, Apr 13, 2017 at 9:51 PM, Junhai Guo <[email protected]> wrote:
> 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] >
