Raghavendra Singh created LENS-377:
--------------------------------------
Summary: Result Formatter throws error for jdbc queries with
format_number
Key: LENS-377
URL: https://issues.apache.org/jira/browse/LENS-377
Project: Apache Lens
Issue Type: Bug
Reporter: Raghavendra Singh
Assignee: Sushil Mohanty
the issue occurs when persistent result set is enabled:-
without persistent result set:-
{CODE}
lens-shell>use ex1
Successfully switched to ex1
lens-shell>query execute cube select format_number(id,2),name from sample_dim
format(( sample_dim . id ), 2 ) name
1.00 dummy_one
2.00 dummy_two
3.00 dummy_three
3 rows process in (6) seconds.
{CODE}
with persistent result set:-
{CODE}
lens-shell>set lens.query.enable.persistent.resultset=true
Set param succeeded
lens-shell>set lens.query.enable.persistent.resultset.indriver=false
Set param succeeded
lens-shell>query execute cube select format_number(id,2),name from sample_dim
Result formatting failed! cause:Index: 2, Size: 2
{CODE}
lensserver.log:-
{CODE}
19 Nov 2014 10:44:28,357 [QuerySubmitter] INFO hive.metastore - Connected to
metastore.
19 Nov 2014 10:44:28,416 [QuerySubmitter] INFO
org.apache.lens.driver.jdbc.ColumnarSQLRewriter - @@@Query not eligible for
inner subquery rewrite
19 Nov 2014 10:44:28,416 [QuerySubmitter] INFO
org.apache.lens.driver.jdbc.ColumnarSQLRewriter - Input Query : SELECT
format_number(( sample_dim . id ), 2 ), ( sample_dim . name ) FROM
ex1.mydb_dim_table4 sample_dim
19 Nov 2014 10:44:28,416 [QuerySubmitter] INFO
org.apache.lens.driver.jdbc.ColumnarSQLRewriter - Rewritten Query : select
format(( sample_dim . id ), 2 ), ( sample_dim . name ) from mydb_dim_table4
sample_dim
19 Nov 2014 10:44:28,417 [QuerySubmitter] INFO
org.apache.lens.driver.jdbc.JDBCDriver - ExecuteAsync:
46c4f31d-a177-463c-b81c-e38df100d04f
19 Nov 2014 10:44:28,417 [QuerySubmitter] INFO
org.apache.lens.server.query.QueryExecutionServiceImpl - Launched query
46c4f31d-a177-463c-b81c-e38df100d04f
19 Nov 2014 10:44:28,417 [Grizzly-worker(5)] INFO
org.apache.lens.server.query.QueryExecutionServiceImpl - Updating status for
46c4f31d-a177-463c-b81c-e38df100d04f
19 Nov 2014 10:44:28,475 [Grizzly-worker(6)] INFO
org.apache.lens.server.AuthenticationFilter - Request from user: null,
path=/queryapi/queries/46c4f31d-a177-463c-b81c-e38df100d04f
19 Nov 2014 10:44:28,477 [Grizzly-worker(6)] INFO
org.apache.lens.server.query.QueryExecutionServiceImpl - Updating status for
46c4f31d-a177-463c-b81c-e38df100d04f
19 Nov 2014 10:44:28,478 [event_processor_thread] INFO
org.apache.lens.server.query.ResultFormatter - Result formatter for
46c4f31d-a177-463c-b81c-e38df100d04f
19 Nov 2014 10:44:28,486 [event_processor_thread] INFO
org.apache.lens.server.query.ResultFormatter - Created result
formatter:org.apache.lens.lib.query.FileSerdeFormatter
19 Nov 2014 10:44:28,659 [event_processor_thread] WARN
org.apache.lens.server.query.ResultFormatter - Exception while formatting
result for 46c4f31d-a177-463c-b81c-e38df100d04f
java.lang.IndexOutOfBoundsException: Index: 2, Size: 2
at java.util.ArrayList.rangeCheck(ArrayList.java:571)
at java.util.ArrayList.get(ArrayList.java:349)
at org.apache.lens.lib.query.CSVSerde.initialize(CSVSerde.java:156)
at
org.apache.lens.lib.query.FileSerdeFormatter.initOutputSerde(FileSerdeFormatter.java:91)
at
org.apache.lens.lib.query.FileSerdeFormatter.init(FileSerdeFormatter.java:70)
at
org.apache.lens.server.query.ResultFormatter.formatOutput(ResultFormatter.java:108)
at
org.apache.lens.server.query.ResultFormatter.process(ResultFormatter.java:69)
at
org.apache.lens.server.query.ResultFormatter.process(ResultFormatter.java:44)
at
org.apache.lens.server.api.events.AsyncEventListener$2.run(AsyncEventListener.java:105)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1146)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:701)
{CODE}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
