Can't seem to create a table with primary keys in Hive DB

StefanJoinPlus · October 17, 2023, 1:17pm

Hi Guys,

currently trying to create a table in Hive DB based on a file read in from my HDFS.
Hadoop Hive DB

And I don’t know why I can’t seem to declare primary keys.

However I can create tables just fine when I create them without any primary keys.
Do you guys have any idea why I can’t create Tables with defined keys?
Cause I want to define not just primary keys but also foreign keys later down the run.

sascha.wolke · October 17, 2023, 5:06pm

Hi @StefanJoinPlus,

What Hive version are you using on your cluster, and what Hive JDBC driver version are you using? (the build in driver from KNIME?) The KNIME console might contain more details about the error.

Cheers,
Sascha

system · January 15, 2024, 5:06pm

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.