How to assign array and find size of array in hive?
<p>Suppose I am getting Input string as multiple parameters from user.</p>

<p>e.g</p>

<pre><code>hive -f demo.txt -hiveconf Name="a,b,c,d"
</code></pre>

<p>I want to pass these values(Names) in WHERE clause, by splitting the string using SPLIT function.</p>

<p>i.e</p>

<pre><code>set a=SPLIT('${hiveconf:Name}',',');
</code></pre>

<p>But the output of SPLIT is an array.</p>

<p>So my question is how can i assign array in WHERE clause?</p>

<p>e.g.</p>

<pre><code>WHERE Name IN (${hiveconf:a}[0:?])
</code></pre>

<p>Thank you.</p>