Re: blob handling in hive

2010-10-12 Thread Jinsong Hu
elegant. Jimmy. -- From: "Ted Yu" Sent: Tuesday, October 12, 2010 4:33 PM To: Subject: Re: blob handling in hive How about utf-8 encode your blob and store in Hive as String ? On Tue, Oct 12, 2010 at 4:20 PM, Jinsong Hu wrote: I tho

Re: blob handling in hive

2010-10-12 Thread Ted Yu
gt; big change. > > > > Jimmy. > > -- > From: "Ted Yu" > Sent: Tuesday, October 12, 2010 4:12 PM > > To: > Subject: Re: blob handling in hive > > How about creating org.apache.hadoop.hive.serde2.io.BytesWritable which >> wraps byte[] ? >> >>

Re: blob handling in hive

2010-10-12 Thread Jinsong Hu
to be touched. I am just wondering if it is possible to get what I want to do without such big change. Jimmy. -- From: "Ted Yu" Sent: Tuesday, October 12, 2010 4:12 PM To: Subject: Re: blob handling in hive How

Re: blob handling in hive

2010-10-12 Thread Ted Yu
single byte, but doesn't work for byte array. > Any way that I can get the byte array returned in sql is appreciated. > > Jimmy > > ---------- > From: "Ted Yu" > Sent: Tuesday, October 12, 2010 2:19 PM > To: > Subjec

Re: blob handling in hive

2010-10-12 Thread Jinsong Hu
PM To: Subject: Re: blob handling in hive One way is to store blob in HBase and use HBaseHandler to access your blob. On Tue, Oct 12, 2010 at 2:14 PM, Jinsong Hu wrote: Hi, I am using sqoop to export data from mysql to hive. I noticed that hive don't have blob data type yet. is the

Re: blob handling in hive

2010-10-12 Thread Ted Yu
One way is to store blob in HBase and use HBaseHandler to access your blob. On Tue, Oct 12, 2010 at 2:14 PM, Jinsong Hu wrote: > Hi, > I am using sqoop to export data from mysql to hive. I noticed that hive > don't have blob data type yet. is there anyway I can do so hive can store > blob ? > >