title: How to Define nested Collection items in Hive
body: <p>I am trying to create a hive table with nested Collection items. Suppose I have an array of struct.</p>
  
  <pre><code>    CREATE TABLE SAMPLE(
      record array&lt;struct&lt;col1:string,col2:string&gt;&gt;
      )row format delimited
      fields terminated by ','
      collection items terminated by '|';
  </code></pre>
  
  <p>First level, the separator ',' will override the default delimiter '^A'.</p>
  
  <p>Second level, the separator '|' will override the default second level delimiter '^B' to separate out the outer most structure (i.e. Array).</p>
  
  <p>Third level hive will use the default third level delimiter '^C' as the separator for the  Struct</p>
  
  <p>Now my question is how can I define a separator for the second level (i.e. Struct), because '^C' character is hard to read as well as to generate.</p>
  
  <p>Is there any way to explicitly define the separator instead of ^C ?</p>
  
  <p>Thanks in advance.</p>