Hi, I tested, it works for me, at least the first column returned correctly, compare with yours. My result below: +----------------------+--------------------+-------------------+-------------------+-------------------+---------------+---------------------+----------------------------------------------------+--+
| deneme6.framenumber | deneme6.frametime | deneme6.ipsrc | deneme6.ipdst | deneme6.protocol | deneme6.flag | deneme6.windowsize | deneme6.info |
+----------------------+--------------------+-------------------+-------------------+-------------------+---------------+---------------------+----------------------------------------------------+--+
| 1 | NULL | "147.32.84.165" | "91.212.135.158" | "TCP" | NULL | NULL | "1040 → 5678 [SYN] Seq=0 Win=64240 Len=0 MSS=1460 SACK_PERM=1" |
| 2 | NULL | "147.32.84.165" | "91.212.135.158" | "TCP" | NULL | NULL | "[TCP Out-Of-Order] 1040 → 5678 [SYN] Seq=0 Win=64240 Len=0 MSS=1460 SACK_PERM=1" |
| 3 | NULL | "91.212.135.158" | "147.32.84.165" | "TCP" | NULL | NULL | "5678 → 1040 [SYN |
+----------------------+--------------------+-------------------+-------------------+-------------------+---------------+---------------------+----------------------------------------------------+--+ The reason for the NULL values for frametime, flag and windowsize columns is because you define them as INT type, but you have double quotes around those numbers. Hive does not interpret quotes in the file, as it only sees text file, not CSV file. Suggestion is that you remove all quotes in the file and try again, so that Hive can convert those numbers to INT correctly.
... View more
