[
https://issues.apache.org/jira/browse/LENS-714?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14661818#comment-14661818
]
Sushil Mohanty commented on LENS-714:
-------------------------------------
All tests are running fine.
{CODE}
[INFO] ------------------------------------------------------------------------
[INFO] Reactor Summary:
[INFO]
[INFO] Lens Checkstyle Rules ............................. SUCCESS [3.202s]
[INFO] Lens .............................................. SUCCESS [0.190s]
[INFO] Lens API .......................................... SUCCESS [13.569s]
[INFO] Lens API for server and extensions ................ SUCCESS [10.614s]
[INFO] Lens Cube ......................................... SUCCESS [8:04.998s]
[INFO] Lens DB storage ................................... SUCCESS [19.327s]
[INFO] Lens Query Library ................................ SUCCESS [7.981s]
[INFO] Lens Hive Driver .................................. SUCCESS [3:41.106s]
[INFO] Lens Driver for JDBC .............................. SUCCESS [42.337s]
[INFO] Lens Elastic Search Driver ........................ SUCCESS [13.774s]
[INFO] Lens Server ....................................... SUCCESS [20:01.458s]
[INFO] Lens client ....................................... SUCCESS [45.502s]
[INFO] Lens CLI .......................................... SUCCESS [4:56.254s]
[INFO] Lens Examples ..................................... SUCCESS [4.596s]
[INFO] Lens Distribution ................................. SUCCESS [3.703s]
[INFO] Lens ML Lib ....................................... SUCCESS [3:31.587s]
[INFO] Lens ML Ext Distribution .......................... SUCCESS [8.008s]
[INFO] Lens Regression ................................... SUCCESS [3.544s]
[INFO] ------------------------------------------------------------------------
[INFO] BUILD SUCCESS
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 43:12.835s
[INFO] Finished at: Fri Aug 07 18:32:59 IST 2015
[INFO] Final Memory: 168M/1936M
[INFO] ------------------------------------------------------------------------
{CODE}
> Replace dimension tables with subquery in Columnar Rewriter
> -----------------------------------------------------------
>
> Key: LENS-714
> URL: https://issues.apache.org/jira/browse/LENS-714
> Project: Apache Lens
> Issue Type: Improvement
> Reporter: Sushil Mohanty
> Assignee: Sushil Mohanty
> Attachments: LENS-714-2.patch
>
>
> In order to optimise the JDBC sql queries, we can skip directly joining with
> the dimension tables. Instead we can create a subquery with only required
> column for a table used in the query. For eg. If column id and name are
> queried from table dim1 the query can be rewritten as
> ... inner join (select id,name from dim1) as d1 instead of ...inner join dim1
> as d1.
> For dimension tables with descent size this helps in improving performance to
> a great extent. Planning to add this in ColumnarRewriter so that columnar DBs
> can leverage this.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
