CREATE DATABASE IF NOT EXISTS infinimetrics_1166


CREATE TABLE IF NOT EXISTS infinimetrics_1166.infinibox_stats_ssddevicestats (
    timestamp_date Date,
    monitored_entity_id UInt32,
    timestamp DateTime,
    variance Array(Float64),
    empty UInt8,
    read_rate Float64,
    write_rate Float64,
    write_round Float64,
    read_errors Float64,
    write_errors Float64
) ENGINE = MergeTree(timestamp_date, sipHash64(toString(timestamp)), (monitored_entity_id, timestamp, sipHash64(toString(timestamp))), 8192)


COPY (
SELECT to_char("timestamp", 'YYYY-MM-DD'), monitored_entity_id, to_char("timestamp", 'YYYY-MM-DD HH24:MI:SS'), variance,
    CASE WHEN read_rate is NULL THEN 1 ELSE 0 END as empty,
    read_rate, write_rate, write_round, read_errors, write_errors
  FROM infinibox_stats_ssddevicestats
  ORDER BY timestamp
) TO '/tmp/ssddevicestats.tsv' WITH NULL AS '0'


clickhouse-client -q "INSERT INTO infinimetrics_1166.infinibox_stats_ssddevicestats FORMAT TabSeparated" < /tmp/ssddevicestats.tsv




