213 questions
1
vote
2
answers
109
views
Clustered columnstore index with computed column -- why does segment elimination not work?
Recent versions of Microsoft SQL Server allow creating a clustered columnstore index on a table that has computed columns, as long as they are not persisted computed columns. [1]
I would like to get ...
- 1,622
-1
votes
1
answer
60
views
Missing index info (columnstore index)
I have a [dbo].[SalesBudgetMonths] table with a columnstore index on it.
When I join to a physical table dbo.Sellers on the indexed column [Seller] like this:
;WITH s1 AS
(
SELECT 232 AS Id
)
...
- 207
1
vote
1
answer
151
views
Column has a data type that cannot participate in a columnstore index error in Azure Databricks while creating new table in Data warehouse
We are using Azure Databricks notebook where we are connecting Azure Datawarehouse service to get records from a table and copy the data of that table into another table in our Sandbox schema.
Here is ...
- 1,223
0
votes
1
answer
137
views
Can I create a columnstore table in singlestore if the default table type setting is rowstore? If so, what will be the syntax?
I'm currently working with singlestoredb. default storage type for my db is rowstore.
I wanted to know if I can create columnstore tables if default_table_type is set as "rowstore" in my DB. ...
0
votes
0
answers
473
views
Long HTMEMO waits when deleting from columnstore index
I've a table that has a clustered columnstore index having 8 billion records. Once in a day, there is a process that inserts, updates and deletes data from this table with around 1-30 million record, ...
- 86
0
votes
1
answer
120
views
Autorestarting mariadb cluster after node reconnection
I use official mariadb/columnstore docker image. I run docker compose with MaxScale and try to imitate the situation when one of the msc node is disconnected and connected again. I can see in mcs ...
- 41
0
votes
1
answer
1k
views
Partitioned table and Partitioned Columnstore index
I have a partitioned table like this:
CREATE TABLE [dbo].[OrderDetailMessage]
(
[OrderDetailMessageId] [BIGINT] IDENTITY(1,1) NOT NULL,
[Id] [UNIQUEIDENTIFIER] NULL,
...
)
ON [...
0
votes
1
answer
2k
views
Should most Snowflake tables have a cluster key defined?
I'm new to Snowflake relatively. I get that it's a columnar based database. That's not exactly magical - it's just better at more Analytics / BI workloads as opposed to more writing transactions.
So ...
- 983
1
vote
1
answer
247
views
MariaDB columnstore table join innodb table
I know that this kind of join is supported, but it doesn't work for me for the next case;
Given the tables:
CREATE TABLE person_cs(
firstName VARCHAR(255),
lastName VARCHAR(255),
address ...
- 664
0
votes
1
answer
247
views
Docker + MariaDB Community Edition + ColumnStore
I've installed MariaDB Community Edition 10.11.2 on Docker (on Windows) and have been reading on how to install ColumnStore and almost everywhere I find instructions (including the official site), it ...
- 5
0
votes
1
answer
89
views
Reading from MemSql (SingleStore) in case of multiple snapshots
I have a usecase where my memsql db will look something like this
DB- USER
country company user_id passphrase timestamp
India google 123 xyz 10:00AM
India google 123 ABC ...
- 351
1
vote
1
answer
145
views
query causing huge cpu utilization and high latency
following query is causing huge cpu utilization and high latency on my db environment.
i have tried to improve the query performance with different type of indexes but unfortuanately any indexes not ...
- 27
0
votes
1
answer
2k
views
Best Practice for Rebuilding SQL Server Indexes on Partitioned Table After Purging
I have a partitioned table that contains approx. 16 billion rows. The table has a clustered columnstore index and one partition aligned non-clustered index. The partitions are all on the same ...
- 57
0
votes
0
answers
458
views
Unable to set MAXDOP option on a non-clustered columnstore Index
I'm trying to set MAXDOP option on a non-clustered columnstore index using the following ways and it doesn't seem to be sticking. Server is SQL Server 2019.
Index properties -> Options Page -> ...
- 1
1
vote
0
answers
133
views
MariaDB with ColumnStore spawns a lot of child processes
I'm having a strange issue with a MariaDB Community 10.6 with ColumnStore installation running on a Ubuntu 20.04.
After I start the server and my application begins sending queries to it, the process ...
0
votes
0
answers
439
views
Oracle - Cannot set inmemory_size?
I am having problem with changing the parameter INMEMORY_SIZE in oracle database. I used the below script to set this parameter:
ALTER SYSTEM SET inmemory_size=300M scope=spfile;
And it raised the ...
- 87
0
votes
1
answer
411
views
Create tables similar to existing using Python's Sqlalchemy and Singlestore sql
I have a set of existing tables in a singlestore database, many of which are columnstore tables.
I want to build a python script that will migrate my development tables to production tables. The dev ...
- 1,700
0
votes
1
answer
504
views
Performance Issue of SQLServer Columnstore Index: "Where OR" will influence predicate pushdown
In SQL Server, I have a table using Columnstore Index, need to do some aggregate step, but if the where clause contains "or", the predicate pushdown will Gone, I don't know why, anyone have ...
- 1
1
vote
0
answers
324
views
Columnstore index with page fullness 0 and total fragmentation 0
I have an SQL Server (2019) database with some bigger fact tables (about 200 million rows). I created clustered column store indices on each of them. When I open the properties of the index of one of ...
- 384
0
votes
0
answers
409
views
cpimport in mariadb columnstore inserting empty string instead of null for varchar column
Mariadb Details: 10.3.11-MariaDB
I am trying to import bunch of CSV files in a newly created table on Mariadb columnstore engine.
Steps I performed:
1)Create Table
CREATE TABLE IF NOT EXISTS `...
0
votes
1
answer
1k
views
SQL Server partition by month use persisted column and create clustered column store index at the same time
I created a partitioned table in SQL Server as follows:
--Add File Groups
ALTER DATABASE TEST ADD FILEGROUP JAN;
GO
ALTER DATABASE TEST ADD FILEGROUP FEB;
GO
ALTER DATABASE TEST ADD FILEGROUP MAR;
GO
....
- 33
0
votes
1
answer
625
views
Index disable/rebuild throws Columnstore index data compression error
I have added a columnstore index to the cube.partition_daily table
Error message:
Msg 10799, Level 16, State 1, Line 123
This is not a valid data compression setting for a columnstore index. Please ...
- 369
0
votes
1
answer
474
views
INSERT INTO...SELECT issue in MariaDB Columnstore
I have a new installation of MariaDB 10.5.8 which includes Columnstore as a plugin. I'm facing an issue when I try to insert rows into a columnstore table from a select statement. I have narrowed it ...
1
vote
1
answer
1k
views
Download MariaDB Column Store on Windows 10 [closed]
I have been searching for a while that how to install mariadb column store on windows. I have Windows 10 on my system. How can I install Column Store on Windows?
- 324
0
votes
1
answer
548
views
Is the Vertipaq engine in Power BI same as the one used by columnstore indexes in SQL Server?
I have read this somewhere about the core technologies being the same in Power BI as well as the one used in MS SQL Server, but I am not able to find anything from Microsoft linking these two ...
- 17