How to Copy text to ARRAY type column
i saw the follwing article
In this article, we have confirmed that COPY is performed using the query below.
CREATE TABLE researchers (id INT, name VARCHAR, grants ARRAY[VARCHAR], values ARRAY[INT]); COPY researchers FROM STDIN; --- Enter data to be copied followed by a newline. --- End with a backslash and a period on a line by itself. --- 42|Sheldon Cooper|[US-7376,DARPA-1567]|[65000,135000] --- 17|Howard Wolowitz|[NASA-1683,NASA-7867,SPX-76]|[16700,85000,45000] --- \.
So I created the following text file based on the query above.
but, i saw below error
[0A000] [Vertica]VJDBC ERROR: Default COPY parsers do not support arrays yet
using query 'COPY researchers FROM LOCAL '/Users/liquid.bear/Desktop/test.txt';
Looking at the message, it seems that the ARRAY type cannot be specified in the basic COPY statement, so how should I modify it?
i use vertica v10.0.0-2