Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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 0683p000009MACn.png
Thanks in advance!
Best regards,
Florian Fanderl
0683p000009MEiw.jpg
Labels (2)
2 Replies
Anonymous
Not applicable
Author

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,
Anonymous
Not applicable
Author

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