ah ... try :
https://issues.apache.org/jira/browse/HIVE-136
it says that one can escape using:
CREATE TABLE table1 (a STRING, b STRING)
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' ESCAPED BY '\\';
Cheers,
Ajo
2011/2/17 안의건
> Dear All
>
> Thank you for who gave me advices, but it seems th
Dear All
Thank you for who gave me advices, but it seems that I didn't explained my
problem exactly.
I have asked a question regarding 'Imporing a file wich include delimiter
into HIVE'.
In this case, I need to import a file wich includes " | " pipe without
terminating the importing process.
As
Or try the ascii value like "*DELIMITED FIELDS TERMINATED BY '124'*"
See if that helps.
Cheers!
On Mon, Feb 14, 2011 at 9:44 PM, Ajo Fod wrote:
> use delimited by "|" ... are you using this syntax:
>
> Are you saying that the syntax here not work for you?
> http://wiki.apache.org/hadoop/Hive
use delimited by "|" ... are you using this syntax:
Are you saying that the syntax here not work for you?
http://wiki.apache.org/hadoop/Hive/LanguageManual/DDL#Create_Table
... if you tried this ... ccould it be that the error may be caused by
something else.
Cheers,
-Ajo
On Mon, Feb 14, 20
