What's New|V4.1.0|OBLOADER & OBDUMPER| docs|Distributed Database

OBLOADER & OBDUMPER V4.0.0 released in December 2022 allows you to import and export TYPE object definitions as well as data files (compressed by default) in column-oriented storage formats of ORC and Parquet. This version also weakens its dependency on sys tenant privileges, optimizes data export performance (for tables with primary keys or with non-null unique keys), and upgrades versions of components that the underlying layer depends on. The JDBC driver is upgraded to V2.2.11, and the partition calculator component is upgraded to 1.4.0-RELEASE. In addition, some feature defects in earlier versions are fixed.

New features

Tool Description

OBLOADER

Tool	Description
OBLOADER	The `--orc` and `--par` options are added, allowing you to import data files in ORC and Parquet formats to OceanBase Database. For more information, see Command-line options under OBLOADER.
OBDUMPER	The `--orc` and `--par` options are added, allowing you to export table data into data files in ORC and Parquet formats. The `--type` option is added, allowing you to export TYPE object definitions. The dependency on sys tenant privileges is weakened. Features available when the sys tenant password is specified are different from those available when the password is not specified. The differences are as follows: For more information, see Command-line options under OBDUMPER.

The --orc and --par options are added, allowing you to import data files in ORC and Parquet formats to OceanBase Database.

For more information, see Command-line options under OBLOADER.

OBDUMPER

The --orc and --par options are added, allowing you to export table data into data files in ORC and Parquet formats.
The --type option is added, allowing you to export TYPE object definitions.
The dependency on sys tenant privileges is weakened. Features available when the sys tenant password is specified are different from those available when the password is not specified. The differences are as follows:

For more information, see Command-line options under OBDUMPER.