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

Forum: ICE Q&A

General questions about ICE

  1. Does ICE loader support the "IGNORE count LINES" clause?

    My engineers are hoping to make use of the "IGNORE count LINES" clause of the LOAD command, like MySQL's loader has. For example: LOAD DATA...

    Started by gbandrews‎, January 26th, 2011 08:36 PM
    • Replies: 6
    • Views: 1,883
    October 17th, 2016, 02:24 AM Go to last post
  2. Smile Why IB restarted from time to time

    Today,we find the IB is out of work,the root cause is IB restart failed for Address bind port already in use. I check the log file: grep...

    Started by jiangguilong2000‎, April 29th, 2016 02:59 AM
    • Replies: 1
    • Views: 8,716
    May 3rd, 2016, 09:34 PM Go to last post
  3. 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 08:04 AM
    • Replies: 3
    • Views: 6,163
    August 31st, 2015, 04:28 PM Go to last post
  4. 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 30th, 2015 11:15 PM
    • Replies: 9
    • Views: 2,956
    August 7th, 2015, 09:49 AM Go to last post
  5. 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 09:04 PM
    • Replies: 2
    • Views: 2,093
    July 1st, 2015, 08:11 PM Go to last post
  6. 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 06:32 PM
    • Replies: 1
    • Views: 1,888
    March 18th, 2015, 08:29 AM Go to last post
  7. 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: 3,900
    February 5th, 2015, 10:53 AM Go to last post
  8. 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: 1,350
    December 19th, 2014, 12:08 PM Go to last post
  9. 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: 2,731
    December 10th, 2014, 11:41 AM Go to last post
  10. 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,915
    December 4th, 2014, 01:04 PM Go to last post
  11. 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: 4,729
    November 12th, 2014, 08:54 PM Go to last post
  12. 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 12:59 AM
    • Replies: 3
    • Views: 1,945
    September 18th, 2014, 07:53 AM Go to last post
  13. 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 10:05 AM
    • Replies: 1
    • Views: 1,353
    September 9th, 2014, 03:31 PM Go to last post
  14. 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 04:40 AM
    ts ctb file
    • Replies: 3
    • Views: 2,693
    August 15th, 2014, 11:14 AM Go to last post
  15. 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 01:14 AM
    data file inodes
    • Replies: 6
    • Views: 4,253
    August 14th, 2014, 09:07 PM Go to last post
  16. 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 10:07 AM
    • Replies: 2
    • Views: 2,613
    July 1st, 2014, 02:45 AM Go to last post
  17. 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 10:02 AM
    flush, infobright, rsync
    • Replies: 7
    • Views: 5,078
    June 20th, 2014, 05:26 AM Go to last post
  18. 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 06:38 AM
    • Replies: 3
    • Views: 1,975
    June 19th, 2014, 10:53 AM Go to last post
  19. 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 03:31 AM
    decimal, infobright, other specific error
    • Replies: 1
    • Views: 3,515
    May 14th, 2014, 09:26 AM Go to last post
  20. 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 03:42 AM
    • Replies: 3
    • Views: 4,012
    May 2nd, 2014, 10:56 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