title: How do I store array of integers in vertica database?
body: <p>Currently I'm working on vertica database. 
  I'm facing problem while storing array of integers in one column. I imported data values through csv. </p>
  
  <p>I used the following code to create table.</p>
  
  <pre><code>CREATE TABLE testing_table_1 (email varchar,name varchar,gen int,yob int,ct int,cy int,a varchar(65000),b varchar(65000),c varchar(65000));
  </code></pre>
  
  <p>I imported data with the following code.</p>
  
  <pre><code>COPY testing_table_1 from '/home/naresh/Desktop/bigfile.csv' parser fcsvparser();
  </code></pre>
  
  <p>My sample CSV format looks like the below.</p>
  
  <pre><code>ghchnu@tly.org.cn | Donald Garcia | 2 | 2003 | 21947 | 91 | 241,127,225,68,162 | 4,84,63,69,15 | 32,44,15,31
  rlmx@jyqewy.biz   | Charles Brown | 2 | 2012 | 22218 | 45 | 127,156,186,136,242 | 49,69,14,80,95,1 | 39,36,38,40,20
  </code></pre>
  
  <p>7th,8th and 9th columns are storing in the format of a string.
  But what I want is, I want them to be stored in an array of integers format.</p>
  
  <p>Because of the string format I am unable to perform combination of integers operation using 'IN' query.</p>
  
  <p>I don't to want to use flex-table format in vertica. 
  Give suggestions other than flex-table format.</p>
  
  <p>Please give me a possible solution for the above problem.</p>
  
  <p>Please correct me if I am doing any mistake.</p>
  
  <p>Thanks in advance,</p>