You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@lens.apache.org by "Arshad Matin (JIRA)" <ji...@apache.org> on 2015/02/04 17:29:34 UTC
[jira] [Commented] (LENS-148) Persisted query result shows 0 rows
returned on cli
[ https://issues.apache.org/jira/browse/LENS-148?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14305449#comment-14305449 ]
Arshad Matin commented on LENS-148:
-----------------------------------
*Validation*
{noformat}
lens-shell>set lens.query.enable.persistent.resultset=true
Set param succeeded
lens-shell>set lens.query.enable.persistent.resultset.indriver=true
Set param succeeded
lens-shell>query execute cube select dim1, measure2 from sample_cube where time_range_in(dt, '2014-06-24-23', '2014-06-26-01')
sample_cube.dim1 _c1
Results of query stored at : hdfs://lens/tmp/lensreports/c7061f41-71e4-4c04-8e3a-007cc435be1a.csv 8 rows process in (23) seconds.
lens-shell>
lens:~$ hadoop fs -cat hdfs://lens/tmp/lensreports/c7061f41-71e4-4c04-8e3a-007cc435be1a.csv
"sample_cube.dim1","_c1"
"21","2600"
"24","10400"
"27","18200"
"22","5200"
"25","13000"
"28","20800"
"23","7800"
"26","15600"
Total rows:8
{noformat}
> Persisted query result shows 0 rows returned on cli
> ---------------------------------------------------
>
> Key: LENS-148
> URL: https://issues.apache.org/jira/browse/LENS-148
> Project: Apache Lens
> Issue Type: Bug
> Components: client, server
> Reporter: Amareshwari Sriramadasu
> Assignee: Raju Bairishetti
> Fix For: 2.0
>
> Attachments: LENS-148.patch
>
>
> Here is run :
> {noformat}
> lens-shell>set lens.query.enable.persistent.resultset=true
> Set param succeeded
> lens-shell>set lens.query.enable.persistent.resultset.indriver=true
> Set param succeeded
> lens-shell>query execute cube select id,name from sample_db_dim
> ID NAME
> Results of query stored at : file:/tmp/lensreports/c0f59e29-8637-48c0-8244-bba9f1905bf1.csv 0 rows process in (8) seconds.
> lens-shell>close
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)