[
https://issues.apache.org/jira/browse/LENS-730?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15259514#comment-15259514
]
Amareshwari Sriramadasu commented on LENS-730:
----------------------------------------------
No luck with pre-commit build still. Local build passed.
----
[INFO] ------------------------------------------------------------------------
[INFO] Reactor Summary:
[INFO]
[INFO] Lens Checkstyle Rules ............................. SUCCESS [1.590s]
[INFO] Lens .............................................. SUCCESS [2.761s]
[INFO] Lens API .......................................... SUCCESS [21.032s]
[INFO] Lens API for server and extensions ................ SUCCESS [16.007s]
[INFO] Lens Cube ......................................... SUCCESS [17:18.623s]
[INFO] Lens DB storage ................................... SUCCESS [15.635s]
[INFO] Lens Query Library ................................ SUCCESS [11.351s]
[INFO] Lens Hive Driver .................................. SUCCESS [2:29.659s]
[INFO] Lens Driver for JDBC .............................. SUCCESS [31.408s]
[INFO] Lens Elastic Search Driver ........................ SUCCESS [12.938s]
[INFO] Lens Server ....................................... SUCCESS [14:27.967s]
[INFO] Lens client ....................................... SUCCESS [29.589s]
[INFO] Lens CLI .......................................... SUCCESS [2:33.229s]
[INFO] Lens Examples ..................................... SUCCESS [8.627s]
[INFO] Lens Ship Jars to Distributed Cache ............... SUCCESS [0.692s]
[INFO] Lens Distribution ................................. SUCCESS [8.924s]
[INFO] Lens ML Lib ....................................... SUCCESS [1:10.732s]
[INFO] Lens ML Ext Distribution .......................... SUCCESS [1.435s]
[INFO] Lens Regression ................................... SUCCESS [9.415s]
[INFO] Lens UI ........................................... SUCCESS [45.939s]
[INFO] ------------------------------------------------------------------------
[INFO] BUILD SUCCESS
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 41:38.260s
[INFO] Finished at: Wed Apr 27 03:01:27 UTC 2016
[INFO] Final Memory: 166M/2518M
[INFO] ------------------------------------------------------------------------
> 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
>
> Attachments: LENS-730.2.patch
>
>
> 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)
