title: Summing values of Hive array types
body: <p>Hive has this pretty nice Array type that is very useful in theory but when it comes to practice I found very little information on how to do any kind of opeartions with it.
  We store a serie of numbers in an array type column and need to SUM them in a query, preferably from n-th to m-th element. Is it possible with standard HiveQL or does it require a UDF or customer mapper/reducer?</p>
  
  <p>Note: we're using Hive 0.8.1 in EMR environment.</p>