Alter hive table add primary key




  • I am working on CCA175 Section 4 Lecture 51 in which we are creating a daily_revenue table in hive using SQL.
  • I ran describe orders. It lists columns, but there is no mention of a primary key.

So I searched and found this post:

Which references the hive language manual:

Per the post, as of hive 2.1.0, constraints are supported.

Now, I see a file /usr/hdp/
which is pointing to hive-cli-1.2.1000.

So does this mean we have hive version 1.2? I was just trying to create a primary key on the hive table.

Thanks in advance for your help!

Practice hive on state of the art Big Data cluster -