Re: insert data into a column of complex type

2010-09-24 Thread Ping Zhu
has > UDF/UDTF to support extracting data from JSON/XML (json_object, json_tuple, > xpath_string, xpath_int ...). hive> show functions; and hive> desc > will give you more info about these UDFs. > > On Sep 23, 2010, at 5:12 PM, Ping Zhu wrote: > > Hi, > >

Re: insert data into a column of complex type

2010-09-24 Thread John Sichi
nt map. Hive has UDF/UDTF to support extracting data from JSON/XML (json_object, json_tuple, xpath_string, xpath_int ...). hive> show functions; and hive> desc will give you more info about these UDFs. On Sep 23, 2010, at 5:12 PM, Ping Zhu wrote: Hi, Can we insert data into a column of

Re: insert data into a column of complex type

2010-09-24 Thread Ning Zhang
Hive has UDF/UDTF to support extracting data from JSON/XML (json_object, json_tuple, xpath_string, xpath_int ...). hive> show functions; and hive> desc will give you more info about these UDFs. On Sep 23, 2010, at 5:12 PM, Ping Zhu wrote: > Hi, > > Can we insert data into

insert data into a column of complex type

2010-09-23 Thread Ping Zhu
Hi, Can we insert data into a column of complex type (eg map type) through hive command line? The only related article I can find is at http://www.mail-archive.com/common-comm...@hadoop.apache.org/msg01031.html: "The tables with columns that are an instance of a complex type can only be cr