Hello Bjørn,
2011/4/4 Bjørn Remseth <la3...@gmail.com>:
> Hi guys
>
> I'm having a problem: I'm reading a file where fields are terminated
> by space (' ', ascii 32) into a table. I'm not making these files
> so I can't easily change this use of ' ' as field separator.
As documented at
http://wiki.apache.org/hadoop/Hive/LanguageManual/DDL, you may use the
octal number for the character as your field terminator.
The following should work, hence:
CREATE EXTERNAL TABLE logdata(
xxx STRING,
yyy STRING,
...
z_t)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY '\040'
STORED AS TEXTFILE;
--
Harsh J
Support Engineer, Cloudera
