You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@lens.apache.org by "Raju Bairishetti (JIRA)" <ji...@apache.org> on 2015/03/25 02:32:52 UTC

[jira] [Created] (LENS-438) Persisted query result shows -1 rows on cli some times

Raju Bairishetti created LENS-438:
-------------------------------------

             Summary: 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.1


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)