Hi John! Thanks for response, I use the new latest source code, but I have
follows:
col0, col2 (with counts)
81360, KENYA , 1
81540, FRANCE , 1
81630, IRAN , 1
81720, ETHIOPIA , 1
82082, IRAN , 1
82264, ARGENTINA , 1
82350, IRAN , 1
82350, SAUDI ARABIA , 1
-part.txt is:
# metadata file written by ibis::part::writeMetaData
# on Wed Nov 3 14:51:48 2010 UTC
BEGIN HEADER
Name = "index0"
Description = "/opt/fastbit-ibis1.2.0/examples/.libs/lt-ardea -d /teste/index0
-m "col0:double,col1:key,col2:key,col3:key,col4:key" -t /teste/csv0.csv"
Number_of_columns = 5
Number_of_rows = 6001171
Timestamp = 1288795847
State = 1
index = <bining none/> <encoding equality/>
END HEADER
Begin Column
name = "col0"
data_type = "DOUBLE"
minimum = 0
maximum = 10474950
End Column
Begin Column
name = "col1"
description = col1 = MIDDLE EAST , ASIA , AFRICA , AMERICA
data_type = "CATEGORY"
minimum = 0
maximum = 6001171
End Column
Begin Column
name = "col2"
description = col2 = EGYPT , JAPAN , VIETNAM , IRAN
, ETHIOPIA , JORDAN , UNITED STATES , MOROCCO ,
FRANCE , ..., ROMANIA
data_type = "CATEGORY"
minimum = 0
maximum = 6001171
End Column
thanks
Date: Mon, 1 Nov 2010 13:37:33 -0700
Subject: Re: [FastBit-users] Quote in -o
From: [email protected]
To: [email protected]
CC: [email protected]
Hi, Anderson,
The source code in SVN repository should output all string values with double
quotes now. If you have the time, please give it a try.
John
PS: You can retrieve the latest source code with
svn checkout https://codeforge.lbl.gov/anonscm/fastbit
If the time stamp on files are all based on retrieval time, then it is possible
for the build procedure to invoke flex and bison to regenerate the file *.hh
and *.cc in src directory. Some versions of flex and bison generate incorrect
code. A way to address this problem is to update your installation of flex and
bison to the latest versions. Alternatively, you can delete *.hh and *.cc in
src, and run 'svn update' to retrieve another copy of the files with newer time
stamps, which avoids the need to invoke flex and bison.
On Mon, Nov 1, 2010 at 9:13 AM, K. John Wu <[email protected]> wrote:
Hi, Anderson,
Good observation. We shall output the strings with quotes. Give us a couple
of days.
John
On 11/1/2010 9:10 AM, Anderson Chaves wrote:
Hi John,
By using the ibis noticed that when using the parameter-output to the
output of the query data in comma-separated file, it does not separate
from it in quotes. For example:
part.txt-file is:
# meta data for data partition test written by ibis::tafel::write on
Mon Nov 1 13:09:04 2010
BEGIN HEADER
Name = test
Description = /root/Desktop/fastbit-ibis1.1.9/examples/.libs/lt-ardea
-d /test -m col0:int, col1:double, col3:key -t /test/csv1.csv
Number_of_rows = 2
Number_of_columns = 3
Timestamp = 1288624144
END HEADER
Begin Column
name = col0
data_type = INT
End Column
Begin Column
name = col1
data_type = DOUBLE
End Column
Begin Column
name = col3
data_type = CATEGORY
End Column
this query: SELECT col0, col1, col3 WHERE col1 <3
it generates an output file like this:
col0, col1, col3 (with counts)
1, 87462024688, Nows, mer, 1
2, 87470586299, Whelply, 1
where "Now, mer" is a value of col3 .. have the possibility to add
this quote separately on columns of this type of data?
Thanks
_______________________________________________
FastBit-users mailing list
[email protected]
https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users
_______________________________________________
FastBit-users mailing list
[email protected]
https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users
