[jira] [Assigned] (KYLIN-2274) Dundas ODBC Error: SQLColAttribute unknown attr,

["Dong Li (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/KYLIN-2274?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Dong Li reassigned KYLIN-2274:
------------------------------

    Assignee: Dong Li

> 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: 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)
> 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:*  (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)