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

[#1]

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

[#2]

Thanks in advance for your time and suggestions.

[#3 · Accepted solution]

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

[#4]

@keerthana gajarajakumar

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

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

[#5]

@Neeraj Sabharwal duplicate link dude

[#6]

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

[#7]

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

[#8]

@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?

• hive.support.concurrency – true
• hive.enforce.bucketing – true (Not required as of Hive 2.0)
• hive.exec.dynamic.partition.mode – nonstrict
• hive.txn.manager – org.apache.hadoop.hive.ql.lockmgr.DbTxnManager
• hive.compactor.initiator.on – true (for exactly one instance of the Thrift metastore service)
• hive.compactor.worker.threads – a positive number on at least one instance of the Thrift metastore service

[#9]

@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.

[#10]

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