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.
Questions tagged [infobright]
41 questions
0
votes
2 answers
Return somehting when no record exists, infobright db
I have a query like this and using infobright database --
select field1, field2
from foo
where filed1 in (1,2,3)
I want something to return even if there is no record in table. For example, there is record for filed1 = 2
and filed1 = 2 but nothing…
Akg
- 349
- 1
- 3
- 15
0
votes
1 answer
Does InfoBright package come with Mysql?
I followed the instruction from https://www.infobright.org/index.php/ICE_Wiki/wiki-4/installation/install-guide-for-linux/ . After installing InfoBright using dpkg, I run:
ps aux|grep mysqld
/usr/bin/mysql-ib
Definitely no mysqld is running, so…
Guocheng
- 543
- 3
- 15
0
votes
0 answers
Infobright startup error: Fatal error:
This is the install log
11:30:18
11:30:18 Installing infobright 4.0.7-0 (i686)
11:30:18 The installer will generate /tmp/ib4.0.7-0-install.log install trace log.
11:30:18 [step: pre (4.0.7-0, 1=1)]
11:30:18 build type: static
11:30:23 [step: post…
Aritra
- 13
- 4
0
votes
1 answer
Load data infile csv file in infobright
I have a table ( created successfully in infobright).
I m using windows system
CREATE TABLE `file_records` (
`id` int(11) NOT NULL ,
`file_id` int(11) NULL,
`file_url` varchar(255) NULL,
`switch_id` int(11) NULL,
`carrierid_supplier`…
dell
- 172
- 2
- 15
0
votes
1 answer
Infobright Queries
I have a fact table in Infobright that has around 40 million rows. Running a query on that table, like the one shown below, takes well over 10 minutes.
SELECT pat_key,
COUNT(c_id)
FROM my_fact_table
GROUP BY pat_key
ORDER BY COUNT(c_id)…
Kingz
- 5,086
- 3
- 36
- 25
0
votes
1 answer
Infobright database connection through vb script
Can anyone tell me how to connect infobright database through vb script. I have written a code but it shows an error:
provider can not be found.
The code I have written is:
Option Explicit
Dim conn, sqlstr
sqlstr = "SELECT COLLATION_NAME FROM…
Saranik Dey
- 1
- 1
0
votes
1 answer
Brighthouse out of memory error
We've been using Infobright Community Edition for easily over a year now, with absolutely no trouble at all. It's even sharing the server with a much bigger footprint database (a postgreSQL database).
Suddenly it has started giving us errors. …
Scott Wood
- 1,077
- 3
- 18
- 34
0
votes
1 answer
How to use Reject file in infobright with version 4.0.6 GA
In the release notes of version 4.0.6 GA, we can found that the first new feature is "Infobright Loader now supports a Reject file"
But I cannot find anything more about this, just like how to use it, and in which case we may need it.
Please help
York.Gu
- 45
- 7
0
votes
1 answer
Infobright/MySQL load data infile deadlock
I am experiencing a deadlock when using multiple concurrent LOAD DATA INFILE comamnds. Here is the background:
I have developed a Java-based ETL tool which loads flat files into Infobright databases (Infobright is a columnar database based on…
Filip
- 1,451
- 1
- 11
- 19
-1
votes
1 answer
Infobright Community Edition
Is there any way how to access a table in the format used from the infobright community edition (basically a folder with multiple .frm files and subfolders with .ctb files)? The infobright community edition software is not anymore freely…
nan
- 1
-2
votes
1 answer
Data manipulation in a mysql table
I have 2 columns in the table which have incorrect entries. The size of the table runs in to billions of records. I had like to swap data between two columns (c1 and C2)
The approach taken is to export the data in small chunks in to CSV files and…
TheMonkWhoSoldHisCode
- 2,182
- 3
- 26
- 40