CoPY command error and rowcount

How to handle errors for copy command (not the rejects/exceptions files) and is there any variable/table where the total rows loaded using copy command are stored. I checked load_streams table but the table was empty


  • Options
    SruthiASruthiA Vertica Employee Administrator

    Hi Sreedhar,


          Once you load the data using copy command, execute the following query to know the count of rows loaded successfully


    select get_num_accepted_rows();





Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file