topic Registering Hive UDF's - thiveinput in Talend Studio

Registering Hive UDF's - thiveinput

Anonymous — Sat, 16 Nov 2024 11:46:30 GMT

How to use a function with thiveinput or thiverow?
in shell:
$HIVE -e "
create temporary function findInMsg as 'com.test.hive.FindInMessage';
select
findInMsg('country', message),
from
table;
"
My error with talend component:
java.sql.SQLException: Query returned non-zero code: 9, cause: FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.MapRedTask
at org.apache.hadoop.hive.jdbc.HiveStatement.executeQuery(HiveStatement.java:194)
I tried to make a tHiveRow first to execute the temporary function, and after tHiveInput to select data...but it's not working.
any solution to use Hive UDF's?

Re: Registering Hive UDF's - thiveinput

Anonymous — Mon, 27 Jan 2014 08:22:35 GMT

Hi,
Which kind of connection do you use? Embedded? Standalone? What is the configuration of your component in Talend?
Cheers,

Re: Registering Hive UDF's - thiveinput

Anonymous — Mon, 27 Jan 2014 10:23:56 GMT

Hi,
tHiveConnection:
MapR / MapR 3.0.1
--> Connection mode: standalone / Hive Server: Hive 1
what does it mean? standalone?embedded? what's the difference?

I'm not using option "Register a shared DB connection"
tHiveRow / tHiveIput --> use an existing connection.

Thanks for your help

Re: Registering Hive UDF's - thiveinput

Anonymous — Mon, 27 Jan 2014 12:23:25 GMT

Hi,
Using the standalone mode, you connect to the Hive server through JDBC. The logs are located on the cluster side. You should open the logs on the cluster side in order to get more details.
Cheers,