Skip to main content
Version: Latest-3.3

pipe_files

pipe_files provides the status of the data files to be loaded via a specified pipe. This view is supported from StarRocks v3.2 onwards.

The following fields are provided in pipe_files:

FieldDescription
DATABASE_NAMEThe name of the database in which the pipe is stored.
PIPE_IDThe unique ID of the pipe.
PIPE_NAMEThe name of the pipe.
FILE_NAMEThe name of the data file.
FILE_VERSIONThe digest of the data file.
FILE_SIZEThe size of the data file. Unit: bytes.
LAST_MODIFIEDThe last time when the data file was modified. Format: yyyy-MM-dd HH:mm:ss. Example: 2023-07-24 14:58:58.
LOAD_STATEThe load status of the data file. Valid values: UNLOADED, LOADING, FINISHED, and ERROR.
STAGED_TIMEThe date and time when the data file was first recorded by the pipe. Format: yyyy-MM-dd HH:mm:ss. Example: 2023-07-24 14:58:58.
START_LOAD_TIMEThe date and time when the loading of the data file began. Format: yyyy-MM-dd HH:mm:ss. Example: 2023-07-24 14:58:58.
FINISH_LOAD_TIMEThe date and time when the loading of the data file finished. Format: yyyy-MM-dd HH:mm:ss. Example: 2023-07-24 14:58:58.
ERROR_MSGThe details about the load error for the data file.