Mariadb Column Store

On Debian Linux 10,

apt update
apt-cache search mariadb
apt install -y mariadb-server


root@debian:~# mariadb
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 36
Server version: 10.3.34-MariaDB-0+deb10u1 Debian 10

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
+--------------------+
3 rows in set (0.003 sec)

MariaDB [(none)]> create database test;
Query OK, 1 row affected (0.005 sec)

MariaDB [(none)]> use test;
Database changed
MariaDB [test]>


CREATE TABLE customer
(
    id      int AUTO_INCREMENT,
    name    varchar(255),
    city    varchar(255),
    gender  char(1),
    qualification   varchar(255),
    industry    varchar(255),
    age     int,
    height  int,
    PRIMARY KEY (id)
) engine = InnoDB;

CREATE TABLE customer_analytics
(
    id      int AUTO_INCREMENT,
    name    varchar(255),
    city    varchar(255),
    gender  char(1),
    qualification   varchar(255),
    industry    varchar(255),
    age     int,
    height  int,
    PRIMARY KEY (id)
) engine = ColumnStore;

Data import See: https://mariadb.com/kb/en/importing-data-into-mariadb/