[TeraJDBC 13.10.00.31] [Error 1005] [SQLState HY000] Unexpected parcel kind received: 33

Connectivity

[TeraJDBC 13.10.00.31] [Error 1005] [SQLState HY000] Unexpected parcel kind received: 33

I execute the sql by TeraJDBC13.1, but throw the exception:

16:55:31  [SELECT - 0 row(s), 0.000 secs]  [Error Code: 1005, SQL State: HY000]  [Teradata JDBC Driver] [TeraJDBC 13.10.00.31] [Error 1005] [SQLState HY000] Unexpected parcel kind received: 33

... 1 statement(s) executed, 0 row(s) affected, exec/fetch time: 0.000/0.000 sec [0 successful, 0 warnings, 1 errors]

The SQL statement:

SELECT last_name AS Name 

  ,salary_amount AS Salary 

  ,department_number AS Dept 

FROM employee 

WHERE Dept IN (401,403) 

WITH COUNT(Dept)(TITLE 'Dept_Count') BY Dept;

By the way, The SQL was executed successful in Teradata SQL Assistant tool environment.

Tags (1)
1 REPLY
Teradata Employee

Re: [TeraJDBC 13.10.00.31] [Error 1005] [SQLState HY000] Unexpected parcel kind received: 33

The Teradata JDBC Driver does not yet support WITH clauses and summary values. That feature request is covered by JDBC RFC 85621.

Omit the WITH clause from your query in order to execute it using the Teradata JDBC Driver.