thaiphamquoc/docker-vertica repository overview

docker pull thaiphamquoc/docker-vertica

docker build -t thaiphamquoc/docker-vertica .

docker run -p 5433:5433  thaiphamquoc/docker-vertica

docker run -p 5433:5433 -d -v /data/vertica/vertica_data:/home/dbadmin/docker thaiphamquoc/docker-vertica

vsql -hlocalhost -Udbadmin

CREATE schema bi_pipeline;

CREATE TABLE bi_pipeline.failedpn
(
    metric_date int NOT NULL,
    metric_hour int,
    game_id int,
    game_id_str varchar(32),
    user_id int,
    event_ts timestamp,
    bundle_id varchar(32),
    mkt int,
    mkt_str varchar(100),
    device_token varchar(1000)
)
PARTITION BY (failedpn.metric_date);

INSERT INTO bi_pipeline.failedpn (metric_date, metric_hour, game_id, game_id_str, user_id, event_ts, bundle_id, mkt, mkt_str, device_token) VALUES (20171103, 2017110301, 23, 'niso', 1, '2017-11-03 00:01:01', 'bundle-1', 1, 'apple', 'abcdef');
COMMIT;

SELECT * FROM bi_pipeline.failedpn;