Stack Overflow
Stack Overflow

Questions tagged [infobright]

Column-oriented database based off MySQL which leverages an in-memory knowledge-grid. The technology is best used as an analytic database for serving large amounts of machine-generated data. It is not designed as a transactional database. Best data amounts exist between hundreds of gigs to fifty terabytes. Schema is best structured when it is denormalized. The product exists in two forms: a gpl2 open-source edition and an enterprise edition.

41 questions
1
vote
0 answers

While loading DataTable if I click on any link it's show error! Solutions? (PHP/Infobright)

Using ajax to load a DataTable as follows: $("#getXXData").dataTable({ "bServerSide": true, "sPaginationType": "bootstrap", "sAjaxSource": dataRequestUrl, "bProcessing": true, "bDestroy":true, "iDisplayLength":100, "aaSorting": [[ 4,…
some_other_guy
  • 3,364
  • 4
  • 37
  • 55
1
vote
3 answers

Loading a file with newline characters in text field

So I have data with in which all the fields are enclosed by quotes and its delimited by pipe. Some fields have html text in them so there are new line characters as part of the field. I want these new line characters to be part of the text field.…
MySQLLearner
  • 11
  • 2
1
vote
1 answer

InfoBright - load data from one table to another

Is there a way to insert data into InfoBright tables using LOAD DATA style like from file LOAD DATA INFILE '/usr/tmp/file2.txt' INTO TABLE test_table1 FIELDS TERMINATED BY ',' ENCLOSED BY '"'; mysql> select * from test_table1;…
dzona
  • 3,323
  • 3
  • 31
  • 47
1
vote
1 answer

Brighthouse optimization in table structure for SELECT query

I have a table with millions of records in MySQL -> imported into Infobright using notes in wiki pages, no problem! Here is the table syntax CREATE TABLE `myTable` ( `a` varchar(255) COLLATE latin1_bin DEFAULT NULL, `b` varchar(255) COLLATE…
Yusuf Ali
  • 95
  • 2
  • 11
1
vote
0 answers

Grouping result set in infobright

I am writing a program in java to fetch records from infobright database. Here are the table structure, query and the format of output I require. Table structure: column name type ------------ ---------- id …
Kinjal
  • 718
  • 2
  • 11
  • 21
1
vote
2 answers

Modifying the Microstrategy SQL Generator

I am using Microstrategy, and I am aware of the Freeform SQL Report functionality. However, I'd like to change how Microstrategy generates its SQL. Since I'm using Infobright, I'd like to use sub-selects instead of full joins, etc. Example: Query…
JeffIB
  • 128
  • 1
  • 7
0
votes
1 answer

InfoBright (MySQL) ERROR 5 (HY000): std::exception

I am doing a bulk upload to my InfoBright. I have taken the data from server 1 into the outfile and trying to bulkupload to server 2. I copied data file generated by MySQL OUTFILE from server 1 to server 2. I changed the ownership of these data…
Rahul Shelke
  • 2,052
  • 4
  • 28
  • 50
0
votes
0 answers

Importing data from infobright via Sqoop

Does infobright support data movement via Sqoop. I tried using mysql connector jdbc jar - 5.1.31. But I get access denied on the user. Same user I am able to login via dbeaver. If it is possible can someone share the connection URL or any specific…
Charvi Sidhar
  • 1
  • 1
0
votes
2 answers

How do I execute multiple mysql queries in Jasper Reports (not what you think...)

I have a complex query that requires a rank in it. I've learned that the standard way of doing that is by using the technique found on this page: http://thinkdiff.net/mysql/how-to-get-rank-using-mysql-query/. I'm using Infobright as the back end…
Jason Thompson
  • 4,643
  • 5
  • 50
  • 74
0
votes
3 answers

Having troubles loading data in InfoBright ICE

ICE Version: infobright-3.5.2-p1-win_32 I’m trying to load a large file but keep running into problems with errors such as: Wrong data or column definition. Row: 989, field: 5. This is row 989, field 5: ”(450)568-3***" Note: The last 3 chars are…
Brett
  • 19,449
  • 54
  • 157
  • 290
0
votes
1 answer

Infobright Enterprise Edition (IEE) service won't start?

I went to www.infobright.com, downloaded Infobright Enterprise Edition (IEE), and installed it. However, the service won't start, and it gives me absolutely no hint as to what the error is and why.
Contango
  • 76,540
  • 58
  • 260
  • 305
0
votes
1 answer

Data swap in a large database

I have 2.8 billion records in a table. The table uses INFOBRIGHT engine run on mysql installation. I have a few incorrect entries in the table and would like to get them corrected. Table Test has 350 odd columns. I had like to swap data from column…
TheMonkWhoSoldHisCode
  • 2,182
  • 3
  • 26
  • 40
0
votes
1 answer

Using GROUP BY clause on EPOCH time on mysql table

I have a few million records in the mysql table TEST. One of the column (TRIAL_TIME) of TEST table stores EPOCH time as BIGINT. A sql query is fired which uses GROUP BY clause to group data on the TRIAL_TIME. The query is something like…
TheMonkWhoSoldHisCode
  • 2,182
  • 3
  • 26
  • 40
0
votes
1 answer

Community Infobright Data Loading with Hibernate

Infobright Data Base Community version does not implement the SQL Insert statement. It uses other statements for data loading instead. See link below: https://support.infobright.com/forums/showthread.php?7939-insert-in-table Therefore hibernate does…
Guigon
  • 1
  • 1
0
votes
1 answer

Infobright installation is unable to use mysql user

When trying to install Infobright, no matter what I try, it says it can't use the mysql-user. If I try it with the dpkg -i infobright-4.0.7-0-i686-ice.deb, the log contains the following problems: 11:48:16 Installing infobright 4.0.7-0…
David Georg Reichelt
  • 963
  • 1
  • 15
  • 36
1
2
3