[KYLIN-2274] Dundas ODBC Error: SQLColAttribute unknown attr,

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: v1.6.0
• Component/s: Driver - ODBC
• Environment: Kylin 1.6.0; ODBC 1.6 64 bits; Dundas BI: 3.0.2 Windows7 64 bits
• Assignee: Dong Li
• Reporter: albertoramon
• Created: 12/Dec/16 19:35
• Updated: 31/Oct/19 13:21
• Resolved: 31/Oct/19 13:21

Description

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:

{"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'"}

_

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?