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

Jaideep Dhok commented on LENS-34:
----------------------------------

Query with aggregate also going through
query - select count (distinct dim1) from testCube where " + twoDaysRange;

Rewritten query - 
SELECT count( distinct ( testcube . dim1 )) FROM *TestQueryRewrite.c1_summary1* 
testcube WHERE (((((((((((((((((((((((((((( testcube . dt ) =  '2014-12-20-14' 
) or (( testcube . dt ) =  '2014-12-20-15' )) or (( testcube . dt ) =  
'2014-12-20-16' )) or (( testcube . dt ) =  '2014-12-20-17' )) or (( testcube . 
dt ) =  '2014-12-20-18' )) or (( testcube . dt ) =  '2014-12-20-19' )) or (( 
testcube . dt ) =  '2014-12-20-20' )) or (( testcube . dt ) =  '2014-12-20-21' 
)) or (( testcube . dt ) =  '2014-12-20-22' )) or (( testcube . dt ) =  
'2014-12-20-23' )) or (( testcube . dt ) =  '2014-12-21' )) or (( testcube . dt 
) =  '2014-12-22-00' )) or (( testcube . dt ) =  '2014-12-22-01' )) or (( 
testcube . dt ) =  '2014-12-22-02' )) or (( testcube . dt ) =  '2014-12-22-03' 
)) or (( testcube . dt ) =  '2014-12-22-04' )) or (( testcube . dt ) =  
'2014-12-22-05' )) or (( testcube . dt ) =  '2014-12-22-06' )) or (( testcube . 
dt ) =  '2014-12-22-07' )) or (( testcube . dt ) =  '2014-12-22-08' )) or (( 
testcube . dt ) =  '2014-12-22-09' )) or (( testcube . dt ) =  '2014-12-22-10' 
)) or (( testcube . dt ) =  '2014-12-22-11' )) or (( testcube . dt ) =  
'2014-12-22-12' )) or (( testcube . dt ) =  '2014-12-22-13' ))))
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 114.053 sec - 
in org.apache.lens.cube.parse.TestCubeRewriter


> dim-attribute query on cube
> ---------------------------
>
>                 Key: LENS-34
>                 URL: https://issues.apache.org/jira/browse/LENS-34
>             Project: Apache Lens
>          Issue Type: Task
>          Components: cube
>            Reporter: Amareshwari Sriramadasu
>            Assignee: Jaideep Dhok
>             Fix For: 2.0
>
>
> If only dim-attributes are queried from cube, cube query rewriter should pick 
>  facts with least weight and even an aggregated fact if the dim-attribute is 
> available in the aggregated fact.
> This issue to verify the above behavior by writing a unit test and fix the 
> behavior if it is different from above.



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

Reply via email to