hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Yichuan (William) Hu" <huyich...@gmail.com>
Subject Re: Loaded data all NULL
Date Fri, 01 Jul 2011 18:31:52 GMT
I tried \\d instead of \d, problem solved. Thanks, Neerja!

On Fri, Jul 1, 2011 at 2:28 PM, Neerja Bhatnagar <bneerja@gmail.com> wrote:
> Hi,
> When I was having this issue, it was due to 2 problems - 1. the slashes in
> the regex need to be escaped Java-style so \d would be \\d and my regex's
> were wrong.
> Hope this helps!
> Cheers, Neerja
>
> On Fri, Jul 1, 2011 at 11:16 AM, Yichuan (William) Hu <huyichuan@gmail.com>
> wrote:
>>
>> Hi,
>>
>> I am doing some simple tests to create table, load data using Hive. I
>> am working on the VM provided by cloudera
>> (https://ccp.cloudera.com/display/SUPPORT/Cloudera%27s+Hadoop+Demo+VM).
>>
>> I have a text file with each line containing an IP address and a name,
>> e.g.,
>>
>> 123.45.67.89 tom
>> 123.45.67.92 mark
>>
>> I create a table using following command:
>>
>> CREATE TABLE ip_name(
>> ip STRING,
>> name STRING
>> )
>> ROW FORMAT SERDE 'org.apache.hadoop.hive.contrib.serde2.RegexSerDe'
>> WITH SERDEPROPERTIES(
>> "input.regex" = "^([\d.]+) ([a-z]+)",
>> "output.format.string" = "%1$s %2$s"
>> )
>> STORED AS TEXTFILE;
>>
>> Then, I use the following command to load data into the table:
>>
>> LOAD DATA LOCAL INPATH '/home/cloudera/test.txt' OVERWRITE INTO TABLE
>> ip_name;
>>
>> Table was successfully created and file was also loaded, but all are
>> NULL (the number of rows in the table is the same as the number of
>> rows in the file). What could be the problem?
>>
>> Thanks a lot!
>>
>> William
>
>
>
> --
> Thank you! Neerja
>
>

Mime
View raw message