What's New?

In OceanBase Database V2.1.12 released in March 2021, more command-line options are provided to better support data import and export operations. Data processing-related functions and features are enhanced.

OBLOADER

• The --cut command-line option is added to enable you to import data files in CUT format. For more information, see Command-line options.

• The --column-splitter command-line option is added to enable you to define a string that separates data columns. For more information, see Command-line options.

• Preprocess functions and conditional expressions can be defined in control files to preprocess data. For more information, see Data processing.

• Example statements for importing data files in POS and CUT formats are provided. For more information, see Scenarios.

OBDUMPER

• The --cut command-line option is added to enable you to export data files in CUT format. For more information, see Command-line options.

• The --ctl-path command-line option is added to enable you to specify the directory where control files are stored. For more information, see Command-line options.

• The --column-splitter command-line option is added to enable you to define a string that separates data columns. For more information, see Command-line options.

• The --distinct command-line option is added to enable you to deduplicate data in a table before the export. For more information, see Command-line options.

• Preprocess functions and conditional expressions can be defined in control files to preprocess data. For more information, see Data processing.

• Example statements for exporting data files in CUT format, data deduplication, and using control files are provided. For more information, see Scenarios.

• To improve export performance, the default value for the --page-size command-line option is increased from 2,000 rows to 10,000 rows. Modify the JVM memory parameter to prevent Out of Memory exceptions.