question Re: Can I create Primary Key in Hive table? I saw in TBLPROPERTIES you can mention "PRIMARY KEY"="col_name", what it actually does? in Archives of Support Questions (Read Only)

Can I create Primary Key in Hive table? I saw in TBLPROPERTIES you can mention "PRIMARY KEY"="col_name", what it actually does?

abdus_mollah — Thu, 10 Mar 2016 20:30:40 GMT

SQLShaw — Thu, 10 Mar 2016 21:12:23 GMT

@Abdus Sagir Mollah the designation of primary key is simply metadata describing the column. It doesn't apply any referential constraints.

awatson — Thu, 10 Mar 2016 23:08:06 GMT

Primary keys can also be useful for bucketing (i.e. paritioning of data) especially if you are trying to leverage the ACID capabilities of Hive.

Quote from the below blog:

Once an hour, a set of inserts and updates (up to 500k rows) for various dimension tables (eg. customer, inventory, stores) needs to be processed. The dimension tables have primary keys and are typically bucketed and sorted on those keys.

sdutta — Thu, 10 Mar 2016 23:26:40 GMT

@Andrew Watson - The ACID properties have been taken back by the community. It is not recommended for customer use currently.