All Forums Connectivity
kerr.ding 1 post Joined 06/11
08 Jun 2012
[TeraJDBC] [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] [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.

tomnolan 594 posts Joined 01/08
08 Jun 2012

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.

You must sign in to leave a comment.