Stack Overflow
Stack Overflow

Questions tagged [infinidb]

InfiniDB is a column-oriented database engine for MySQL.

InfiniDB is a column-oriented database engine for .

35 questions
1
vote
2 answers

Install RMySQL to use with InfiniDB (without installing mysql completely)

I've successfully installed InifiniDB on CENTOS 6.5. InfiniDB is a columnar DB "compatible" with MySQL (same port etc.: I've even managed to install the latest version of MySQLWorkbench and works has a charm with InifiniDB - believing to deal with…
Enzo
  • 2,543
  • 1
  • 25
  • 38
1
vote
3 answers

Infinidb-" `CREATE_TIMESTAMP` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP" giving error

I am trying to port a database from mysql to infinidb.But I am getting above error(described in heading) while porting . `CREATE_TIMESTAMP` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP is valid in mysql but not in…
nerdiplayboy
  • 556
  • 2
  • 9
  • 17
1
vote
4 answers

InfiniDB insert speed with insert statement

I have recently started using InfinDB, and so far it is working well. I use the cipimport tool for bulk loads and it inserts millions of rows in seconds. However, there are certain situations in which I need to insert several thousand rows and using…
user396404
  • 2,759
  • 7
  • 31
  • 42
1
vote
0 answers

CREATE TABLE LIKE not working on InfiniDB?

I'm trying to automate a process in which an InfiniDB table is replaced. My idea is to create one table with the same structure as the original, load it with new data, and replace the original with this new one. The problem is that when you…
nandilugio
  • 315
  • 2
  • 11
0
votes
1 answer

InfiniDB on Windows: configuration

I'm currently trying to set up an instance of Calpont's InfiniDB on Windows, however I'm currently struggling against a problem: I set everything up on my development server, created the database, tables etc. Now I want to access the db from my…
em70
  • 6,088
  • 6
  • 48
  • 80
0
votes
1 answer

Mariadb Columnstore: Version buffer overflow

I am trying to add new data to a columnstore table, but it is returning this error: ERROR 1815 (HY000) at line 25: Internal error: CAL0001: Insert Failed: IDB-2008: The version buffer overflowed. Increase VersionBufferFileSize or limit the rows to…
Daniel Cukier
  • 11,502
  • 15
  • 68
  • 123
0
votes
2 answers

mysql hangs at login

I am using InfiniDB (not by choice). When I use the linux shell, I am able to connect to a database just fine: @:~$ /usr/local/Calpont/mysql/bin/mysql -u -p -h Enter password: Welcome to the MySQL monitor. …
ale19
  • 1,327
  • 7
  • 23
  • 38
0
votes
2 answers

Can't drop table after creating table with wrong engine

I'm trying to drop a table containing several hundred thousand column-based records. Normally when creating the database I use a column-based engine (infinidb) but in this case I forgot to include the ENGINE statement. So the database is pretty much…
ale19
  • 1,327
  • 7
  • 23
  • 38
0
votes
1 answer

Infinidb on Ubuntu 14.04: ERROR: Failed trying to update InfiniDB System Configuration file

just started a fresh Ubuntu 14.04 LTS image, and installed the .debs for 4.6.0.1. After that, I ran the following .... which immediately fails: root@infinidb1:~# /usr/local/Calpont/bin/postConfigure ===== Setup System Server Type Configuration…
Sjaak Trekhaak
  • 4,906
  • 30
  • 39
0
votes
1 answer

Select stratified sample from table without variables

I need to get a stratified sample of my huge table. Specifically, I want to select 1/n rows from my table without bias, i.e. select randomly, select every nth row, etc. Before I asked this question, I tried doing this. However, it didn't work for me…
Bluefire
  • 13,519
  • 24
  • 74
  • 118
0
votes
1 answer

mysql-Calpont not starting

I have mysql-Calpont installed in a Linux machine. When i try to start mysql-Calpont, it gives an error: Starting MySQL. ERROR! Manager of pid-file quit without updating file. Totally new to Linux. Need help to figure out why this is happening and…
WinSupp
  • 361
  • 2
  • 6
  • 20
0
votes
0 answers

Table and sub-query are not joined ? Nested queries (only select and SUM)

I have 1 table and I tried this query with InfiniDB : SELECT sum(montantTTC) FROM ticket WHERE year(creation_iso) IN (SELECT distinct year(creation_iso) as annee FROM ticket ORDER BY annee); But I have an error :…
Alexis_user
  • 427
  • 5
  • 14
0
votes
0 answers

require error with mysql and Ruby. (windows)

I have a problem to use mysql with Ruby 2.0.0 and Windows 7 64bits... I have only : require 'mysql' in my script. Errors : C:/Ruby200/lib/ruby/2.0.0/rubygems/core_ext/kernel_require.rb:55:in `require': cannot load such file -- mysql/mysql_api…
Alexis_user
  • 427
  • 5
  • 14
0
votes
0 answers

How create Bollinger Bands with infinidb

Currently, I use InfiniDB with php trader extension (there is trader_bbands function which help), but I want to check that all final values of Bollinger lines are correct with sql solution.
kirugan
  • 2,514
  • 2
  • 22
  • 41
0
votes
2 answers

Aggregate over a sliding window with only equi-joins

I would like to calculate the total unique accounts in a 30 day range. The engine I am using on MySQL (InfiniDB) seems to only support joining tables on equality conditions. My table looks like this: sessions (date_id, account_id) = { '2013-07-07',…
beefyhalo
  • 1,691
  • 2
  • 21
  • 33
1
2
3