[
https://issues.apache.org/jira/browse/LENS-114?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14243972#comment-14243972
]
Sushil Mohanty commented on LENS-114:
-------------------------------------
Currently only fact keys those are part of from clause were considered while
building fact subquery. It should also check select and where clause for any
fact key and add in the inner subquery. Along with this fact filters part of
where or join clauses should pushed down to fact subquery to reduce fact result
set for further joining with dimensions.
> JDBC: filters on the cube are not getting picked by the inner query
> -------------------------------------------------------------------
>
> Key: LENS-114
> URL: https://issues.apache.org/jira/browse/LENS-114
> Project: Apache Lens
> Issue Type: Bug
> Components: driver-jdbc
> Reporter: Raghavendra Singh
> Assignee: Sushil Mohanty
> Fix For: 2.0
>
>
> queries like:-
> cube select dim.a,cube.b from cube inner join dim where
> time_range_in(col,from,to) AND cube.b2 = value
> fail with unknown column cube.b2
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
