Vertica 9.0.0_0 Community Edition
10K+
Base OS is Ubuntu 14.04. Dockerfile can be found at https://bitbucket.org/thaiphamquoc/docker-vertica
You can either pull the image from Docker Registry using following command:
docker pull dataplatform/docker-vertica
Or, build your own image using following command. Download the Vertica DEB package from https://my.vertica.com and put it in this folder as "vertica.deb". Then run:
docker build -t dataplatform/docker-vertica .
docker run -p 5433:5433 dataplatform/docker-vertica
docker run -p 5433:5433 -d -v /data/vertica/vertica_data:/home/dbadmin/docker dataplatform/docker-vertica
Default DB Name - docker
Default User - dbadmin
Default Password (NO PASSWORD) -
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;
Content type
Image
Digest
Size
788.1 MB
Last updated
almost 9 years ago
docker pull dataplatform/docker-vertica