yum install wget jq -y

wget https://raw.githubusercontent.com/mariadb-corporation/mariadb-columnstore-engine/develop/extra/cs_package_manager.sh; chmod +x cs_package_manager.sh;

time bash cs_package_manager.sh install enterprise 10.6.14-9 --token xxxxxxxxxx

cd /tmp/

aws s3 cp xxxxxxxxxxxxxxx

tar -xvf data.tar.gz

mariadb -e "create database if not exists test"

mariadb test -e "source /tmp/hitrk_dire_sim_info_testdata.sql"

mariadb test -e "CREATE TABLE hitrk_dire_sim_info( SITE_ID varchar(30) DEFAULT NULL, CUSTOMER varchar(150) DEFAULT NULL, SYSTEM_TYPE varchar(10) DEFAULT NULL, SYSTEM varchar(50) DEFAULT NULL, SYSTEM_SN varchar(30) DEFAULT NULL, REF_CODE varchar(30) DEFAULT NULL, SIM_DESCRIPT varchar(100) DEFAULT NULL, SIM_TYPE varchar(30) DEFAULT NULL, SIM_SEVERITY varchar(30) DEFAULT NULL, SIM_SERIAL varchar(30) DEFAULT NULL, SIM_DATE datetime DEFAULT NULL, DKC_UCODE varchar(30) DEFAULT NULL, TYPE_CODE varchar(30) DEFAULT NULL, DRV_SN varchar(30) DEFAULT NULL, DRV_FW varchar(30) DEFAULT NULL, _REF_3 varchar(30) DEFAULT NULL, _KEY_NO varchar(100) DEFAULT NULL, _CREATED_DATE datetime DEFAULT NULL) ENGINE=Columnstore DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci"

mariadb test -e "SELECT distinct count(*)

FROM hitrk_dire_sim_info_testdata AS s1

WHERE s1.system_type = 'a'

AND s1.sim_date BETWEEN NOW() - INTERVAL 24 MONTH AND NOW()

AND EXISTS (SELECT s.SYSTEM_SN, s.SIM_DESCRIPT, s.sim_date, s.sim_serial

FROM hitrk_dire_sim_info_testdata AS s

WHERE s.system_type = 'a'

AND s.sim_date BETWEEN NOW() - INTERVAL 24 MONTH AND NOW()

AND s.sim_descript = 'a'

AND s.SYSTEM_SN = s1.system_sn

AND s1.sim_date BETWEEN s.sim_date - INTERVAL 10 HOUR AND s.sim_date + INTERVAL 10 HOUR

)"