gs_copy_summary
The gs_copy_summary table is used to record the COPY execution result summary, including the number of successful rows, number of error rows, number of ignored rows, and number of empty rows. For details about the permissions, see "Client Tools > gs_loader > Permission" in Tool Reference.
Name |
Type |
Description |
---|---|---|
relname |
character varying |
Name of the target table to be imported. |
begintime |
timestamp with time zone |
Start time of an import task. |
endtime |
timestamp with time zone |
End time of an import task. |
id |
bigint |
ID of the transaction to be imported. |
pid |
bigint |
ID of the worker thread for the current import. |
readrows |
bigint |
Total number of data rows read by the import task. |
skiprows |
bigint |
Total number of data rows skipped in the import task. |
loadrows |
bigint |
Number of data rows successfully imported in the current import task. |
errorrows |
bigint |
Number of error data rows in the current import task. |
whenrows |
bigint |
Number of data rows that violate the WHEN filter criterion in the current import task. |
allnullrows |
bigint |
Number of data rows where all columns are empty. |
detail |
text |
Summary of the import task, including the number of successfully imported rows, number of error data rows, number of rows that violate the WHEN condition, and number of blank rows. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot