[
https://issues.apache.org/jira/browse/LENS-325?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14325361#comment-14325361
]
Sharad Agarwal commented on LENS-325:
-------------------------------------
With enabling the persistent resultset:
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
Result formatting failed! cause:File
file:/tmp/lensreports/hdfsout/a4b91590-5492-42c4-84bc-99554565bc31 does not
exist
lens-shell>
-----------------------
Disabling the persistent resultset and indriver, runs the query correctly
lens-shell>set lens.query.enable.persistent.resultset=false
Set param succeeded
lens-shell>set lens.query.enable.persistent.resultset.indriver=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
21 100 100 100.0 2014-06-24-23
22 200 200 200.0 2014-06-24-23
23 300 300 300.0 2014-06-24-23
24 400 400 400.0 2014-06-24-23
25 500 500 500.0 2014-06-24-23
26 600 600 600.0 2014-06-24-23
27 700 700 700.0 2014-06-24-23
28 800 800 800.0 2014-06-24-23
21 2400 100 100.0 2014-06-25
22 4800 200 200.0 2014-06-25
23 7200 300 300.0 2014-06-25
24 9600 400 400.0 2014-06-25
25 12000 500 500.0 2014-06-25
26 14400 600 600.0 2014-06-25
27 16800 700 700.0 2014-06-25
28 19200 800 800.0 2014-06-25
21 100 100 100.0 2014-06-26-00
22 200 200 200.0 2014-06-26-00
23 300 300 300.0 2014-06-26-00
24 400 400 400.0 2014-06-26-00
25 500 500 500.0 2014-06-26-00
26 600 600 600.0 2014-06-26-00
27 700 700 700.0 2014-06-26-00
28 800 800 800.0 2014-06-26-00
21 100 100 100.0 latest
22 200 200 200.0 latest
23 300 300 300.0 latest
24 400 400 400.0 latest
25 500 500 500.0 latest
26 600 600 600.0 latest
27 700 700 700.0 latest
28 800 800 800.0 latest
32 rows process in (3) seconds.
lens-shell>
> Wrong url of the persistent query result
> ----------------------------------------
>
> Key: LENS-325
> URL: https://issues.apache.org/jira/browse/LENS-325
> Project: Apache Lens
> Issue Type: Bug
> Reporter: Sharad Agarwal
>
> Using the default configs:
> lens-shell>set lens.query.enable.persistent.resultset=false
> Set param succeeded
> lens-shell>set lens.query.enable.persistent.resultset.indriver=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/hdfsout/179095f1-f692-4850-93d8-402bbe37ba32 -1 rows
> process in (61) seconds.
> The result is in HDFS but the url is wrong
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)