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

Forum: Technical Tips & Tricks

Postings regarding tips & tricks of use to the ICE community

  1. 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: 16,561
    May 14th, 2015, 10:03 AM Go to last post
  2. 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,735
    September 21st, 2014, 08:53 PM Go to last post
  3. 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,678
    March 21st, 2014, 07:23 AM Go to last post
  4. 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: 4,073
    March 3rd, 2014, 04:59 AM Go to last post
  5. 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: 3,485
    November 5th, 2013, 08:00 AM Go to last post
  6. 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,790
    April 16th, 2013, 12:59 PM Go to last post
  7. 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: 4,422
    March 27th, 2013, 08:03 AM Go to last post
  8. 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,854
    February 22nd, 2013, 04:31 AM Go to last post
  9. 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,523
    November 29th, 2012, 01:33 PM Go to last post
  10. 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,458
    November 29th, 2012, 12:58 PM Go to last post
  11. 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: 4,339
    November 14th, 2012, 06:24 PM Go to last post
  12. 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,738
    August 1st, 2012, 03:43 PM Go to last post
  13. 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,793
    May 4th, 2012, 12:22 PM Go to last post
  14. 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: 3,876
    February 22nd, 2012, 09:23 AM Go to last post
  15. 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,644
    February 20th, 2012, 09:02 PM Go to last post
  16. 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: 2,140
    February 17th, 2012, 12:52 PM Go to last post
  17. 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: 3,114
    February 14th, 2012, 04:19 PM Go to last post
  18. 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: 2,751
    February 10th, 2012, 02:06 PM Go to last post
  19. 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: 2,049
    February 8th, 2012, 08:47 AM Go to last post
  20. Access denied for user

    i3nms-flt-o0818:/usr/bin # /usr/bin/mysql-ib ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

    Started by f1kalyan‎, February 7th, 2012 02:00 PM
    • Replies: 1
    • Views: 1,535
    February 7th, 2012, 02:15 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