Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> how to split the value of hbase into hive


Copy link to this message
-
Re: how to split the value of hbase into hive
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 <[EMAIL PROTECTED]> 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
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB