[jira] [Resolved] (KYLIN-831) Kylin report "Column 'ABC' not found in table 'TABLE' while executing SQL", when that column is FK but not define as a dimension

["Shaofeng SHI (JIRA)" <ji...@apache.org>]

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

Shaofeng SHI resolved KYLIN-831.
--------------------------------

> Kylin report "Column 'ABC' not found in table 'TABLE' while executing SQL", when that column is FK but not define as a dimension
> --------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: KYLIN-831
>                 URL: https://issues.apache.org/jira/browse/KYLIN-831
>             Project: Kylin
>          Issue Type: Bug
>          Components: Metadata, Query Engine
>    Affects Versions: v0.7.1
>            Reporter: Shaofeng SHI
>            Assignee: Shaofeng SHI
>             Fix For: v0.7.2
>
>
> I have a cube, in which "ABC" is a FK on the fact table, join with a lookup table; The "ABC" is only used in join condition, it wasn't included in dimension; The cube build is okay; After cube be build, I run a SQL query, in which the join on "ABC" is used in the SQL; But Kylin throws error, saying:
> {code}
> Caused by: org.eigenbase.sql.validate.SqlValidatorException: Column 'ABC' not found in table 'TABLE'
>         at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
>         at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
>         at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
>         at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
>         at org.eigenbase.resource.Resources$ExInstWithCause.ex(Resources.java:348)
>         at org.eigenbase.resource.Resources$ExInst.ex(Resources.java:457)
>         ... 129 more
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)