[
https://issues.apache.org/jira/browse/LENS-438?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14679543#comment-14679543
]
Raju Bairishetti commented on LENS-438:
---------------------------------------
[LENS-651|https://issues.apache.org/jira/browse/LENS-651] fixes this issue.
> Persisted query result shows -1 rows on cli some times
> ------------------------------------------------------
>
> Key: LENS-438
> URL: https://issues.apache.org/jira/browse/LENS-438
> Project: Apache Lens
> Issue Type: Bug
> Components: client, server
> Reporter: Raju Bairishetti
> Fix For: 2.3
>
>
> If the result is persistent at server side then it is returning the number of
> rows in the file. But if result set is persisted at only dirver side and not
> at server side then it shows always -1 rows on the cli.
> Persisting the resultset from both server side and driver side
> {noformat}
> lens-shell>set lens.query.enable.persistent.resultset.indriver=true
> Set param succeeded
> lens-shell>set lens.query.enable.persistent.resultset=true
> Set param succeeded
> lens-shell>query execute select * from local_fact1
> local_fact1.dim1 local_fact1.measure2 local_fact1.measure3
> local_fact1.measure4 local_fact1.dt
> Results of query stored at :
> file:/tmp/lensreports/f63f9da7-548d-45c4-93fe-10247fa88c91.csv 24 rows
> process in (175) seconds.
> {noformat}
> persisting results at only driver side and not at server side
> {noformat}
> lens-shell>set lens.query.enable.persistent.resultset.indriver=true
> Set param succeeded
> lens-shell>set lens.query.enable.persistent.resultset=false
> Set param succeeded
> lens-shell>query execute select * from local_fact1
> local_fact1.dim1 local_fact1.measure2 local_fact1.measure3
> local_fact1.measure4 local_fact1.dt
> Results of query stored at :
> file:/tmp/lensreports/hdfsout/15d2e7ff-ee35-4728-81fb-7db58589c594 -1 rows
> process in (90) seconds.
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
