Load a SQL file using shell comand
I write because I have a litle issue.
I tried to load a sql file using this sentences:
/opt/vertica/bin/vsql -f "/root/Desktop/Files/bienes.sql" -U user -w pass
Always show this messager but doesn´t load the data in the table:
I tried to insert 1 tuple manually using GUI: Dbeaver
INSERT INTO DW.bienes(x1,x2,x3,x4,x5,X,Y,x6) VALUES (12345,'blah','lala','lalaa',asdf,NULL,NULL,NULL);
and the data was load.
Please anybode can help me whit this ? in my file.sql I have more than 13mm of tuples and is imposible to load using gui.
Please help me.