[ https://issues.apache.org/jira/browse/KYLIN-2274?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
albertoramon updated KYLIN-2274: -------------------------------- Description: I tested [Dundas Software|http://www.dundas.com/dundas-bi] (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 :) !dundas.png! But when you try to load data of these, there is two types of errors: *Error 1:* (from ODBC Log) {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} This query works OK on Kylin UI and SQuirriel: !Q1ON SQuirrel.png! \\ \\ \\ *Error 2:* (from ODBC Log) {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 Query fails on Kylin UI: !Q2onLylinUI.png! _ERROR: Column 'USER_DEFINED_FIELD1' not found in table 'T'_ This Query fails on SQuirrel: !Q2onSQuirrel.png! _ERROR: ava.sql.SQLException: java.io.IOException: POST failed, error code 500 and response: {"url":"http://172.17.0.2:7070/kylin/api/query","exception":"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 4, column 13 to line 4, column 33: Column 'USER_DEFINED_FIELD1' not found in table 'T'"}_ was: I tested [Dundas Software|http://www.dundas.com/dundas-bi] (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 :) !dundas.png! But when you try to load data of these, there is two types of errors: *Error 1:* (from ODBC Log) {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} This query works OK on Kylin UI and SQuirriel: !Q1ON SQuirrel.png! *Error 2:* (from ODBC Log) {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 Query fails on Kylin UI: !Q2onLylinUI.png! _ERROR: Column 'USER_DEFINED_FIELD1' not found in table 'T'_ This Query fails on SQuirrel: !Q2onSQuirrel.png! _ERROR: ava.sql.SQLException: java.io.IOException: POST failed, error code 500 and response: {"url":"http://172.17.0.2:7070/kylin/api/query","exception":"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 4, column 13 to line 4, column 33: Column 'USER_DEFINED_FIELD1' not found in table 'T'"}_ > 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 > Assignee: Dong Li > Attachments: Q1ON SQuirrel.png, Q2onLylinUI.png, Q2onSQuirrel.png, > dundas.png, odbc-2016-12-06-19-01-51.log > > > I tested [Dundas Software|http://www.dundas.com/dundas-bi] > (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 :) > !dundas.png! > But when you try to load data of these, there is two types of errors: > *Error 1:* (from ODBC Log) > {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} > This query works OK on Kylin UI and SQuirriel: > !Q1ON SQuirrel.png! > \\ > \\ > \\ > *Error 2:* (from ODBC Log) > {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 Query fails on Kylin UI: > !Q2onLylinUI.png! > _ERROR: Column 'USER_DEFINED_FIELD1' not found in table 'T'_ > This Query fails on SQuirrel: > !Q2onSQuirrel.png! > _ERROR: ava.sql.SQLException: java.io.IOException: POST failed, error code > 500 and response: > {"url":"http://172.17.0.2:7070/kylin/api/query","exception":"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 4, column 13 to line 4, > column 33: Column 'USER_DEFINED_FIELD1' not found in table 'T'"}_ -- This message was sent by Atlassian JIRA (v6.3.4#6332)