[ https://issues.apache.org/jira/browse/HIVE-17566?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16194157#comment-16194157 ]
Harish Jaiprakash commented on HIVE-17566: ------------------------------------------ Thanks [~sershe]. I'll make parent_pool_id nullable, its nullable in the schema. Made a mistake in package.jdo. Thanks [~prasanth_j]. * Yes path is to store hierarchical paths. This is because its easier to query with that. I can remove parent_pool_id, since we can query for all children using prefix match. * MAPPINGS are rules too for a resource_plan. I thought the name trigger was more appropriated to describe what this table holds. I can call it trigger_rule if that is alright. * All objects are under a resource plan, hence the rp_id in every table. The relationship b/w rules and pool are many-to-many. There is a different table, WM_POOL_TO_TRIGGER, to manage that. > Create schema required for workload management. > ----------------------------------------------- > > Key: HIVE-17566 > URL: https://issues.apache.org/jira/browse/HIVE-17566 > Project: Hive > Issue Type: Sub-task > Reporter: Harish Jaiprakash > Assignee: Harish Jaiprakash > Attachments: HIVE-17566.01.patch, HIVE-17566.02.patch, > HIVE-17566.03.patch, HIVE-17566.04.patch, HIVE-17566.05.patch, > HIVE-17566.06.patch > > > Schema + model changes required for workload management. -- This message was sent by Atlassian JIRA (v6.4.14#64029)