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

Forum: ICE Q&A

General questions about ICE

  1. 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: 45
    July 1st, 2015, 08:11 PM Go to last post
  2. 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,096
    March 18th, 2015, 08:29 AM Go to last post
  3. 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 09:35 AM
    brighthouse, ice, query, question, slow
    • Replies: 6
    • Views: 1,589
    February 5th, 2015, 09:53 AM Go to last post
  4. 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 09:48 AM
    • Replies: 1
    • Views: 630
    December 19th, 2014, 11:08 AM Go to last post
  5. 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 09:25 AM
    datadir, ice
    • Replies: 3
    • Views: 706
    December 10th, 2014, 10:41 AM Go to last post
  6. 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 06:10 AM
    • Replies: 3
    • Views: 1,152
    December 4th, 2014, 12:04 PM Go to last post
  7. 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 06:55 AM
    • Replies: 9
    • Views: 2,472
    November 12th, 2014, 07:54 PM Go to last post
  8. 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,202
    September 18th, 2014, 07:53 AM Go to last post
  9. 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: 753
    September 9th, 2014, 03:31 PM Go to last post
  10. 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: 862
    August 15th, 2014, 11:14 AM Go to last post
  11. 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: 1,481
    August 14th, 2014, 09:07 PM Go to last post
  12. 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: 1,315
    July 1st, 2014, 02:45 AM Go to last post
  13. 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: 1,961
    June 20th, 2014, 05:26 AM Go to last post
  14. 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: 924
    June 19th, 2014, 10:53 AM Go to last post
  15. 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: 1,205
    May 14th, 2014, 09:26 AM Go to last post
  16. 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
    lock
    • Replies: 3
    • Views: 1,567
    May 2nd, 2014, 10:56 AM Go to last post
  17. 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 10:47 AM
    bigint, enterprise edition, uuid
    • Replies: 5
    • Views: 1,652
    May 1st, 2014, 04:09 PM Go to last post
  18. 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 09:22 AM
    • Replies: 2
    • Views: 1,246
    April 22nd, 2014, 10:29 AM Go to last post
  19. ERROR 5 (HY000) at line 2: Shrinking histogram is not allowed.

    I use ICE 4.0.7, and load data into a table in infobright every day. At the beginning , some data was load into table succeed yesterday, but then I...

    Started by podol‎, March 4th, 2014 08:09 PM
    2 Pages
    1 2
    error 5
    • Replies: 19
    • Views: 3,978
    March 20th, 2014, 09:14 AM Go to last post
  20. 1105 - Brighthouse other specific error

    I use ICE 4.0.7, and load data into a table in infobright every day. When I open the table, there is a error: 1105 - Brighthouse other specific...

    Started by podol‎, March 6th, 2014 02:26 AM
    • Replies: 4
    • Views: 1,901
    March 14th, 2014, 03:31 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