title: Hive: How to insert data in a column of type array <string>
body: <p>Have a table with following schema:</p>
  
  <pre><code>CREATE TABLE `student_details`(
    `id_key` string, 
    `name` string, 
    `subjects` array&lt;string&gt;)
  ROW FORMAT SERDE 
    'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' 
  STORED AS INPUTFORMAT 
    'org.apache.hadoop.mapred.TextInputFormat' 
  OUTPUTFORMAT 
    'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
  LOCATION
    'path'
  </code></pre>
  
  <p>When trying to insert the values in the table getting an error message:</p>
  
  <p>Tried:</p>
  
  <pre><code>INSERT INTO student_details  values ('AA87U','BRYAN',array('ENG','CAL_1','CAL_2','HST','MUS')); 
  </code></pre>
  
  <p>Error:</p>
  
  <pre><code>FAILED: SemanticException [Error 10293]: Unable to create temp file for insert values Expression of type TOK_FUNCTION not supported in insert/values 
  </code></pre>
  
  <p>This doesn't make sense to me. Tried looking online and found a similar one: <a href="https://knowledgebase.progress.com/articles/Article/Unable-to-create-temp-file-for-insert-values-Expression-of-type-TOK-FUNCTION-not-supported-in-insert-values-error-with-Apache-Hive-ODBC-driver" rel="nofollow noreferrer">ExternalLink</a>. The solution also not making any sense.</p>
  
  <p>Any help please.</p>