Skip to main content
Question

Does Vertica support parallel INSERT AS SELECT or CTAS natively?

  • November 30, 2021
  • 1 reply
  • 2 views

mosheg
Forum|alt.badge.img+2
  • Participating Frequently

The prospect is asking if Vertica support parallel INSERT AS SELECT or multi threaded CTAS automatically,
Without the need to write scripts manually as shown below.

INSERT INTO foo_cp
SELECT * from foo
WHERE HASH( some_column ) % 4 = 0;

INSERT INTO foo_cp
SELECT * from foo
WHERE HASH( some_column ) % 4 = 1;

INSERT INTO foo_cp
SELECT * from foo
WHERE HASH( some_column ) % 4 = 2;

INSERT INTO foo_cp
SELECT * from foo
WHERE HASH( some_column ) % 4 = 3;

1 reply

mosheg
Forum|alt.badge.img+2
  • Author
  • Participating Frequently
  • November 30, 2021

Thanks Hibiki,
From your answer I guess we still do not support natively parallel INSERT automatically.