Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> A question about HiveStatement.executeUpdate's exception


Copy link to this message
-
Re: A question about HiveStatement.executeUpdate's exception
Hi Liyifan,
This seems like a bug. As a workaround, I would recommend using HiveStatement.executeQuery() instead (since they both call execute() on the Thrift client).

There is a JIRA already for this (https://issues.apache.org/jira/browse/HIVE-1450) and seems like a patch was uploaded as well (https://reviews.facebook.net/D4293) but nothing has been committed just yet.

I've asked for the status on the JIRA, let's see what they say:-)

Mark

----- Original Message -----
From: "Liyifan" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Sent: Tuesday, August 28, 2012 9:47:37 PM
Subject: A question about HiveStatement.executeUpdate's exception
Hi, all. I'm new to Hive, I have a question about executeUpdate.

I executed a SQL by invoking HiveStatement.executeUpdate method. I found that it throws an "Method not supported" exception.

And I checked the code in hive-0.9\jdbc\src\java\org\apache\hadoop\hive\jdbc\HiveStatement.java, I found that the "Method not supported" is always threw unless client.execute(sql) throws an exceptioin.

I'm confused about it, why executeUpdate always throws an exeption?

public int executeUpdate(String sql) throws SQLException {
try {
client.execute(sql);
} catch (Exception ex) {
throw new SQLException(ex.toString());
}
throw new SQLException("Method not supported");
}