thanks Nitin. :) You are so nice. I will try this first. if I meet with problems later, pls be kind to help
2012-04-18 Best Regards Andes 发件人:Nitin Pawar 发送时间:2012-04-18 15:43 主题:Re: how to split the value of hbase into hive 收件人:"user"<user@hive.apache.org> 抄送: you can use the inbuilt udf split(string str, string pat) to split the string with the separator you want. It returns the array and you can access the array and insert array elements in the hive table On Wed, Apr 18, 2012 at 1:06 PM, ylyy-1985 <ylyy-1...@163.com> wrote: hi,all; I have a problem. I have an hbase table, with key-value pair like "user1001:12,1223,string". And now how can I split the value into three fields "ID,phone,and memo" and then insert into hive table? does hive support this? thanks 2012-04-18 Andes -- Nitin Pawar