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