Joinutility seperatorLogin utility separator Infobright.com
   
 
Bulk Load How it works?
Posted: 12 March 2010 10:48 AM   Ignore ]  
Newbie
Rank
Total Posts:  9
Joined  2010-02-27

Hello, I wonder how the bulk load, if you have any manual or something, because I do not go well and I like to see on that ruling and I have to change for me out properly. Thank you very much and I hope you can help.

Marc

PD: If possible answer in Spanish best =)! Thanks

Profile
 
Posted: 12 March 2010 11:07 AM   Ignore ]   [ # 1 ]  
Sr. Member
Avatar
RankRankRankRank
Total Posts:  651
Joined  2008-08-18

Do you mean something like that: http://www.infobright.org/Forums/viewannounce/584_30/
No hay en español, lo siento.

Profile
 
Posted: 12 March 2010 11:20 AM   Ignore ]   [ # 2 ]  
Newbie
Rank
Total Posts:  9
Joined  2010-02-27

Thanks but I am interested in the Bulk Load, not in the Load Data.

Thanks

Profile
 
Posted: 12 March 2010 11:24 AM   Ignore ]   [ # 3 ]  
Sr. Member
Avatar
RankRankRankRank
Total Posts:  723
Joined  2008-08-18

Marc,

Perdóneme por favor si cometo errores en mi español.

¿En cuál versión y edición está la prueba?

Por curiosidad ¿De dónde es usted?  Soy tejano y viví en Colombia por dos años.

Vea este documento para el cargamento de los datos aquí.

Si usted está utilizando Infobright Enterprise Edition, debe incluir este:

mysqlSET @bh_dataformat='txt_variable'

antes de ‘LOAD DATA INFILE ...’

¿Cuáles resultados usted ha experimentado?  Tambien, ¿Cuál es su plataforma de computadora?

Nos hablamos más tarde.

[ Edited: 13 March 2010 09:15 AM by David Lutz]
Signature 
Profile
 
Posted: 12 March 2010 11:25 AM   Ignore ]   [ # 4 ]  
Sr. Member
Avatar
RankRankRankRank
Total Posts:  723
Joined  2008-08-18
Marc - 12 March 2010 11:20 AM

Thanks but I am interested in the Bulk Load, not in the Load Data.

Thanks

Bulk Loader, the Infobright High Performance Loader, is executed via ‘LOAD DATA INFILE ...’.

Signature 
Profile
 
Posted: 14 March 2010 02:42 PM   Ignore ]   [ # 5 ]  
Sr. Member
Avatar
RankRankRankRank
Total Posts:  651
Joined  2008-08-18

Hi !

There is no command “Bulk Load” in IB. As David has said, if you mean the process of fast loading, issue

SET @bh_dataformat='txt_variable'
LOAD DATA INFILE ... ; 

with syntax according to the documents pointed by the links above.

Profile
 
Posted: 12 April 2010 10:29 AM   Ignore ]   [ # 6 ]  
Newbie
Rank
Total Posts:  9
Joined  2010-02-27

I am currently using the Pentaho platform, which use Kettle, Kettle then we find that there is Bulk Loading Infobright function, but more I try I can not find any correct result, I never go well, was to have if you could help me with that. Infobright currently, I do not remember if I use the Community or the Enterprise, because most of the task is performed with Kettle.

I hope I appreciate any help, since eh solutions tested above, and no me time to run successfully.

Thanks =)

Profile
 
Posted: 12 April 2010 01:07 PM   Ignore ]   [ # 7 ]  
Sr. Member
Avatar
RankRankRankRank
Total Posts:  454
Joined  2008-08-18

Hi Marc,

Did you try using the Infobright bulk loader component from Kettle? What specific issues did you have when trying to use it?

Thanks
Geoffrey

Signature 
Profile
 
Posted: 14 April 2010 11:44 AM   Ignore ]   [ # 8 ]  
Newbie
Rank
Total Posts:  9
Joined  2010-02-27

The issues I have are the following:

If I have 50 tables, and I just want to carry a load of data to 1 specifies how he knows that the Bulk Load infobright?

What steps do I have to get it to work properly.

And finally someone could provide a user manual step by step, and looked around here eh but I do not serve any. No one has any information?

Thanks =)

Profile