Registering Partition Information

You can register the partition information during the Model Upload process. Partition information for tables is retrieved and registered into the OFSAAI object registration table REV_TAB_PARTITIONS during the Model Upload process.

Partition table name and column names are added to V_TABLE_NAME and V_COLUMN_NAME respectively in the REV_TAB_PARTITIONS table. Partition Sequence is stored in N_PARTITION_SEQUENCE. The sequence starts from 1 for the major partition column and the maximum sequence number is equal to the number of partitioned columns. V_PARTITION_VALUE holds the value for a particular partition to be considered for any executions. Data into this column can be populated manually or with the help of any OFSAAI table data load options.

Hive supports static and dynamic partitions. Values for static partition are known in the query whereas dynamic partition values are known at the execution time. If V_PARTITION_VALUE is null in REV_TAB_PARTITIONS, the table is considered as dynamic partitioned. AAI executions run on static and dynamic partitions.