[
https://issues.apache.org/jira/browse/LENS-114?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14244163#comment-14244163
]
Sushil Mohanty commented on LENS-114:
-------------------------------------
{CODE}
Input Query :
SELECT (dim1 . date) date , sum((f . msr1)) msr1 , (dim2 . name) dim2_name
FROM fact f
INNER JOIN dim1 dim1 ON f.dim1_id = dim1.id
AND f.m2 = '1234'
INNER JOIN dim2 dim2 ON f.dim2_id = dim2.id
AND f.m3 > 3000
WHERE ((dim1 . date) = '2014-11-25 00:00:00')
AND f.m4 IS NOT NULL
GROUP BY (dim1 . date), (dim2 . name)
{CODE}
{CODE}
Final Rewritten Query :
SELECT (dim1___dim1 . date) date , sum(sum_fact___f_msr1) msr1 , (dim2___dim2 .
name) dim2_name
FROM
(SELECT fact___f.dim2_id,
fact___f.dim1_id,
fact___f.m4,
fact___f.m3,
fact___f.m2,
sum((fact___f . msr1)) AS sum_fact___f_msr1
FROM fact fact___f
WHERE (fact___f . m4) IS NOT NULL
AND ((fact___f . m2) = '1234')
AND ((fact___f . m3) > 3000)
AND fact___f.dim1_id IN
(SELECT dim1 .id
FROM dim1
WHERE ((dim1. date) = '2014-11-25 00:00:00'))
GROUP BY fact___f.dim2_id,
fact___f.dim1_id,
fact___f.m4,
fact___f.m3,
fact___f.m2) fact___f
INNER JOIN dim1 dim1___dim1 ON (((fact___f . dim1_id) = (dim1___dim1 . id))
AND ((fact___f . m2) = '1234'))
INNER JOIN dim2 dim2___dim2 ON (((fact___f . dim2_id) = (dim2___dim2 . id))
AND ((fact___f . m3) > 3000))
WHERE (((dim1___dim1 . date) = '2014-11-25 00:00:00')
AND (fact___f . m4) IS NOT NULL)
GROUP BY (dim1___dim1 . date), (dim2___dim2 . name)
{CODE}
> 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)
