[jira] [Created] (SPARK-16563) Spark SQL thrift server fetchResults return empty for ExecuteStatement operation for repeat calls

["Gu Huiqin Alice (JIRA)" <ji...@apache.org>]

Gu Huiqin Alice created SPARK-16563:
---------------------------------------

             Summary: Spark SQL thrift server fetchResults return empty for ExecuteStatement operation for repeat calls
                 Key: SPARK-16563
                 URL: https://issues.apache.org/jira/browse/SPARK-16563
             Project: Spark
          Issue Type: Bug
          Components: SQL
    Affects Versions: 1.6.2
            Reporter: Gu Huiqin Alice
            Priority: Minor


Repeat calling FetchResults(... orientation=FetchOrientation.FETCH_FIRST ..) of spark sql thrift service will return empty set after calling ExecuteStatement of TCLIService. 

The bug exist in *function public RowSet getNextRowSet(FetchOrientation orientation, long maxRows)*
https://github.com/apache/spark/blob/02c8072eea72425e89256347e1f373a3e76e6eba/sql/hive-thriftserver/src/main/java/org/apache/hive/service/cli/operation/SQLOperation.java#L332

The iterator for geting result can be used for only once, so repeat calling FetchResults with FETCH_FIRST parameter will return empty result. 


FetchOrientation.FETCH_FIRST



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

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org