topic [resolved] Error in tHiveInput Component: java.sql.SQLException: Could not create in Talend Studio

[resolved] Error in tHiveInput Component: java.sql.SQLException: Could not create

Anonymous — Sat, 16 Nov 2024 11:18:03 GMT

Scenario: I have to create table from select statment using Hive.

I am able create staging table in Hive Named as temp_customer.
Loaded data using tHiveLoad component to the temp_customer table.
Generated Dynamic query for "Create table customer as Select * from temp_customer where country='USA'"
Executed this query using tHiveRow have the same error as shown below then i used tHiveInput still it is giving same error.

Error:

Exception in component tHiveInput_4
java.sql.SQLException: Could not create ResultSet: Error: type expected at the position 4 of  but 'varchar' is found.

Debug:

temp_customer created with data.
Customers tables created with filtered records.
but still further process not executed because of this error can any one suggest what is the issue? it is bug or this type of query not supported? if not then how come table created with filter data?

Re: [resolved] Error in tHiveInput Component: java.sql.SQLException: Could not create

Anonymous — Wed, 11 Mar 2015 20:45:33 GMT

What distribution of Hadoop are you using?
and
What jars did you install?

Re: [resolved] Error in tHiveInput Component: java.sql.SQLException: Could not create

Anonymous — Thu, 12 Mar 2015 06:14:34 GMT

I am using "Apache" Distribution and Hive version is " Apache 1.0.0(Hive 0.9.0).
As far as jars concern it has been downloaded when I started Big Data studio. Do you want the list jar for Apache & Hive?

Re: [resolved] Error in tHiveInput Component: java.sql.SQLException: Could not create

Anonymous — Thu, 12 Mar 2015 13:06:56 GMT

Load this " hive_0.12.0exe.jar" jar explicitly and everything works fine.