[jira] [Commented] (LENS-614) Support single columns as expressions - more like alias

["Archana H (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/LENS-614?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15458397#comment-15458397 ] 

Archana H commented on LENS-614:
--------------------------------

new expression:
    <expression name="store_sales_expr" _type="DOUBLE" display_string="Single Field Expr">
      <expr_spec expr="store_sales"/>
    </expression>

cube select product_id, store_sales_expr from sales where time_range_in(order_time, '2015-04-11-00', '2015-04-13-00')

Final rewritten query for driver: jdbc/jdbc1 is: SELECT (sales.product_id), sum((sales.store_sales)) FROM exp_yoda.mydb_sales_aggr_fact2 sales WHERE (((sales.order_time) between '2015-04-11 00:00:00' and '2015-04-12 00:00:00')) GROUP BY (sales.product_id)


> Support single columns as expressions - more like alias
> -------------------------------------------------------
>
>                 Key: LENS-614
>                 URL: https://issues.apache.org/jira/browse/LENS-614
>             Project: Apache Lens
>          Issue Type: Improvement
>          Components: cube
>            Reporter: Amareshwari Sriramadasu
>            Assignee: Amareshwari Sriramadasu
>             Fix For: 2.6
>
>         Attachments: LENS-614.2.patch, LENS-614.3.patch
>
>
> Right now seeing issues with single column expressions.
> It is not putting aggregate around if the column is an expression. Also not replacing alias correctly if an alias is passed.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)