ODBC 1.6 64 bits
Dundas BI: 3.0.2 Windows7 64 bits
I tested Dundas Software
(I used Kylin Sample Cube)
(I try with SQuirreL because it uses JDBC directly, and perhaps this can helpful )
You can read list of tables
But when you try to load data of these, there is two types of errors:
Error 1: (from ODBC Log)
[INFO ] [2016-12-06.19:05:30]SELECT * FROM "DEFAULT"."KYLIN_CAL_DT" WHERE 1 = 2
[INFO ] [2016-12-06.19:05:30]Successfully done executing the query
[FATAL] [2016-12-06.19:05:30]SQLColAttribute unknown attr, ColNum: 1, FldID: 1211
This query works OK on Kylin UI and SQuirriel:
Error 2: (from ODBC Log)
[ERROR][2016-12-06.19:30:27]The REST query request failed, the error message is: Error while executing SQL "SELECT T."USER_DEFINED_FIELD1" AS "TE0", T."SITE_ID" AS "TE1" FROM "DEFAULT"."KYLIN_CAL_DT" T GROUP BY T."USER_DEFINED_FIELD1", T."SITE_ID" ORDER BY T."USER_DEFINED_FIELD1", T."SITE_ID"": From line 1, column 106 to line 1, column 126: Column 'USER_DEFINED_FIELD1' not found in table 'T'
This Query fails on Kylin UI:
ERROR: Column 'USER_DEFINED_FIELD1' not found in table 'T'
This Query fails on SQuirrel:
_ERROR: ava.sql.SQLException: java.io.IOException: POST failed, error code 500 and response:
The problem on Q2 is:
... was very simple, somebody / Dundas?? is crossing columns with their tables tables
these columns are of other table .... why? who?