hadoop - hive中外键关系的实现

Question

我试图创建一个与另一个表具有外键关系的配置单元表，但我遇到了错误。

不是可以在hive表中实现外键关系吗？

Answer 1

hive 没有实现外键引用 Hadoop Tutorials描述如下:

Like any other SQL engines, we don't have any primary keys and foreign keys in Hive as hive is not meant to run complex relational queries. It's used to get data in easy and efficient manner. So while designing hive schema, we don't need to bother about selecting unique key etc. Also we don't need to bother about normalizing the set of data for efficiency.