You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@lens.apache.org by "Rajat Khandelwal (JIRA)" <ji...@apache.org> on 2015/08/10 09:06:45 UTC
[jira] [Resolved] (LENS-438) Persisted query result shows -1 rows
on cli some times
[ https://issues.apache.org/jira/browse/LENS-438?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rajat Khandelwal resolved LENS-438.
-----------------------------------
Resolution: Fixed
fixed through LENS-651
> 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)