You've already forked mariadb-columnstore-engine
mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-09-16 19:42:06 +03:00
19 lines
642 B
Plaintext
19 lines
642 B
Plaintext
DROP DATABASE IF EXISTS mcol4652;
|
|
CREATE DATABASE mcol4652;
|
|
USE mcol4652;
|
|
create table customer (
|
|
c_custkey decimal(38),
|
|
c_name varchar (25),
|
|
c_address varchar (40),
|
|
c_nationkey int,
|
|
c_phone char (15),
|
|
c_acctbal decimal(12,2),
|
|
c_mktsegment char (10),
|
|
c_comment varchar (117)
|
|
) engine=columnstore;
|
|
LOAD DATA LOCAL infile 'MTR_SUITE_DIR/../std_data/100Krows.dat' INTO TABLE customer FIELDS TERMINATED BY '|';
|
|
SELECT e.min_value, e.max_value FROM information_schema.columnstore_extents e, information_schema.columnstore_columns c where e.object_id = c.object_id and column_name = 'c_custkey';
|
|
min_value max_value
|
|
0 32767
|
|
DROP DATABASE mcol4652;
|