Infobright.org Forums

ICE Data Loading using Telend

2012-02-03T08:56:04-04:00

Hi All,

Can any one tell me.
Is ICE supports Data Loading using Telend ?

Thanks,
Rajeev

ICE 4.0 Feature request - Create Temp Tables.

2012-01-25T15:53:59-04:00

We are testing ICE 4.0 and currently trying to run some reports using MicroStrategy. One main limitation for running reports is not having “Create Temporary Table” option in ICE, since Microstrategy creates temporary tables for running reports (except for free from SQL option which we dont want test.) for executing queries.

We cannot download IEE since its having limited trial period and our tests can run for couple of months. Is there any possibility now or in near future to add “create temp table” functionality to ICE ?

The datafile .ctb question

2011-11-14T01:19:04-04:00

Hi All
I found the data ctb file that When the column data more than 1M, data/test/my_1 / will generate the second data file TA0000100000000.ctb
Since then, each load will alternately write the two files（TA0000100000000.ctb+TA0000100000001.ctb）,
Why does this design?

and other quesion
the data manager ppt said that
“
Once the cluster size limit has been reached, Infobright creates a new file to store the
additional Data Packs.
”
myfile is much less than 2G

appreciate for your reply……

Infobright ICE on Mac OS/X

2010-07-14T15:01:42-04:00

Any interest in having us port ICE to OS/X on the Mac?

GROUP_CONCAT not supported by Infobright

2010-07-29T14:23:13-04:00

Hi,

I have a few queries that do something like:

select t1.id, t2.names
from table1 t1
left join (
select id,group_concat(name) as names
from table2
group by id
) t2 on (t2.id=t1.id)
group by t1.id;

If I run the select in the left join by itself it runs pretty fast:

select id,group_concat(name) as names
from table2
group by id;

But when I add the group_concat into another query (inside the left join or any other complex query) it takes forever to run even when the tables just have a few thousand rows.

Are there any plans to implement group_concat on Infobright so that queries don’t run on MySQL engine?

Thanks,

Ivan.

Infobright Crash

2011-07-01T09:22:47-04:00

Hi,

I’ve got some problem of crash with IB
I do not understand the reason

You can find in attachement the bh.err and my config’s files

Hope someone can help me.

It’s a little urgent because i’m on production…..

Thanks in advance

Regards,

Jean-Philippe

Create As Select and lookup

2011-03-31T10:15:14-04:00

I often create tables with the use of “create table table_name as select…”. By looking at “show create table” I noticed that Infobright will sometimes create lookups in such tables (“comment ‘lookup’”).

Is there a way to control which field will be created as a lookup in a “create table .. as select ..” statement?

Thanks,
Radek

Installation problem - Infobright IEE trail

2011-02-01T15:03:20-04:00

After installation based on the youtube video, When infobright command line client is invoke , it closes automatically

regards
padmi

Allow INSERTs from SELECTS

2011-02-21T08:56:06-04:00

Hi,

First, thanks for all the features available in ICE.
I know that you keep DML for the enterprise version for commercial purposes.
Even though there are great open source ETL softwares available, I like to run some of the transformations directly in ICE because of its excellent speed.
The DML functions I miss the most are:
1. TRUNCATE TABLE - I know about and actually use the stored procedure which recreates the table. But I think this could be made available without the need for the stored procedure.
2. INSERT INTO ... SELECT ... : INSERTs directlly from the result of a query: I know you can export the result from a query and then load it afterwards and that’s what I currently do, but this seems so awkward and time consuming (and also disk space consuming). But allowing inserts from a query would make it follow the standards and much easier to use in transformations.
3. A way to delete the files used in the dumping and loading routines like the one above since currently I need to dump the result of the query and reload it afterwards. But how can I delete this file from an Infobright connection?

Thank you.

Luis Fernando

when will ICE supports parallel?

2010-12-24T01:16:35-04:00

even 1/2 of cpu cores