14.1.1 Functional overview

The adbexport command is used to export data from base tables and viewed tables into files. This processing is called data export processing. If you specified a table name for the adbexport command, data of the specified table (base table or viewed table) is output. If you specified an SQL statement file for the adbexport command, the search results of the SQL statement (the SELECT statement) written in the file is output.

The following figure provides an overview of data export processing.

Figure 14‒1: Overview of data export processing

Explanation:

The adbexport command enables you to export data from a table into a file. It also enables you to export a smaller subset of the retrieved data when you specify an SQL statement file.

The adbexport command can export data from the following types of tables:

• Base tables for which the EXPORT TABLE privilege has been granted

• Viewed tables for which the EXPORT TABLE privilege has been granted

• Dictionary tables

• System tables

Note

Exporting data in a multi-chunk table

If you want to output data contained in a chunk in wait status, you need to specify the chunk ID of that chunk as the output target to export only a chunk of data. If the chunk ID is not specified, the chunk in wait status will not be output.

For details about how to output a chunk of data, see the explanation of the -c option in (3) Explanation of options in 14.2.1 Explanation of the specification format and options.

The following explains the files:

• Output data files

  The table data is output to these files. The output format is CSV. For details about the CSV format, see 14.5 Format of output data files (CSV format).

  An output data file can be compressed and then exported as a GZIP-format file. For details about the compression format of output data files, see 14.6 Compression format of output data files.

• Output data path file

  This file is used to specify a list of path names of the output destinations for the output data files.

• Export option file

  This file contains options that are to be used to set up an execution environment for the adbexport command.

• SQL statement file

  This file is used to specify a data retrieval SELECT statement for exporting a smaller subset of the retrieved data.

To Page Top