Hi, Anderson, Looks like I did do a good job of fixing all codes that print strings. It would make my job of tracking down which function actually did the printing if you can share the command line you've used. If you can share a sample of you data, it would make my live even easier. Thanks.
John On 11/3/2010 9:38 AM, Anderson Chaves wrote: > 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] > <mailto:[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] <mailto:[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 _______________________________________________ FastBit-users mailing list [email protected] https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users
