Mailing-List: contact issues-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
Date: Mon, 27 Feb 2017 04:03:45 +0000 (UTC)
From: "Thejas M Nair (JIRA)" <jira@apache.org>
To: issues@hive.apache.org
Message-ID: <JIRA.12698396.1393844047000.2545.1488168225279@Atlassian.JIRA>
In-Reply-To: <JIRA.12698396.1393844047000@Atlassian.JIRA>
References: <JIRA.12698396.1393844047000@Atlassian.JIRA> <JIRA.12698396.1393844047055@jira-lw-us.apache.org>
Subject: [jira] [Updated] (HIVE-6535) JDBC: provide an async API to execute
 query and fetch results
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
archived-at: Mon, 27 Feb 2017 04:04:10 -0000


     [ https://issues.apache.org/jira/browse/HIVE-6535?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Thejas M Nair updated HIVE-6535:
--------------------------------
    Release Note: 
Introduced new method HiveStatement.executeAsync - Starts the query execution asynchronously on the server, and immediately returns to the client. The client subsequently blocks on ResultSet#next or Statement#getUpdateCount, depending on the query type. Users should call ResultSet.next or Statement#getUpdateCount (depending on whether query returns results) to ensure that query completes successfully. Calling another execute method, or close before query completion would result in the async query getting killed if it is not already finished.
Note: This method is an API for limited usage outside of Hive by applications like Apache Ambari, although it is not part of the interface java.sql.Statement.

  was:
Starts the query execution asynchronously on the server, and immediately returns to the client. The client subsequently blocks on ResultSet#next or Statement#getUpdateCount, depending on the query type. Users should call ResultSet.next or Statement#getUpdateCount (depending on whether query returns results) to ensure that query completes successfully. Calling another execute method, or close before query completion would result in the async query getting killed if it is not already finished.
Note: This method is an API for limited usage outside of Hive by applications like Apache Ambari, although it is not part of the interface java.sql.Statement.


> JDBC: provide an async API to execute query and fetch results
> -------------------------------------------------------------
>
>                 Key: HIVE-6535
>                 URL: https://issues.apache.org/jira/browse/HIVE-6535
>             Project: Hive
>          Issue Type: Improvement
>          Components: HiveServer2, JDBC
>    Affects Versions: 0.14.0, 1.2.1, 2.0.0
>            Reporter: Thejas M Nair
>            Assignee: Vaibhav Gumashta
>             Fix For: 2.1.0
>
>         Attachments: HIVE-6535.1.patch, HIVE-6535.2.patch, HIVE-6535.3.patch, HIVE-6535.4.patch, HIVE-6535.5.patch, HIVE-6535.6.patch
>
>
> The hive jdbc client waits query completion during execute() call. It would be better to block in the jdbc for completion when the results are being fetched.
> This way the application using hive jdbc driver can do other tasks while asynchronous query execution is happening, until it needs to fetch the result set.
>  


--
This message was sent by Atlassian JIRA
(v6.3.15#6346)