skip to main content
Using the Driver : Parameter Metadata Support : Insert, Update, and Delete Statements
  

Try DataDirect Drivers Now

Insert, Update, and Delete Statements

The driver supports returning parameter metadata for the following forms of Insert statements:
*INSERT INTO foo VALUES (?, ?, ?)
*INSERT INTO foo (col1, col2, col3) VALUES (?, ?, ?)
The driver allows the CAST function to be used in specified SQL. However, if a parameter marker is present within a cast operation, the driver will be unable to obtain the parameter metadata and will throw the exception "The requested parameter metadata is not available for the current statement."
Returning parameter metadata for Update and Delete statements is not supported because Cloudera Impala does not have the concept of Update and Delete statements.