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)