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
5
votes
2 answers

Don't use prepared statements in Laravel Eloquent ORM?

Can I have Eloquent ORM run a query without using prepared statements? Or do I have to use whereRaw()? I need to use a raw query because I'm trying to interact with InfiniDB, which lacks support for prepared statements from PHP. At any rate, all…
Kevin Pei
  • 5,800
  • 7
  • 38
  • 55
4
votes
1 answer

Issues creating tables with InfiniDB

I am attempting to create this table in InfiniDB: CREATE TABLE dimension.date ( date_id int(8), -- 20120512 `date` date, -- 2012-05-12 day tinyint, -- 12 day_of_week tinyint, -- 6 (sunday being 0) weekday varchar(10), -- Saturday week…
Christopher Mancini
  • 87
  • 1
  • 5
3
votes
1 answer

Slow InfiniDB queries, what am I doing wrong?

I'm testing the InfiniDB community edition to see if it suits our needing. I imported in a single table about 10 millions rows (loading of data was surprisingly fast), and I'm trying to do some query on it, but these are the results (with NON…
kappa
  • 1,559
  • 8
  • 19
3
votes
2 answers

InfiniDB ERROR 168 (HY000): Cannot execute the statement. DBRM is read only

I have following version of InfiniDB. Server version: 5.1.39 MySQL Embedded / Calpont InfiniDB Enterprise 3.2.0-2 GA (Commercial) I am getting following error when I execute insert/update/delete query. ERROR 168 (HY000): Cannot execute the…
Dhimant Jayswal
  • 123
  • 1
  • 10
2
votes
1 answer

How can i get middle values in particular column in SQL

How can i get middle values in particular column in SQL 5.6, MySQL Workbench ie : 5014.**160201**.1200.1-2 here i need the value **160201**
Kishore
  • 23
  • 3
2
votes
1 answer

Table size - MariaDB Columnstore Vs InnoDB

Every analysis I found on ColumnStore from MariaDB claims that it uses less disk space than regular engines like InnoDB, e.g:…
Andre Teixeira
  • 23
  • 1
  • 4
2
votes
1 answer

InfiniDB: Unable to perform DDL/DML error

When I try to run 'Create Table' sql on infiniDB, I get the following error: "Error Code: 122 IDB-2010: Unable to perform DDL/DML because session 26 is currently updating another table." The Create Table sql is nothing out of the ordinary, it's…
Marina
  • 3,222
  • 5
  • 25
  • 35
2
votes
1 answer

InfiniDB table size calculation

I am trying to figure out the table size for an infiniDB table. In Show TABLE STATUS i see the data size as 0
user235410
  • 109
  • 1
  • 9
2
votes
0 answers

Designing a new analytics engine and looking for a comparison between columnar and No SQL databases

I have been using a single MySQL database to drive an analytics dashboard that will will typically compute metrics and graphs based on ~1-10million records. The data set can grow quite heavily over a few days. Needless to say, the next version of…
user892729
  • 41
  • 1
  • 4
1
vote
1 answer

Guideline on how to set InfiniDB options?

I've been trying to find out how to best set these settings, but haven't been able to find much info on them. Some of them I've seen before with regular MySQL installations, but some others I haven't: ## InfiniDB Specific options sort_buffer_size =…
Brett
  • 19,449
  • 54
  • 157
  • 290
1
vote
0 answers

Basic math operations with SUM() - unexpected values

we had this problem: updated version of MariaDB Columnstore from 1.2.2 to 1.2.4 and nonsense started. We have these columns col1, col2 both are DECIMAL(15,3) there was already working query to calculate these two columns (see alias A) and this…
Tomáš Staník
  • 1,319
  • 1
  • 10
  • 23
1
vote
3 answers

What are maximum limits of Mariadb columnstore?

I want to create wide table of thousands of rows in mariadb columnstore. I didn't find any documentation of max number of columns allowed by storage engine. I would also like to know how will be the performance of columnstore for 1000 integer…
Prashant
  • 138
  • 8
1
vote
0 answers

what is wrong in this query? for infinidb

SELECT DISTINCT a.ID ID, a.callingparty callingparty, a.calledparty calledparty, str_to_date(a.starttime, '%Y-%m-%d %T') starttime, b.calltype, a.DURATION, a.SERVERNAME, a.CHANNEL, a.EONENAME FROM crimes.mms_cri a LEFT OUTER JOIN…
S.M
  • 11
  • 1
1
vote
1 answer

How do I cancel / abort a rollback in infinidb?

When I start infinidb, I am getting the following error message, making it impossible for the service to start. In the log file, it says there is a problem with the rollback. Is there a way to abort the rollback so I can start the service again? I…
Jason Jan Ngo
  • 189
  • 1
  • 6
1
vote
2 answers

Hibernate without primary keys generated by db?

I'm building a data warehouse and want to use InfiniDB as the storage engine. However, it doesn't allow primary keys or foreign key constraints (or any constraints for that matter). Hibernate complains "The database returned no natively generated…
Michael Jones
  • 115
  • 2
  • 9
1
2 3