Support Questions
Find answers, ask questions, and share your expertise

How can I set primary key and reference foreign keys while creating a table / external table in hive?

Contributor

external-table-error.pngI'm getting the following error:

1 ACCEPTED SOLUTION

Accepted Solutions

Mentor

@keerthana gajarajakumar hive is not a replacement for EDW or RDBMS there is no concept of foreign key.

View solution in original post

18 REPLIES 18

Contributor

Thanks in advance for your time and suggestions.

Mentor

@keerthana gajarajakumar hive is not a replacement for EDW or RDBMS there is no concept of foreign key.

View solution in original post

@keerthana gajarajakumar

It's not there yet but eventually we will get there.

See this https://issues.apache.org/jira/browse/HIVE-6905

Mentor

@Neeraj Sabharwal duplicate link dude

Contributor

@Artem Ervits -- do you have any suggestion to overcome this error? I'm unable to make updates to the following table:update-error.png

Mentor

@keerthana gajarajakumar take a look at ACID support in Hive, we have some support for ACID but it's not fully working yet.

Contributor

@Artem Ervits - Thanks. I'd like to update hive-site.xml with the following statements. Where can I find hive-site.xml within the hortonworks web interface?

Mentor

@keerthana gajarajakumar you can find those properties in configuration section of ambari under Hive service. they are most likely not there so you will need to add them to the properties in the custom hive-site section.

Contributor

@Artem Ervits - I was able to find all the settings under hive service . Thanks!