But, default is ^A, right? My question is why it is not taking? Is it an issue with hive version? Thanks and Regards, Ashish Garg
On Thu, May 29, 2014 at 9:11 PM, Siddharth Tiwari <siddharth.tiw...@live.com > wrote: > > You can write a SerDe to handle the control character. > > **------------------------** > *Cheers !!!* > *Siddharth Tiwari* > Have a refreshing day !!! > *"Every duty is holy, and devotion to duty is the highest form of worship > of God.” * > *"Maybe other people will try to limit me but I don't limit myself"* > > > ------------------------------ > Date: Thu, 29 May 2014 19:26:56 -0400 > Subject: Control_A_Error > From: gargcreation1...@gmail.com > To: user@hive.apache.org > > > Can you try to fix this problem? > > I have a local file called mytest.txt (restored in hdfs already). The > content is like this: > > $ cat -A HDFSLOAD_DIR/mytest.txt > > 49139801^A25752451^Aunknown$ > > 49139801^A24751754^Aunknown$ > > 49139801^A2161696^Anice$ > > > > To load this raw data above, I then defined the table like this in HQL: > > > > create table my_test( > > userid BIGINT, > > movieId BIGINT, > > comment STRING > > ) > > ROW FORMAT DELIMITED > > FIELDS TERMINATED BY '\001' > > STORED AS TEXTFILE; > > > > My problem is that when I “SELECT * FROM my_test;” , I got this: > > > > NULL NULL NULL > > NULL NULL NULL > > NULL NULL NULL > > > > I then replace “^A” with “^” in mytest.txt, and also re-defined my table > structure by using : > > FIELDS TERMINATED BY '^’ > > > > So when I select all, I got the correct results. > > > > Any thoughts??? Thanks in advance. >
