[jira] [Commented] (HIVE-6905) Implement Auto increment, primary-foreign Key, not null constraints and default value in Hive Table columns
[ https://issues.apache.org/jira/browse/HIVE-6905?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16366449#comment-16366449 ] Vineet Garg commented on HIVE-6905: --- [~grw], [~patelmanjun...@gmail.com] [~ppm] [~richardlloyd] FYI I recently committed a patch(HIVE-16605) which enforces NOT NULL constraint. I am also working on adding DEFAULT (HIVE-18726) > Implement Auto increment, primary-foreign Key, not null constraints and > default value in Hive Table columns > > > Key: HIVE-6905 > URL: https://issues.apache.org/jira/browse/HIVE-6905 > Project: Hive > Issue Type: New Feature > Components: Database/Schema >Affects Versions: 0.14.0 >Reporter: Pardeep Kumar >Priority: Major > > For Hive to replace a modern datawarehouse based on RDBMS, it must have > support for keys, constraints, auto-increment values, surrogate keys and not > null features etc. Many customers do not move their EDW to Hive due to these > reasons as these have been challenging to maintain in Hive. > This must be implemented once https://issues.apache.org/jira/browse/HIVE-5317 > for Updates, Deletes and Inserts are done in Hive. This should be next step > for Hive enhancement to take it closer to a very wide mainstream adoption.. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-6905) Implement Auto increment, primary-foreign Key, not null constraints and default value in Hive Table columns
[ https://issues.apache.org/jira/browse/HIVE-6905?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15932644#comment-15932644 ] Richard Lloyd commented on HIVE-6905: - 1-up from me as this is a nice-to-have. I agree there are workarounds in cases when uniqueness is the requirement though. > Implement Auto increment, primary-foreign Key, not null constraints and > default value in Hive Table columns > > > Key: HIVE-6905 > URL: https://issues.apache.org/jira/browse/HIVE-6905 > Project: Hive > Issue Type: New Feature > Components: Database/Schema >Affects Versions: 0.14.0 >Reporter: Pardeep Kumar > > For Hive to replace a modern datawarehouse based on RDBMS, it must have > support for keys, constraints, auto-increment values, surrogate keys and not > null features etc. Many customers do not move their EDW to Hive due to these > reasons as these have been challenging to maintain in Hive. > This must be implemented once https://issues.apache.org/jira/browse/HIVE-5317 > for Updates, Deletes and Inserts are done in Hive. This should be next step > for Hive enhancement to take it closer to a very wide mainstream adoption.. -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Commented] (HIVE-6905) Implement Auto increment, primary-foreign Key, not null constraints and default value in Hive Table columns
[ https://issues.apache.org/jira/browse/HIVE-6905?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15202001#comment-15202001 ] Paul Maric commented on HIVE-6905: -- Hi, is there any update on this? This is very important for us to consider moving to Hive as our DWH. > Implement Auto increment, primary-foreign Key, not null constraints and > default value in Hive Table columns > > > Key: HIVE-6905 > URL: https://issues.apache.org/jira/browse/HIVE-6905 > Project: Hive > Issue Type: New Feature > Components: Database/Schema >Affects Versions: 0.14.0 >Reporter: Pardeep Kumar > > For Hive to replace a modern datawarehouse based on RDBMS, it must have > support for keys, constraints, auto-increment values, surrogate keys and not > null features etc. Many customers do not move their EDW to Hive due to these > reasons as these have been challenging to maintain in Hive. > This must be implemented once https://issues.apache.org/jira/browse/HIVE-5317 > for Updates, Deletes and Inserts are done in Hive. This should be next stop > for Hive enhancement to take it closer to a very wide mainstream adoption.. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-6905) Implement Auto increment, primary-foreign Key, not null constraints and default value in Hive Table columns
[ https://issues.apache.org/jira/browse/HIVE-6905?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15115064#comment-15115064 ] Manjunath Patel commented on HIVE-6905: --- Hi, Any updates on this? > Implement Auto increment, primary-foreign Key, not null constraints and > default value in Hive Table columns > > > Key: HIVE-6905 > URL: https://issues.apache.org/jira/browse/HIVE-6905 > Project: Hive > Issue Type: New Feature > Components: Database/Schema >Affects Versions: 0.14.0 >Reporter: Pardeep Kumar > > For Hive to replace a modern datawarehouse based on RDBMS, it must have > support for keys, constraints, auto-increment values, surrogate keys and not > null features etc. Many customers do not move their EDW to Hive due to these > reasons as these have been challenging to maintain in Hive. > This must be implemented once https://issues.apache.org/jira/browse/HIVE-5317 > for Updates, Deletes and Inserts are done in Hive. This should be next stop > for Hive enhancement to take it closer to a very wide mainstream adoption.. -- This message was sent by Atlassian JIRA (v6.3.4#6332)