vsql copy from local

RasmusRasmus Vertica Customer
edited March 2023 in General Discussion


i have a json file called 'issues', which is 250 MB in size, containing 14734 elements.
When i read in this file to a flex table using COPY from LOCAL, all the lines get read in.
But whenever i'm doing the exact same thing through vsql, only 235 lines get read in.
(Have done it multiple times with direct and auto mode and no change...235 elements get read in).

Checked the json file, and there isn't any abnormality with the 235th element nor 236th.

Any help is very appreciated!


  • Options
    RasmusRasmus Vertica Customer

    Solved! Shell allocation was missing o:) .

This discussion has been closed.