RE: Does hive support preparedstatement?

[Eric Hwang]

Hi Keven,

I don't believe Hive JDBC currently supports prepared statements. It supports 
'prepare' by just saving the query, but does not understand parameter markers 
within the query.

Regards,
Eric

From: chen keven [mailto:cke...@gmail.com]
Sent: Monday, July 20, 2009 11:46 AM
To: hive-user@hadoop.apache.org
Subject: Does hive support preparedstatement?

 I'm trying to use preparestament as following, however, I got the SQLException 
saying that the setInt method is not supported. Is there any special 
requirements to use prepareStatement in hive? where can i find the user manual 
for the api.


                statement = _conn.prepareStatement(expression);
                //Set parameters
                for (Integer fieldindex : parameters.keySet() ) {

                    statement.setInt(fieldindex, 
Integer.parseInt(parameters.get(fieldindex)));
                }

                statement.executeQuery();

java.sql.SQLException: Method not supported
    at 
org.apache.hadoop.hive.jdbc.HivePreparedStatement.setInt(HivePreparedStatement.java:349)
    at 
ca.ubc.ece.netsys.db.HiveDatabaseLayer.executeUpdateWithParameter(HiveDatabaseLayer.java:292)
    at 
ca.ece.ubc.netsys.graph.EdgeCreator.populateEdgeTable(EdgeCreator.java:109)
    at ca.ece.ubc.netsys.graph.EdgeCreator.run(EdgeCreator.java:49)
    at java.lang.Thread.run(Thread.java:619)


--
Thank you,
Keven Chen