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

Forum: Technical Tips & Tricks

Postings regarding tips & tricks of use to the ICE community

  1. 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 06:07 PM
    • Replies: 9
    • Views: 6,097
    October 31st, 2014, 09:01 AM Go to last post
  2. 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 01:36 PM
    • Replies: 1
    • Views: 775
    September 29th, 2014, 02:26 PM Go to last post
  3. 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 01:46 PM
    audit sql
    • Replies: 1
    • Views: 630
    September 21st, 2014, 09:53 PM Go to last post
  4. 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 03:37 PM
    • Replies: 7
    • Views: 2,704
    March 21st, 2014, 08:23 AM Go to last post
  5. 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: 1,363
    March 3rd, 2014, 04:59 AM Go to last post
  6. 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: 1,010
    November 5th, 2013, 08:00 AM Go to last post
  7. 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 07:50 AM
    • Replies: 6
    • Views: 12,898
    April 16th, 2013, 01:59 PM Go to last post
  8. 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 10:07 PM
    • Replies: 4
    • Views: 2,254
    March 27th, 2013, 09:03 AM Go to last post
  9. 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: 994
    February 22nd, 2013, 04:31 AM Go to last post
  10. 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: 1,292
    November 29th, 2012, 01:33 PM Go to last post
  11. 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: 1,232
    November 29th, 2012, 12:58 PM Go to last post
  12. 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: 1,838
    November 14th, 2012, 06:24 PM Go to last post
  13. 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 04:24 PM
    • Replies: 1
    • Views: 832
    August 1st, 2012, 04:43 PM Go to last post
  14. 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 03:57 PM
    • Replies: 3
    • Views: 967
    May 4th, 2012, 01:22 PM Go to last post
  15. 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: 1,643
    February 22nd, 2012, 09:23 AM Go to last post
  16. 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: 1,193
    February 20th, 2012, 09:02 PM Go to last post
  17. 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,087
    February 17th, 2012, 12:52 PM Go to last post
  18. 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: 1,413
    February 14th, 2012, 04:19 PM Go to last post
  19. How to set user=mysql in Linux version of ICE rpm

    I have run the below command to check weather the respective files are saved as per the directory mentioned. I am getting a message '--user=mysql:...

    Started by f1kalyan‎, February 8th, 2012 12:13 PM
    • Replies: 5
    • Views: 1,316
    February 10th, 2012, 02:06 PM Go to last post
  20. Problem with loading data with UTF8

    Hi. I am testing ICE 4.0.5 and i am having problem with loading CSV data from a different Mysql Database. My table : CREATE TABLE `Test`...

    Started by aloned‎, January 31st, 2012 10:05 AM
    • Replies: 2
    • Views: 1,172
    February 8th, 2012, 08:47 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