[
https://issues.apache.org/jira/browse/LENS-730?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Amareshwari Sriramadasu updated LENS-730:
-----------------------------------------
Description:
We saw couple of issues with aliases in multi fact queries.
* cube select func1(col1), func2(col1), m1,m2 from cube where time_range_in(dt,
now.day - 2days, now) writes the query as follows :
select COALESCE(mq1.col1, mq2.col1) col1, COALESCE(mq1.col1, mq2.col1) col1,
mq1.m1, mq2.m2 from
(select func1(col1) col1, func2(col1) col1, m1 from fact1 where ...) mq1
full outer join
(select func1(col1) col1, func2(col1) col1, m2 from fact2 where ...) mq2
on
mq1.col1 <=> mq2.col1 and mq1.col1 <=>mq2.col1
* Another was the case of the alias of the column is same as the field selected.
was:
We saw couple of issues with aliases in multi fact queries.
* cube select func1(col1), func2(col1), m1,m2 from cube where time_range_in(dt,
now.day - 2days, now) writes the query as follows :
select COALESCE(mq1.col1, mq2.col1) request_time, COALESCE(mq1.col1, mq2.col1)
request_time, mq1.m1, mq2.m2 from
(select func1(col1) col1, func2(col1) col1, m1 from fact1 where ...) mq1
full outer join
(select func1(col1) col1, func2(col1) col1, m2 from fact2 where ...) mq2
on
mq1.col1 <=> mq2.col1 and mq1.col1 <=>mq2.col1
* Another was the case of the alias of the column is same as the field selected.
> Issues with column aliases in multifact query
> ---------------------------------------------
>
> Key: LENS-730
> URL: https://issues.apache.org/jira/browse/LENS-730
> Project: Apache Lens
> Issue Type: Bug
> Components: cube
> Reporter: Amareshwari Sriramadasu
> Assignee: Amareshwari Sriramadasu
> Fix For: 2.6
>
>
> We saw couple of issues with aliases in multi fact queries.
> * cube select func1(col1), func2(col1), m1,m2 from cube where
> time_range_in(dt, now.day - 2days, now) writes the query as follows :
> select COALESCE(mq1.col1, mq2.col1) col1, COALESCE(mq1.col1, mq2.col1) col1,
> mq1.m1, mq2.m2 from
> (select func1(col1) col1, func2(col1) col1, m1 from fact1 where ...) mq1
> full outer join
> (select func1(col1) col1, func2(col1) col1, m2 from fact2 where ...) mq2
> on
> mq1.col1 <=> mq2.col1 and mq1.col1 <=>mq2.col1
> * Another was the case of the alias of the column is same as the field
> selected.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
