Public Repository

Last pushed: 2 years ago
Short Description
Data only container for cassandra database from airlines ingestion example.
Full Description

Supported tags

  • 2.2.5

How to use this image

Create data container
docker create --name data-cassandra-airlines stratio/cassandra-airlines:2.2.5
Run Cassandra container linking data container
docker run --name cassandra-node --volumes-from data-cassandra-airlines stratio/cassandra:2.2.5

Data Structure

Keyspace

airlines_casandra

Table

airlines
airlines (
flight_date timestamp,
depdelay int,
destlatlon text,
originlatlon text,
origin text,
dest text,
arrdelay int,
uniquecarrier text,
PRIMARY KEY (flight_date,origin,dest)
)

Number of keys

Around 2 millions

Example

flight_date | origin | dest | arrdelay | depdelay | destlatlon | originlatlon | uniquecarrier
--------------------------+--------+------+----------+----------+-------------------------+-------------------------+---------------
1991-01-26 17:08:00+0000 | ATL | PIT | 14 | 0 | 40.491467,-80.232872 | 33.636719,-84.428067 | DL
1991-01-26 17:08:00+0000 | BUF | RDU | -9 | -3 | 35.877639,-78.787472 | 42.940525,-78.732167 | AA
1991-01-26 17:08:00+0000 | CAE | ORD | -3 | 0 | 41.978603,-87.904842 | 33.938833,-81.119528 | UA
1991-01-26 17:08:00+0000 | DAL | AUS | 8 | 8 | 30.194528,-97.669889 | 32.847111,-96.851778 | WN
1991-01-26 17:08:00+0000 | DET | MDW | 7 | 3 | 41.785972,-87.752417 | 42.409195,-83.009861 | WN
1991-01-26 17:08:00+0000 | EWR | ORD | -11 | 0 | 41.978603,-87.904842 | 40.6925,-74.168667 | CO
1991-01-26 17:08:00+0000 | EWR | SFO | 19 | -2 | 37.618972,-122.374889 | 40.6925,-74.168667 | CO

Docker Pull Command
Owner
stratio