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/08/25 10:44:45 UTC
[jira] [Closed] (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 ]
Arshad Matin closed LENS-438.
-----------------------------
> 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)