skJsgG79

1
2-- Indicamos que keyspace emplean las tablas
3USE cursonosql;
4
5/*
6
7Year,Month,DayofMonth,DayOfWeek,DepTime,CRSDepTime,ArrTime,
8CRSArrTime,UniqueCarrier,FlightNum,TailNum,
9ActualElapsedTime,CRSElapsedTime,AirTime,ArrDelay,
10DepDelay,Origin,Dest,Distance,TaxiIn,TaxiOut,
11Cancelled,CancellationCode,Diverted,CarrierDelay,
12WeatherDelay,NASDelay,SecurityDelay,LateAircraftDelay
13
14*/
15
16CREATE TABLE IF NOT EXISTS VUELOS1987 (
17
18    Year int,
19    Month int,
20    DayofMonth int,
21    DayOfWeek int,
22    DepTime int,
23    CRSDepTime int,
24    ArrTime int,
25    CRSArrTime int,
26    UniqueCarrier text,
27    FlightNum int,
28    TailNum text,
29    ActualElapsedTime text,
30    CRSElapsedTime text,
31    AirTime text,
32    ArrDelay text,
33    DepDelay text,
34    Origin text,
35    Dest text,
36    Distance text,
37 
38    PRIMARY KEY (Origin)
39
40); -- WITH CLUSTERING ORDER BY ();