Yeah It worked that way but I thought the performance of this solution will be very low. So next thing: create table (id auto_increment, fk1 int , name varchar); vsql -c "select ins_testext(10,5)" Data in table id | fk1 | name ----------+-----+------- 1 | 2 | fa37J 250001 | 5 | fa37J 500001 | 5 | fa...

Hello everyone. I tried to create external insert procedure. Everything looks fine(without errors) except that actually it's now working. Procedure is not inserting any rows. #!/bin/bash echo "first arg: $1 second arg : $2" for i in {1..5} do vsql -c "insert into testext select RANDOMINT($1 - (1) + ...

At first Hi everybody. So... I have just read this topic "Why vertica-forums.com?" by knicely87 and I have a question related to this. ...I'm happy to report that after exploring and experiencing the "Vertica Advantage"... Could you be more precise and write some of these advantage ? Or any of you ?...