From: John S. <js...@gm...> - 2011-02-26 06:38:13
|
Your partsupp file is getting interpreted as having 6 columns when it is only supposed to have 5. This line in createdbMultiProcess removes the trailing separators from the rows; maybe you didn't run it. cat $i | sed -e 's/.$//g' > ./dataMultiProcess/$datadir/$i I think we found out that you can turn on lenient mode for the flatfile reader to avoid having to do this munging, but I don't remember fo rsure. JVS "Unix is user friendly; it's just choosy about its friends." On Fri, Feb 25, 2011 at 3:29 AM, kingfesen <mau...@gm...> wrote: > > > John Sichi wrote: >> >> On Wed, Feb 23, 2011 at 9:51 AM, kingfesen <mau...@gm...> >> wrote: >>> sorry john, i've again a problem... i've downloaded a full tpch.tar.gz >>> from >>> link and i've use(by command !run ~/create_table.sql) and >>> create_table.sql >>> (adding a line for create a schema),create_index.sql, but now i've not >>> understand how load data (my file have .tbl extension for example >>> nation.tbl) into a schema. i must to create a file.sql where there are >>> istruction to load data (example insert into tpch.nation * from >>> nation.tbl) >>> or i must create a file wrapper if the second mode is correct how i >>> create >>> this?? >> >> http://pub.eigenbase.org/wiki/LucidDbTpch#LucidDB_Data_Load >> >> The script it is referring to is part of the LucidDB source >> distribution, under luciddb/test/sql/tpch. >> >> https://github.com/eigenbase/luciddb/tree/master/test/sql/tpch >> >> JVS >> >> ------------------------------------------------------------------------------ >> Free Software Download: Index, Search & Analyze Logs and other IT data in >> Real-Time with Splunk. Collect, index and harness all the fast moving IT >> data >> generated by your applications, servers and devices whether physical, >> virtual >> or in the cloud. Deliver compliance at lower cost and gain new business >> insights. http://p.sf.net/sfu/splunk-dev2dev >> _______________________________________________ >> luciddb-users mailing list >> luc...@li... >> https://lists.sourceforge.net/lists/listinfo/luciddb-users >> >> > > i hope this is the last problem message...this database is hostile for me > (or i'm stupid maybe this second one). I've read the guide, downloaded the > tpch.tar.gz file but after i have run init.sql, create_table.sql and > load_tables.sql i've this error... > > 1/9 insert into tpch.partsupp select * from tpch."partsupp"; > error: from line 1, to colum 25: Number of insert target columns (5) does > not equal number of soucre intems (6) (state=,code0). > > Where is my mistake? i've add a file code so it more easy correct my errors! > http://luciddb-users.1374590.n2.nabble.com/file/n6064176/init.sql init.sql > http://luciddb-users.1374590.n2.nabble.com/file/n6064176/create_tables.sql > create_tables.sql > http://luciddb-users.1374590.n2.nabble.com/file/n6064176/load_tables.sql > load_tables.sql > > Thanks you so much for your patience!!! > Regards > -- > View this message in context: http://luciddb-users.1374590.n2.nabble.com/load-sql-data-file-tp6011447p6064176.html > Sent from the luciddb-users mailing list archive at Nabble.com. > > ------------------------------------------------------------------------------ > Free Software Download: Index, Search & Analyze Logs and other IT data in > Real-Time with Splunk. Collect, index and harness all the fast moving IT data > generated by your applications, servers and devices whether physical, virtual > or in the cloud. Deliver compliance at lower cost and gain new business > insights. http://p.sf.net/sfu/splunk-dev2dev > _______________________________________________ > luciddb-users mailing list > luc...@li... > https://lists.sourceforge.net/lists/listinfo/luciddb-users > |