Arshad Matin created LENS-363:
---------------------------------

             Summary: "CREATE FUNCTION" is not working with 
lens.query.enable.persistent.resultset=true
                 Key: LENS-363
                 URL: https://issues.apache.org/jira/browse/LENS-363
             Project: Apache Lens
          Issue Type: Bug
            Reporter: Arshad Matin
            Priority: Critical


create function is not working. Query is running for ever
{noformat}
lens-shell>query execute CREATE TEMPORARY FUNCTION sleep AS 'hive.udf.SampleUdf'
{noformat}

Logs
{noformat}
27 Feb 2015 09:39:21,430 [StatusPoller] INFO  
org.apache.lens.server.query.QueryExecutionServiceImpl  - Polling status for 
de8da592-81ac-4e5d-bb7b-345a9c39e20d
27 Feb 2015 09:39:22,440 [StatusPoller] INFO  
org.apache.lens.server.query.QueryExecutionServiceImpl  - Polling status for 
de8da592-81ac-4e5d-bb7b-345a9c39e20d
27 Feb 2015 09:39:23,450 [StatusPoller] INFO  
org.apache.lens.server.query.QueryExecutionServiceImpl  - Polling status for 
de8da592-81ac-4e5d-bb7b-345a9c39e20d
27 Feb 2015 09:39:24,460 [StatusPoller] INFO  
org.apache.lens.server.query.QueryExecutionServiceImpl  - Polling status for 
de8da592-81ac-4e5d-bb7b-345a9c39e20d
27 Feb 2015 09:39:25,470 [StatusPoller] INFO  
org.apache.lens.server.query.QueryExecutionServiceImpl  - Polling status for 
de8da592-81ac-4e5d-bb7b-345a9c39e20d
27 Feb 2015 09:39:26,480 [StatusPoller] INFO  
org.apache.lens.server.query.QueryExecutionServiceImpl  - Polling status for 
de8da592-81ac-4e5d-bb7b-345a9c39e20d
27 Feb 2015 09:39:27,490 [StatusPoller] INFO  
org.apache.lens.server.query.QueryExecutionServiceImpl  - Polling status for 
de8da592-81ac-4e5d-bb7b-345a9c39e20d
27 Feb 2015 09:39:28,500 [StatusPoller] INFO  
org.apache.lens.server.query.QueryExecutionServiceImpl  - Polling status for 
de8da592-81ac-4e5d-bb7b-345a9c39e20d
27 Feb 2015 09:39:29,510 [StatusPoller] INFO  
org.apache.lens.server.query.QueryExecutionServiceImpl  - Polling status for 
de8da592-81ac-4e5d-bb7b-345a9c39e20d
{noformat}

It is in EXECUTED state instead of SUCCESSFUL
{noformat}
lens-shell>query status de8da592-81ac-4e5d-bb7b-345a9c39e20d
Status : EXECUTED
Message : Query is successful!
Progress : 1.0
Progress Message : 
[{"type":"FUNC","taskId":"Stage-0","externalHandle":"Stage-0","taskState":"FINISHED_STATE"}]
{noformat}

The query is working after setting the persistent resultset off
{noformat}
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>add jar /home/users/dataqa/hiveudftest-1.0-SNAPSHOT.jar
Add resource succeeded
lens-shell>query execute CREATE TEMPORARY FUNCTION sleep AS 'hive.udf.SampleUdf'
0 rows process in (1) seconds.

lens-shell>
{noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to