+ Post New Thread
Page 1 of 41 1 2 3 11 ... LastLast
Threads 1 to 20 of 809

Forum: ICE Q&A

General questions about ICE

  1. Wrong result from left join with exact number of rows in joined tables

    Hi, We are using Infobright-4.0.7 CE (IB_4.0.7_r16961_17249(ice)). I have found strange issue. Left join of 2 tables produces wrong result with...

    Started by ekotsinova‎, August 31st, 2015 09:04 AM
    • Replies: 3
    • Views: 972
    August 31st, 2015, 05:28 PM Go to last post
  2. Infobright automatic restart ,mysqld got signal 11 or 9

    Our infobright server frequent restart for got signal 11 or got signal 9. I didn't do special operations and no specific sql had been executed.It...

    Started by podol‎, July 31st, 2015 12:15 AM
    • Replies: 9
    • Views: 957
    August 7th, 2015, 10:49 AM Go to last post
  3. querying a table while loading will lock the table

    Hi I used ICE for some days and I have a question now. When I do a select command for a table and may be it will takes few minutes, and at the...

    Started by cluo‎, June 30th, 2015 10:04 PM
    • Replies: 2
    • Views: 1,358
    July 1st, 2015, 09:11 PM Go to last post
  4. Question Infobright ICE or Enterprise ? or none of them ?

    Hi, Being a user for some time of ICE and doing analytics on top of average sized data (daily ~10Gb), i've now got a new requirement for a project...

    Started by fourat‎, March 17th, 2015 07:32 PM
    • Replies: 1
    • Views: 1,408
    March 18th, 2015, 09:29 AM Go to last post
  5. Smile Slow Querys when DATE NOW() functions used.

    Hi, I have some ICE servers for testing support now, and some tables like: CREATE TABLE `test1` ( `event_date` TIMESTAMP NOT NULL DEFAULT...

    Started by muyprofesional‎, December 19th, 2014 10:35 AM
    brighthouse, ice, query, question, slow
    • Replies: 6
    • Views: 1,963
    February 5th, 2015, 10:53 AM Go to last post
  6. ICE errors "Buffer Too Small "

    Hi again :S Some queries are failing with "Buffers Too Small" errors, i where changing this parameters in the ICE engine, and i recibe less erros...

    Started by muyprofesional‎, December 19th, 2014 10:48 AM
    • Replies: 1
    • Views: 888
    December 19th, 2014, 12:08 PM Go to last post
  7. Many Servers - 1 DataDir

    Hi, I've tree servers configured vs 1 unc datadir. The first server I boot, is able to query data on realtime, each time I do a LOAD, the query shows...

    Started by muyprofesional‎, December 10th, 2014 10:25 AM
    datadir, ice
    • Replies: 3
    • Views: 989
    December 10th, 2014, 11:41 AM Go to last post
  8. Error: Insufficient memory/disk space

    I'm upgrading ICE on AWS from m1.xlarge instance to r3.2xlarge instance. Running same query and using same data, the query on the larger instance...

    Started by ariek‎, November 7th, 2014 07:10 AM
    • Replies: 3
    • Views: 1,404
    December 4th, 2014, 01:04 PM Go to last post
  9. Converting MyISAM to BRIGHTHOUSE

    Hi I'm new to ICE. I heard the first words about it at the MySQL customer conference in London a few weeks back. I currently have a MySQL...

    Started by anderskvist‎, November 7th, 2008 07:55 AM
    • Replies: 9
    • Views: 3,068
    November 12th, 2014, 08:54 PM Go to last post
  10. upgrade from ICE to IEE

    Hi All, I have installed ICE and now want to upgrade it to IEE trial version, so i have following questions: 1. Is it possible to upgrade...

    Started by rakeshd‎, September 18th, 2014 01:59 AM
    • Replies: 3
    • Views: 1,511
    September 18th, 2014, 08:53 AM Go to last post
  11. End Of Life Of infobirght 4.5 IEE

    Someone know what is the End Of Life of Infobright 4.5 IEE?

    Started by kanondark1‎, September 9th, 2014 11:05 AM
    • Replies: 1
    • Views: 979
    September 9th, 2014, 04:31 PM Go to last post
  12. A file named TS00000.ctb

    Hi, I want to ask a question: Once there is a file named TS00000.ctb in my table file .bht,my log could not be loaded into db any more. but if i...

    Started by cluo‎, August 14th, 2014 05:40 AM
    ts ctb file
    • Replies: 3
    • Views: 1,207
    August 15th, 2014, 12:14 PM Go to last post
  13. there is not so many inodes fo millions of data files

    hi everyone! my team used infobright these days and now there is a problem we meet . for some reasons, we need create several database per day and...

    Started by cluo‎, May 21st, 2014 02:14 AM
    data file inodes
    • Replies: 6
    • Views: 1,863
    August 14th, 2014, 10:07 PM Go to last post
  14. Problems loading data into ICE (ERROR 2 (HY000): Wrong data or column definition)

    I'm doing evaluations of several columnar databases for a data warehousing project. I'm currently working with ICE, but i've been stuck on the...

    Started by dabobert‎, March 17th, 2011 11:07 AM
    • Replies: 2
    • Views: 1,637
    July 1st, 2014, 03:45 AM Go to last post
  15. is there a way to 'flush tables ...' in infobright?

    hi Infobright! i copy tables from one host to another using rsync. the problem is that infobright won't update (cached) table content when it's...

    Started by atti‎, April 17th, 2014 11:02 AM
    flush, infobright, rsync
    • Replies: 7
    • Views: 2,415
    June 20th, 2014, 06:26 AM Go to last post
  16. Errors with ice break and infobright bulk loader

    Hi everyone, I'm new to Infobright and actually also a beginner/novice at databases, data warehousing (I'm a student) so excuse my ignorance.. I...

    Started by sallychen‎, June 19th, 2014 07:38 AM
    • Replies: 3
    • Views: 1,281
    June 19th, 2014, 11:53 AM Go to last post
  17. ERROR 1105 (HY000): Brighthouse other specific error

    Hi, mysql> CREATE TABLE Test123 ( Col1 decimal(18,6), Col2 decimal(18,6), Col3 decimal(18,6)); Query OK, 0 rows affected (0.01 sec) mysql>...

    Started by Murali‎, May 14th, 2014 04:31 AM
    decimal, infobright, other specific error
    • Replies: 1
    • Views: 1,535
    May 14th, 2014, 10:26 AM Go to last post
  18. Question can read operation block write operation on the same table?

    One short question, is it true that read operation can lock the write operation on the same table? The details: we have one time-consuming query,...

    Started by lwang‎, April 21st, 2014 04:42 AM
    • Replies: 3
    • Views: 1,822
    May 2nd, 2014, 11:56 AM Go to last post
  19. IEE - best practice to store searchable varchar type unique identifier

    Currently I have a column that contains a varchar value shaped like this: #_#######_###########_##########. It is a concatenation of 4 different...

    Started by evaleah‎, May 1st, 2014 11:47 AM
    bigint, enterprise edition, uuid
    • Replies: 5
    • Views: 1,982
    May 1st, 2014, 05:09 PM Go to last post
  20. Loading speed into table with text column is low

    I create a table with 18 columns, and the type of one column is text. The charset is utf8 and the type of other columns is bigint. When loading ,...

    Started by mkfive‎, April 22nd, 2014 10:22 AM
    • Replies: 2
    • Views: 1,467
    April 22nd, 2014, 11:29 AM Go to last post


Thread Display Options

Use this control to limit the display of threads to those newer than the specified time frame.

Allows you to choose the data by which the thread list will be sorted.

Order threads in...

Note: when sorting by date, 'descending order' will show the newest results first.

Icon Legend

Contains unread posts
Contains unread posts
Contains no unread posts
Contains no unread posts
More than 15 replies or 150 views
Hot thread with unread posts
More than 15 replies or 150 views
Hot thread with no unread posts
Closed Thread
Thread is closed
Thread Contains a Message Written By You
You have posted in this thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts