mongoimport - MongoDB import succeeds on one machine, fails on another -
i'm trying import kdd-cup-99 dataset (found here: http://kdd.ics.uci.edu/databases/kddcup99/kddcup99.html) mongodb. i've done on 1 machine using following command:
mongoimport --db dbname --collection colname --type csv --file kddcup.data.corrected --fieldfile kddcup99header
when use findone() @ results, looks well; output follows:
> db.colname.findone() { "_id" : objectid("547c33e376945996ed878f81"), "duration" : 0, "protocol_type" : "tcp", "service" : "http", "flag" : "sf", "src_bytes" : 215, "dst_bytes" : 45076, "land" : 0, "wrong_fragment" : 0, "urgent" : 0, "hot" : 0, "num_failed_logins" : 0, "logged_in" : 1, "num_compromised" : 0, "root_shell" : 0, "su_attempted" : 0, "num_root" : 0, "num_file_creations" : 0, "num_shells" : 0, "num_access_files" : 0, "num_outbound_cmds" : 0, "is_host_login" : 0, "is_guest_login" : 0, "count" : 1, "srv_count" : 1, "serror_rate" : 0, "srv_serror_rate" : 0, "rerror_rate" : 0, "srv_rerror_rate" : 0, "same_srv_rate" : 1, "diff_srv_rate" : 0, "srv_diff_host_rate" : 0, "dst_host_count" : 0, "dst_host_srv_count" : 0, "dst_host_same_srv_rate" : 0, "dst_host_diff_srv_rate" : 0, "dst_host_same_src_port_rate" : 0, "dst_host_srv_diff_host_rate" : 0, "dst_host_serror_rate" : 0, "dst_host_srv_serror_rate" : 0, "dst_host_rerror_rate" : 0, "dst_host_srv_rerror_rate" : 0, "unknown" : "normal." }
now i'm running same import operation on machine, using same files , command, isn't working properly. results of import follows:
> db.colname.findone() { "_id" : objectid("547d8f94facff0761ae10688"), " : 0, "duration " : "tcp",rotocol_type " : "http",rvice " : "sf",flag " : 215,"src_bytes " : 45076,st_bytes " : 0, "land " : 0, "wrong_fragment " : 0, "urgent " : 0, "hot " : 0, "num_failed_logins " : 1, "logged_in " : 0, "num_compromised " : 0, "root_shell " : 0, "su_attempted " : 0, "num_root " : 0, "num_file_creations " : 0, "num_shells " : 0, "num_access_files " : 0, "num_outbound_cmds " : 0, "is_host_login " : 0, "is_guest_login " : 1, "count " : 1, "srv_count " : 0, "serror_rate " : 0, "srv_serror_rate " : 0, "rerror_rate " : 0, "srv_rerror_rate " : 1, "same_srv_rate " : 0, "diff_srv_rate " : 0, "srv_diff_host_rate " : 0, "dst_host_count " : 0, "dst_host_srv_count " : 0, "dst_host_same_srv_rate " : 0, "dst_host_diff_srv_rate " : 0, "dst_host_same_src_port_rate " : 0, "dst_host_srv_diff_host_rate " : 0, "dst_host_serror_rate " : 0, "dst_host_srv_serror_rate " : 0, "dst_host_rerror_rate " : 0, "dst_host_srv_rerror_rate "unknown" : "normal." }
seeing i'm using same data files , commands, figured must in environment. system locale settings identical, yet still import not work properly. has ever seen such behavior before?
edit should add both machines running same version of mongodb: 2.6.5
i suggest verify files same on both machines:
md5sum kddcup.data.corrected kddcup99header
and verify version of mongoimport
tool:
mongoimport --version
Comments
Post a Comment