[
https://issues.apache.org/jira/browse/KYLIN-831?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Luke Han updated KYLIN-831:
---------------------------
Sprint: Sprint 42, Sprint 43 (was: Sprint 42)
> 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)
