[ 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)