topic Re: Executing Hive DDL Statements with tHiveRow causes error in Talend Studio

Executing Hive DDL Statements with tHiveRow causes error

Anonymous — Sat, 16 Nov 2024 11:58:47 GMT

Hi everyone,
Currently I'm working on an ETL solution in Talend. One thing that I need to do is to create a partition inside an existing Hive Table. This is the statement:
ALTER TABLE sometable ADD IF NOT EXISTS PARTITION (time='20130606',COUNTRY='DE')
Please see the attached picture for the setup.
The Hive distribution we use is Cloudera CDH4 in standalone mode.
If I try to execute the job I get the following exception:
Query returned non-zero code: 40000, cause: FAILED: NullPointerException null
I tried to execute other DDL statements and none of them worked. However I was able to execute SQL queries.
Does anybody have an idea how to solve this issue?
I was watching this video ( http://www.youtube.com/watch?v=5BCl9ybLQXI) where they do exactly what I want to do.
I hope anybody can help me
Thanks in advance!
Best regards,
Florian Fanderl

Re: Executing Hive DDL Statements with tHiveRow causes error

Anonymous — Fri, 05 Jul 2013 14:56:21 GMT

Hello,
Using the standalone mode of hive, all the logs are located on the cluster side. We would need that in order to troubleshoot your issue.
Regards,

Re: Executing Hive DDL Statements with tHiveRow causes error

Anonymous — Mon, 08 Jul 2013 09:26:58 GMT

Hi,
Thanks for the hint. I think I can get access to the logs. Maybe that is enough for myself to figure out the solution. If not I will post the logs here.
Thank you very much!
Best regards,
Florian