albertoramon created KYLIN-2274: ----------------------------------- Summary: Dundas ODBC Error: SQLColAttribute unknown attr, Key: KYLIN-2274 URL: https://issues.apache.org/jira/browse/KYLIN-2274 Project: Kylin Issue Type: Bug Components: Driver - ODBC Affects Versions: v1.6.0 Environment: Kylin 1.6.0 ODBC 1.6 64 bits Dundas BI: 3.0.2 Windows7 64 bits Reporter: albertoramon
I tested [Dundas Software|http://www.dundas.com/dundas-bi] (I used Kylin Sample Cube) You can read list of tables, but when you try to load data of these, there is two types of errors: *Error 1:* (This query works OK on Kylin UI) {quote} [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 {quote} *Error 2:* {quote} [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' {quote} -- This message was sent by Atlassian JIRA (v6.3.4#6332)