+ Post New Thread
Page 1 of 3 1 2 3 LastLast
Threads 1 to 20 of 59

Forum: Technical Tips & Tricks

Postings regarding tips & tricks of use to the ICE community

  1. Renaming tables in Infobright

    I get asked on a regular basis as to how to rename a table. Unfortunately, today, we don't have the alter table command. It is fortcoming later this...

    Started by CarlGelbart‎, May 8th, 2009 05:47 PM
    2 Pages
    1 2
    • Replies: 17
    • Views: 4,046
    Yesterday, 09:28 AM Go to last post
  2. Lightbulb Leveraging the CSV Engine for data merge scenarios

    Here's an observation regarding OUTFILE behavior between MyISAM and BRIGHTHOUSE tables, and how one can get around the limitations if trying to...

    Started by TWKnight‎, May 14th, 2015 10:03 AM
    csv, delta, load data infile, myisam, outfile
    • Replies: 0
    • Views: 15,467
    May 14th, 2015, 10:03 AM Go to last post
  3. Installing multiple instances of ICE with RPM

    I have developed and tested the following method for installing a second instance of ICE (and/or IEE) on a single physical server after an initial...

    Started by david‎, July 30th, 2010 05:07 PM
    • Replies: 9
    • Views: 8,656
    October 31st, 2014, 08:01 AM Go to last post
  4. Exclamation Port 5029

    HI, I had some problems with de cfg of Infobright. I'm trying to connect trought port 5029, but show this: ERROR N° 1045 Access denied for user...

    Started by FOXSPY‎, September 29th, 2014 12:36 PM
    • Replies: 1
    • Views: 1,745
    September 29th, 2014, 01:26 PM Go to last post
  5. Infobright audit trail

    Is there any way of auditing all commands sent to infobright database? Is there a tool for doing that? If not, how I could code it? Writing...

    Started by lucas.amaral‎, September 20th, 2014 12:46 PM
    audit sql
    • Replies: 1
    • Views: 2,339
    September 21st, 2014, 08:53 PM Go to last post
  6. Ice Breaker for SQL SERVER : No tables found in specified database error !

    I installed the latest version of Ice Breaker for SQL. We are using SQL 2012. I have entered the required details into the fields; SeverName...

    Started by EdwardsEA‎, March 20th, 2014 02:37 PM
    • Replies: 7
    • Views: 4,209
    March 21st, 2014, 07:23 AM Go to last post
  7. Arrow slow query of IEE

    i have installed the iee-trial. And i load one billion data into table GPRS_USER_SERVICE_BDR. afer executing some simple queries,i found that the...

    Started by 724150880‎, February 28th, 2014 04:09 AM
    query ability
    • Replies: 3
    • Views: 3,618
    March 3rd, 2014, 04:59 AM Go to last post
  8. ERROR 1286 (42000): Unknown table engine 'brighthouse'

    Hi, I have installed IEE on my HDP 2.0 cluster. I cretaed tables using engine=brighthouse but still it's taking engine as MyISAM. when i listed...

    Started by saipm‎, November 5th, 2013 12:36 AM
    • Replies: 1
    • Views: 2,292
    November 5th, 2013, 08:00 AM Go to last post
  9. Infobright limits

    Hi, I'm considering IB for an upcoming project but have some basic questions: What is the maximum number of tables you can put into an...

    Started by Btaub‎, April 16th, 2013 06:50 AM
    • Replies: 6
    • Views: 14,317
    April 16th, 2013, 12:59 PM Go to last post
  10. I there a way I can use Select Roughly to determine which value has the most occurrences?

    I there a way I can I use Select Roughly or is there another effiecent way to determine which value has the most occurrences? I understand I can...

    Started by jemken‎, March 25th, 2013 09:07 PM
    • Replies: 4
    • Views: 3,919
    March 27th, 2013, 08:03 AM Go to last post
  11. Is there any way to "concat" tables without creating a temporary table?

    I have a table with ~300M rows, and perform a simple select over it SELECT serialno from me_0; This query is blazing fast, taking 0.156s...

    Started by Chuu‎, February 20th, 2013 02:34 PM
    • Replies: 1
    • Views: 1,601
    February 22nd, 2013, 04:31 AM Go to last post
  12. tpch1

    hi, i run the query: select l_returnflag, l_linestatus, sum(l_quantity) as sum_qty, ...

    Started by omidvd‎, November 29th, 2012 08:21 AM
    • Replies: 5
    • Views: 2,086
    November 29th, 2012, 01:33 PM Go to last post
  13. benchmarking

    hi, i am performing a benchmark betean infobright and MSSQL on the same machine with the same hardware. i am running on database tpch...

    Started by omidvd‎, November 29th, 2012 06:27 AM
    • Replies: 5
    • Views: 2,051
    November 29th, 2012, 12:58 PM Go to last post
  14. Unable to start up Inforbright server from linux

    /usr/local/infobright/bin/mysqld 120202 23:16:32 Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!...

    Started by f1kalyan‎, February 2nd, 2012 06:33 PM
    • Replies: 5
    • Views: 3,848
    November 14th, 2012, 06:24 PM Go to last post
  15. What is the correct EDITION= parameter for?

    Hi, I'm trying to compile Infobright 4.0.7 on a CentOS server using gcc and I'm running into a difficulty defining the correct target OS. I...

    Started by GabrielH‎, August 1st, 2012 03:24 PM
    • Replies: 1
    • Views: 1,459
    August 1st, 2012, 03:43 PM Go to last post
  16. except in ICE

    I apologize for asking such a simple question, but is something equivalent to the except statement in ICE? I've tried to google this to no avail. ...

    Started by dubl59zy‎, May 3rd, 2012 02:57 PM
    • Replies: 3
    • Views: 1,495
    May 4th, 2012, 12:22 PM Go to last post
  17. Oracle’s CLOB equivalent in Infobright

    Hi All, Can any one suggest me what will be best datatype for Oracle’s CLOB equivalent in Infobright Community Edition ? I am currently...

    Started by rajivkumarmehta‎, February 22nd, 2012 04:33 AM
    • Replies: 1
    • Views: 2,756
    February 22nd, 2012, 09:23 AM Go to last post
  18. Help Me! Installation of system tables failed!

    When I install infobright on Red Hat Enterprise Linux Server release 5.5 (Tikanga),there is a error. Installing infobright 4.0.5-0 (x86_64)...

    Started by jinghun‎, February 20th, 2012 08:25 AM
    • Replies: 3
    • Views: 2,191
    February 20th, 2012, 09:02 PM Go to last post
  19. Connection in Java

    Hello, i tried to perform some insert within ICE in Java using the lib infobright-core-3.4.jar and the related windows dll. Everything works...

    Started by lcamus‎, February 16th, 2012 04:09 AM
    • Replies: 2
    • Views: 1,822
    February 17th, 2012, 12:52 PM Go to last post
  20. Unable to connect to Infobright using jdbc driver

    I am using the following url to connect to infobright. It is giving the connection error in java. Is the driver that I am using is correct? Request...

    Started by f1kalyan‎, February 13th, 2012 04:04 PM
    • Replies: 1
    • Views: 2,738
    February 14th, 2012, 04:19 PM 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