[
https://issues.apache.org/jira/browse/LENS-330?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Amareshwari Sriramadasu updated LENS-330:
-----------------------------------------
Assignee: Amareshwari Sriramadasu
Status: Patch Available (was: Open)
Testing done :
mvn clean package -DskipTests passes. Did not run all tests because default
value is overridden in tests, so it wont have any effect.
Verified examples with both JDBCDriver and HiveDriver queries:
{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 cube select id,name from sample_dim
ID NAME
Results of query stored at :
file:/tmp/lensreports/08ae25c0-5f00-4b41-bf37-c3c904e721bf.csv 3 rows process
in (1) seconds.
lens-shell>query execute cube select sample_dim.name, sample_dim2.name from
sample_dim
sample_dim.name sample_dim2.name
Results of query stored at :
file:/tmp/lensreports/f60de658-d6f9-423c-a09d-98447da20b95.csv 7 rows process
in (15) seconds.
lens-shell>set lens.query.enable.persistent.resultset=false
Set param succeeded
lens-shell>query execute cube select id,name from sample_dim
ID NAME
1 first
2 second
3 third
3 rows process in (0) seconds.
lens-shell>query execute cube select sample_dim.name, sample_dim2.name from
sample_dim
sample_dim.name sample_dim2.name
Results of query stored at :
file:/tmp/lensreports/hdfsout/e6bfcb87-f110-46c8-aa29-ae65571a582c -1 rows
process in (9) seconds.
lens-shell>set lens.query.enable.persistent.resultset.indriver=false
Set param succeeded
lens-shell>query execute cube select id,name from sample_dim
ID NAME
1 first
2 second
3 third
3 rows process in (0) seconds.
lens-shell>query execute cube select sample_dim.name, sample_dim2.name from
sample_dim
sample_dim.name sample_dim2.name
first eleven
second twelve
third thirteen
fourth fourteen
fifth fifteen
six sixteen
eight eighteen
7 rows process in (9) seconds.
lens-shell>
{noformat}
> Change default value of "lens.query.result.parent.dir"
> ------------------------------------------------------
>
> Key: LENS-330
> URL: https://issues.apache.org/jira/browse/LENS-330
> Project: Apache Lens
> Issue Type: Bug
> Reporter: Arshad Matin
> Assignee: Amareshwari Sriramadasu
> Attachments: LENS-330.patch
>
>
> Currently the default value of "lens.query.result.parent.dir" is
> "/tmp/lensreports" which will fail in a scenario where HiveInputFormat is
> being used and data is in local, since it is not a fully qualified path name,
> hive will persist the result in hdfs while Lens result formatter will try to
> get the results from local.
> Default value of "lens.query.result.parent.dir" must be changed to fully
> qualified path i.e. "file:///tmp/lensreports"
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
