Re: [MonetDB-users] Load a file.txt in bats

Hi Mike, before going into details about MAL (I'd need to look that up myself) my question is why are you using MAL and not standard SQL? In SQL, you could easily load your table using CREATE TABLE MyTable (Col_1 int, Col_2 int, Col_3 int); COPY RECORDS INTO MyTable FROM '' USING DELIMITERS ';',';\n'; E.g.: $ cat /tmp/data.csv 11;21;31; 12;22;32; 13;23;33; $ mclient -lsql Welcome to mclient, the MonetDB/SQL interactive terminal Database: MonetDB v5.18.2, 'demo' Type \q to quit, \? for a list of available commands auto commit mode: on sql>CREATE TABLE MyTable (Col_1 int, Col_2 int, Col_3 int); operation successful sql>COPY 3 RECORDS INTO MyTable FROM '/tmp/data.csv' USING DELIMITERS ';',';\n'; 3 affected rows sql>select * from MyTable; +-------+-------+-------+ | col_1 | col_2 | col_3 | +=======+=======+=======+ | 11 | 21 | 31 | | 12 | 22 | 32 | | 13 | 23 | 33 | +-------+-------+-------+ 3 tuples sql> I would recommend to use plain MAL directly, only if you have a very special reason to do so that prohibits using SQL. Stefan On Wed, Mar 24, 2010 at 10:33:54AM +0100, Miguel Ángel Águila Lorente wrote:

Hello,

I'm creating a database with MAL. I would need help for creating bats with the information of a file. May be It could be posible to do with tablet.load but I still not know how it works. The format of the file is quite simple:

int;int;int; int;int;int;

I expect you can help me. Thank you.

Mike

------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

-- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4199 |