Infobright.org Forums

Warning: An attempt to load decompositions dictionary map failed.

2012-01-26T10:52:07Z

Hello columners,

I have this error message in brighthouse.log:


Warning: An attempt to load decompositions dictionary map failed.

.. it seems bad .. is it as bad as it seems ?

Thanks

Eriam

Using Infobright on Amazon EC2

2011-11-08T23:55:12Z

In a recent blog post, we discussed loading data on Infobright via Amazon EC2 instances using DLP. If you have any questions regarding that thread or using Infobright on EC2, please post them here.

The original blog post is here: http://bit.ly/ib_blog_ec2_dlp

Cloud computing with Infobright and BI Open Source

2011-10-19T10:15:52Z

I was wondering if you have any guidelines or suggestions for those who try to deploy BI solution on the Cloud. I’m at the very early stage of investigation of the subject and hope to get some advice.
Thanks

C_G

P.S. I posted this question in two places because wasn’t sure where it fits best.

Data lake

2011-09-30T09:04:12Z

http://www.forbes.com/sites/ciocentral/2011/08/24/kill-your-data-warehouse/

can infobright handle 100 columns in a multi-billion row table, well?

2011-09-23T11:18:04Z

Hi,

We store billions of rows in an infobright table which currently has about 45 columns. We want to add 50 more columns to it. Will adding these columns bring down the performance of reads? Is creating a new table for these columns a better option? Or, since infobright is a column oriented database additions of 50 extra columns not matter much?

Brighthouse out of resources error

2009-08-12T06:00:50Z

Hi,

When i call the procedure, i got the following error…?

ERROR 9 (HY000): Brighthouse out of resources error: Too many tuples.

See the following log….

2009-08-12 15:27:29 Type conversion for VC:3
2009-08-12 15:27:29 Type conversion for VC:5
2009-08-12 15:27:29 [10] Initial execution plan (non-join):
2009-08-12 15:27:29 [10] Cnd(0): VC:7(t1a0) BET. VC:17(378609) AND VC:18(378609) (4.92)
2009-08-12 15:27:29 [10] Cnd(1): VC:2(t0a0) BET. VC:11(378609) AND VC:12(378609) (8.54)
2009-08-12 15:27:29 [10] Cnd(2): VC:4(t0a2) BET. VC:13 AND VC:14 (16.64)
2009-08-12 15:27:29 [10] Cnd(3): VC:0(t0a4) BET. VC:15(4.94066e-324) AND VC:16(1.79769e+308) (20.42)
2009-08-12 15:27:29 [10] Packs/packrows after KN evaluation:
2009-08-12 15:27:29 [10] (t0) Pckrows: 11324, susp. 7 (11317 empty 0 full). Packs opened in 3 cond.: 263
2009-08-12 15:27:29 [10] (t1) Pckrows: 302, susp. 9 (293 empty 0 full). Packs opened in 1 cond.: 9
2009-08-12 15:27:29 [10] Packrows after exact evaluation (WHERE):
2009-08-12 15:27:29 [10] (t0): 11324 all packrows, 1 to open (including 0 full)
2009-08-12 15:27:29 [10] (t1): 302 all packrows, 1 to open (including 0 full)
2009-08-12 15:27:29 [10] Join execution plan:
2009-08-12 15:27:29 [10] Cnd(4): VC:1(t0a1) = VC:8(t1a1) (36.45)
2009-08-12 15:27:29 [10] Traversed all 502 rows.
2009-08-12 15:27:29 [10] Produced 502 tuples.
2009-08-12 15:27:29 [10] Tuples after inner join 0-1 [hash]: 502
2009-08-12 15:27:29 [10] Aggregating: 502 tuples left.
2009-08-12 15:27:29 [10] Aggregated (1 gr). Omitted packrows: 0 + 1 partially, out of 1 total.
2009-08-12 15:27:29 Type conversion for VC:35
2009-08-12 15:27:29 Type conversion for VC:37
2009-08-12 15:27:29 [10] Error: Too many tuples.

How to solve this error?

Regards,
S.Ashokkumar.

Bill Inmon vs. Ralph Kimball vs. Data Vault Model

2009-07-22T09:40:29Z

Hi,

It is easy to see the place of Infbright server in the Kimball model.
I would like to hear some opinions what role would Infobright server play in the Inmon’s model of enterprise.
To be prcize, I wonder what is the best place for Infobright server if the enterprize direction is a centalized Data Warehouse modelled in the 3rd normal form being the one and only source for all possible marts.

I appended this entry to include the newest aproch to data warehose that is Data Vault Model to the comparison.

thanks
C_George

How to explain the content of error log?

2011-03-08T22:49:19Z

Hello.
When I use left join to contact two big tables in brighthouse engine, lots of important messages are generated in the error log.But I can not know what they stand for.
Any one who explain the attachment to me will be big appreciated.

tpc-h query 21 question

2011-01-26T22:14:10Z

I use scala=10 dataset
the orignal cannot get result
but I translate one of the join into subquery,it works cost about 2 hours
why?
21

ct
         s_name,
         count(*) as numwait
 from
         supplier,
         lineitem l1,
         orders,
         nation
 where
         s_suppkey = l1.l_suppkey
         and o_orderkey = l1.l_orderkey
         and o_orderstatus = 'F'
         and l1.l_receiptdate > l1.l_commitdate
         and exists (
                 select
                         *
                 from
                         lineitem l2
                 where
                         l2.l_orderkey = l1.l_orderkey
                         and l2.l_suppkey <> l1.l_suppkey
         )
         and not exists (
                 select
                         *
                 from
                         lineitem l3
                 where
                         l3.l_orderkey = l1.l_orderkey
                         and l3.l_suppkey <> l1.l_suppkey
                         and l3.l_receiptdate > l3.l_commitdate
         )
         and s_nationkey = n_nationkey
         and n_name = 'IRAN'
 group by
         s_name
 order by
         numwait desc,
         s_name
 limit 10; 

fixed 21

select s_name ,count(*) as numwait from
(select
        s_name,l_suppkey ,l_orderkey
        -- count(*) as numwait
from
        supplier,
        lineitem l1,
        orders,
        nation
where
        s_suppkey = l1.l_suppkey
        and o_orderkey = l1.l_orderkey
        and o_orderstatus = 'F'
        and l1.l_receiptdate > l1.l_commitdate
        and s_nationkey = n_nationkey
        and n_name = 'IRAN'
) L1 
where exists (
                  select
                          *
                  from
                          lineitem l2
                  where
                          l2.l_orderkey = l1.l_orderkey
                          and l2.l_suppkey <> l1.l_suppkey
          )
          and not exists (
                  select
                          *
                  from
                          lineitem l3
                  where
                          l3.l_orderkey = l1.l_orderkey
                          and l3.l_suppkey <> l1.l_suppkey
                          and l3.l_receiptdate > l3.l_commitdate
          )
group by
        s_name
order by
        numwait desc,
        s_name
limit 10; 

Migrating from 3.4.2 to 3.5.2

2011-02-07T22:32:38Z

Hi to all,

Im using ICE 3.4.2 and i would like to try the new 3.5.2 version, how can i migrate all my databases?, do i have to copy and replace all the “data” folder?

Thanks a lot

jegordon