Re: [luciddb-users] load .sql data file

[kingfesen <mau...@gm...>]

John Sichi wrote:
> 
> 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
>>
> 
> ------------------------------------------------------------------------------
> 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
> 
> 

finally the data is loaded! Now I have some questions about how to connect
via jdbc to my connect.java. the database does not answer me what did I do
wrong?

import java.sql.*;
import java.io.*;

public class connect1 {
    public static void main(String[] args) {
        Connection conn = null;
        try {

        String url = "jdbc:luciddb://localhost:5434";

	Class.forName("org.luciddb.jdbc.LucidDbClientDriver").newInstance();
        conn = DriverManager.getConnection(url);

	System.out.println("Connesso al database!!!\n");
        conn.close();
        } catch (Exception e) {
        }
    }
} 

i've set jdbc driver into my classpath
(CLASSPATH:=~/luciddb-0.9.3/plugin/LucidDbClientDriver.jar)

i've to set a schema? what is wrong?if I can establish a connection then I
can run tests on query tpch

Regards

-- 
View this message in context: http://luciddb-users.1374590.n2.nabble.com/load-sql-data-file-tp6011447p6076771.html
Sent from the luciddb-users mailing list archive at Nabble.com.