How do I add a Primary in Hive version 0.14.0.2.0.0-2041?

Question

How to add a Primary in Hive version 0.14.0.2.0.0-2041   ?

Trying

CREATE TABLE simple_rule (
  simple_rule_id           int(10) unsigned default '0' not null auto_increment,
  condition_analysis_id    int(10) unsigned NOT NULL,
  goal_analysis_id         int(10) unsigned NOT NULL,

  PRIMARY KEY (simple_rule_id),
  UNIQUE (condition_analysis_id, goal_analysis_id)
);

Answer 1

Hive is not a relational bank and there is not the same concept of primary/foreign key.

But you can add this information in the Table Metadata:

CREATE TABLE simple_rule (
    simple_rule_id          int 
    condition_analysis_id   int,
    goal_analysis_id        int,
)
TBLPROPERTIES("PRIMARY KEY"="simple_rule_id");

But I reinforce that this won’t make any difference on the table.