LOCK for tables

[Duje]

Hi,

i'm trying to find any information about locks for table.
i'm interested in next case - will select queries work if we inserting data from csv file to Vertica. CSV file will have ~100000 rows.
if not, is it possible to avoid this lock?

case question if we will do something like: insert into schema1.table1 select * from schema2.table2. is it possible to execute select * from table1 in those queries?

thank you for advice,
Duke

[jpcavanaugh]

You should have no issue doing what you have listed. The link below discusses the locking model in Vertica.

http://my.vertica.com/docs/6.0.0-1/HTML ... #17550.htm