User Tools

Site Tools

A PCRE internal error occured. This might be caused by a faulty plugin


**HPL/SQL is included to Apache Hive since version 2.0** * [[home|Home]]\\ * [[why|Why HPL/SQL]]\\ * [[features|Key Features]]\\ * [[start|Get Started]]\\ * [[doc|HPL/SQL Reference]]\\ * [[download|Download]]\\ * [[new|What's New]]\\ * [[about|About]]


====== GET DIAGNOSTICS Statement - PL/HQL ====== GET DIAGNOSTICS statement allows you to retrieve the error message, the number of rows about the previous SQL statement. **Syntax**: Get the error text: <code language=sql> GET DIAGNOSTICS EXCEPTION 1 var_name = MESSAGE_TEXT; </code> Get the number of rows associate with the previous SQL statement: <code language=sql> GET DIAGNOSTICS var_name = ROW_COUNT; </code> **Important Note:** * Hive does not support JDBC Statement.getUpdateCount() for INSERT statements, so GET DIAGNOSTICS ROW_COUNT will return 0 for Hive 0.13 and earlier and -1 for Hive 0.14 and later. See [[|HIVE-7680]] for more details. **Compatibility:** IBM DB2 **Version**: PL/HQL 0.03 **See also:** * [[error-handling|Error Handling]] * [[declare-handler|DECLARE HANDLER]] * [[activity_count|ACTIVITY_COUNT]] * [[sqlcode|SQLCODE]] * [[sqlstate|SQLSTATE]]