hive> CREATE EXTERNAL TABLE IF NOT EXISTS result_sf(
    > month INT,
    > zoneID INT,
    > liczba BIGINT)
    > COMMENT 'passengers details'
    > ROW FORMAT DELIMITED
    > FIELDS TERMINATED BY ','
    > LINES TERMINATED BY '\n'
    > STORED AS TEXTFILE;
OK
Time taken: 0.135 seconds
hive> select * from result_sf;
OK
Time taken: 0.223 seconds
hive> load data local inpath 'result.csv' into table result_sf;
Loading data to table taxizone.result_sf
OK
Time taken: 0.54 seconds
hive> select * from result_sf;
OK
11      6       NULL
11      1       NULL
2       1       NULL
10      2       NULL
12      5       NULL
11      99      NULL
12      1       NULL
12      6       NULL
11      2       NULL
3       1       NULL
12      99      NULL
11      3       NULL
12      2       NULL
1       5       NULL
11      4       NULL
12      3       NULL
11      5       NULL
6       1       NULL
1       1       NULL
10      1       NULL
12      4       NULL
Time taken: 0.193 seconds, Fetched: 21 row(s)
hive> szymonkukla1@klaster-m:~$ cat result.csv
11,6,30
11,1,3725072
02,1,6
10,2,8
12,5,7556
11,99,209
12,1,4035363
12,6,30
11,2,87045
03,1,5
12,99,199
11,3,6615
12,2,92619
01,5,2
11,4,2752
12,3,7442
11,5,6522
06,1,10
01,1,105
10,1,158
12,4,2565