SYSCS_UTIL.SYSCS_SPLIT_TABLE_OR_INDEX_AT_POINTS

Before using this procedure, SYSCS_UTIL.SYSCS_SPLIT_TABLE_OR_INDEX_AT_POINTS, you must first call the SYSCS_UTIL.COMPUTE_SPLIT_KEY procedure to compute the split points for the data you’re importing. After computing the split keys, use this procedure to split the data into HFiles, and then call  SYSCS_UTIL.BULK_IMPORT_HFILE system procedure to import your data in HFile format.

Syntax

SYSCS_UTIL.SYSCS_SPLIT_TABLE_OR_INDEX_AT_POINTS (
        schemaName,
        tableName,
        indexName,
        splitPoints
        );

schemaName

The name of the schema of the table or index that you are splitting.

tableName

The name of the table you are splitting.

indexName

The name of the index that you are splitting. If this is null, the specified table is split; if this is non-null, the index is split instead.

splitPoints

A comma-separated list of split points for the table or index.

This is the list of split points computed by a previous call to the SYSCS_UTIL.COMPUTE_SPLIT_KEY procedure.

Usage

The SYSCS_UTIL.BULK_IMPORT_HFILE procedure needs the data that you’re importing split into multiple HFiles before it actually imports the data into your database. You can achieve these splits in three ways:

  • You can call SYSCS_UTIL.BULK_IMPORT_HFILE with the skipSampling parameter to false. SYSCS_UTIL.BULK_IMPORT_HFILE samples the data to determine the splits, then splits the data into multiple HFiles, and then imports the data.

  • You can split the data into HFiles with the  SYSCS_UTIL.SYSCS_SPLIT_TABLE_OR_INDEX procedure, which both computes the keys and performs the splits. You then call  SYSCS_UTIL.BULK_IMPORT_HFILE with the skipSampling parameter to true to import your data.

  • You can split the data into HFiles by first calling the  SYSCS_UTIL.COMPUTE_SPLIT_KEY procedure to compute the split points, and then call this procedure,  SYSCS_UTIL.SYSCS_SPLIT_TABLE_OR_INDEX_AT_POINTS procedure to split the table or index. You then call  SYSCS_UTIL.BULK_IMPORT_HFILE with the skipSampling parameter to true to import your data.

In all cases, SYSCS_UTIL.BULK_IMPORT_HFILE automatically deletes the HFiles after the import process has completed.

The Bulk HFile Import Examples section of our Importing Data Tutorial describes how these methods differ and provides examples of using them to import data.

See Also