phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "sunfl@certusnet.com.cn" <su...@certusnet.com.cn>
Subject Re: How to change default field delimiter from COMMA to SEMICOLON
Date Thu, 09 Oct 2014 05:06:45 GMT
Maybe running a program to modify your CSV file to replace any SEMICOLON with COMMA shall be
more convinient. 






 
From: Arthur.hk.chan@gmail.com
Date: 2014-10-09 11:26
To: user
CC: Arthur.hk.chan@gmail.com
Subject: How to change default field delimiter from COMMA to SEMICOLON
Hi, 

My CSV file uses semicolon as field delimiter, I tried to use -d ; but failed.  


1) without -d parameter
./psql.py z1:/hbase -t NATION ../sample/NATION.csv 
14/10/09 11:14:21 ERROR util.CSVCommonsLoader: Error upserting record [19;"SAUDI ARABIA";4;"fluffy
close warthogs into the fluffy gifts kindle silent permanent sauternes-- decoys hang slowly
into the sentiments! forges toward"]: java.lang.NumberFormatException: For input string: "19;"SAUDI
ARABIA";4;"fluffy close warthogs into the fluffy gifts kindle silent permanent sauternes--
decoys hang slowly into the sentiments! forges toward""


2) with -d parameter
./psql.py z1:/hbase -t NATION ../sample/NATION.csv -d ; 

...
 -d,--delimiter <arg>          Field delimiter for CSV loader. A digit is
                               interpreted as 1 -> ctrl A, 2 -> ctrl B ...
                               9 -> ctrl I.
 -e,--escape-character <arg>   Escape character for CSV loader. A digit is
                               interpreted as a control character



CSV sample data:
0;"ARGENTINA";1;"ironic regular realms through the idly thin sauternes could eat boldly regular
daring warthogs-- daringly idle somas could have to lo"
1;"BRAZIL";1;"silently quiet realms haggle boldly slow ruthless platelets? even i"
2;"CANADA";1;"fluffy pinto beans until the asymptotes doze slowly even epitaphs! doggedly
busy excuses sublate carefully: quiet brave asymptotes boost sometimes on th"
9;"IRAN";4;"warthogs could poach even forges? bold bold attainments among the idly permanent
warhorses are permanently in place of the bravely fu"
10;"IRAQ";4;"blithe excuses should have to believe; silent busy notornis print toward the
slowly furious theodolites. even platelets serve bold ruthless tithes? shea"
11;"JAPAN";2;"dolphins can nag! enticingly bold warhorses will unwind never past the grouches;
ironic quick s"


Q: How to change default field delimiter from COMMA to SEMICOLON in psql.py command line?

Regards
Arthur



Mime
View raw message