You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "Yifan Zhang (JIRA)" <ji...@apache.org> on 2017/02/13 07:23:41 UTC
[jira] [Commented] (KYLIN-2274) Dundas ODBC Error: SQLColAttribute
unknown attr,
[ https://issues.apache.org/jira/browse/KYLIN-2274?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15863278#comment-15863278 ]
Yifan Zhang commented on KYLIN-2274:
------------------------------------
For Q1, have you tried with other BI tools. I'm thinking if it's Dundas spec problem.
I did not see such problem with power BI (see following odbc log)
--------------------------------------------------------------------------------
Log start: Mon Feb 13 11:07:36 2017
[INFO ][2017-02-13.11:07:36]SQLFreeStmt called, 75576512 with option 0
[INFO ][2017-02-13.11:07:36]================================================================
[INFO ][2017-02-13.11:07:36]start exec the query:
[INFO ][2017-02-13.11:07:36]SELECT * FROM "DEFAULT"."KYLIN_CAL_DT" WHERE 1 = 2
[INFO ][2017-02-13.11:07:37]Successfully done executing the query
[INFO ][2017-02-13.11:07:37]Last row of current query has been fetched
[INFO ][2017-02-13.11:07:37]SQLFreeHandle called, Handle Type: 3, Handle: 75576512
[INFO ][2017-02-13.11:07:37]SQLDisconnect called
[INFO ][2017-02-13.11:07:37]SQLFreeHandle called, Handle Type: 2, Handle: 75552128
[INFO ][2017-02-13.11:07:37]SQLFreeHandle called, Handle Type: 1, Handle: 5019184
> 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, Q1ON SQuirrel.png, Q2onLylinUI.png, Q2onSQuirrel.png, TheProblem.png
>
>
> 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'"}_
> *The problem on Q2 is:*
> ... was very simple, somebody / Dundas?? is crossing columns with their tables tables
> !TheProblem.png!
> these columns are of other table :) .... why? who?
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)