[ 
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)

Reply via email to