Executing Hive DDL Statements with tHiveRow causes error

One Star

Executing Hive DDL Statements with tHiveRow causes error

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 Smiley Happy
Thanks in advance!
Best regards,
Florian Fanderl
Employee

Re: Executing Hive DDL Statements with tHiveRow causes error

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,
One Star

Re: Executing Hive DDL Statements with tHiveRow causes error

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