hive> create table test1 (c1 array<int>) row format delimited collection items terminated by ','; OK
hive> insert into test1 select array(1,2,3) from dual; OK hive> select * from test1; OK [1,2,3] hive> select c1[0] from test1; OK 1 $ hadoop fs -cat /apps/hive/warehouse/test1/000000_0 1,2,3 On Sun, Mar 1, 2015 at 11:53 PM, Jie Zhang <jiezh2...@gmail.com> wrote: > Hi, > > I am trying to use hive complex data type on hive0.14.0. However, could > not access the array type as manual indicated. I have an array column, but > hit SemanticException when access the individual item in the array. Any > clue? Did I use the wrong syntax or miss some property setting? Thanks! > > hive> create table test1 (c1 array <int>) row format delimited collection > items terminated by ','; > > OK > > Time taken: 0.092 seconds > > hive> select * from test1; > > OK > > [1,2,3] > > Time taken: 0.065 seconds, Fetched: 1 row(s) > > hive> select c1[0] from test1; > > FAILED: SemanticException [Error 10004]: Line 1:7 Invalid table alias or > column reference 'c1[0]': (possible column names are: c1) > > Jessica >