• MapReduce处理数据1


     

     学了一段时间的hadoop了,一直没有什么正经练手的机会,今天老师给了一个课堂测试来进行练手,正好试一下。

    项目已上传至github:https://github.com/yandashan/MapReduce_Count1


    Result文件数据说明:

    Ip106.39.41.166,(城市)

    Date10/Nov/2016:00:01:02 +0800,(日期)

    Day10,(天数)

    Traffic: 54 ,(流量)

    Type: video,(类型:视频video或文章article

    Id: 8701(视频或者文章的id

    测试要求:

    1、 数据清洗:按照进行数据清洗,并将清洗后的数据导入hive数据库中

    两阶段数据清洗:

    1)第一阶段:把需要的信息从原始日志中提取出来

    ip:    199.30.25.88

    time:  10/Nov/2016:00:01:03 +0800

    traffic:  62

    文章: article/11325

    视频: video/3235

    2)第二阶段:根据提取出来的信息做精细化操作

    ip--->城市 cityIP

    date--> time:2016-11-10 00:01:03

    day: 10

    traffic:62

    type:article/video

    id:11325

    3hive数据库表结构:

    create table data(  ip string,  time string , day string, traffic bigint,

    type string, id   string )

    2、数据处理:

    ·统计最受欢迎的视频/文章的Top10访问次数 (video/article

    ·按照地市统计最受欢迎的Top10课程 (ip

    ·按照流量统计最受欢迎的Top10课程 (traffic

    3、数据可视化:将统计结果倒入MySql数据库中,通过图形化展示的方式展现出来。


    数据并没有上传到github,所以在这里展示一下。

    基本数据类型如下:

       1 106.39.41.166,10/Nov/2016:00:01:02 +0800,10,54 ,video,8701
       2 113.140.11.123,10/Nov/2016:00:01:02 +0800,10,54 ,video,5915
       3 125.122.216.102,10/Nov/2016:00:01:02 +0800,10,54 ,video,9819
       4 116.231.219.242,10/Nov/2016:00:01:02 +0800,10,54 ,video,6335
       5 61.136.143.62,10/Nov/2016:00:01:02 +0800,10,54 ,video,7629
       6 39.186.247.142,10/Nov/2016:00:01:02 +0800,10,2957 ,video,3237
       7 59.42.206.247,10/Nov/2016:00:01:02 +0800,10,54 ,video,7053
       8 39.186.247.142,10/Nov/2016:00:01:02 +0800,10,66 ,video,3237
       9 61.135.172.68,10/Nov/2016:00:01:02 +0800,10,67 ,video,3510
      10 45.115.145.45,10/Nov/2016:00:01:02 +0800,10,67 ,video,13265
      11 61.149.133.159,10/Nov/2016:00:01:02 +0800,10,54 ,video,13182
      12 180.160.212.7,10/Nov/2016:00:01:02 +0800,10,54 ,video,2665
      13 125.90.48.103,10/Nov/2016:00:01:02 +0800,10,54 ,video,7311
      14 106.187.95.195,10/Nov/2016:00:01:02 +0800,10,54 ,video,5685
      15 39.186.247.142,10/Nov/2016:00:01:02 +0800,10,317 ,video,3237
      16 220.191.6.44,10/Nov/2016:00:01:02 +0800,10,72 ,video,1101
      17 39.186.247.142,10/Nov/2016:00:01:02 +0800,10,4860 ,video,3237
      18 61.142.10.231,10/Nov/2016:00:01:02 +0800,10,67 ,video,12551
      19 27.17.35.94,10/Nov/2016:00:01:02 +0800,10,54 ,video,1412
      20 120.198.231.154,10/Nov/2016:00:01:03 +0800,10,54 ,video,9817
      21 113.93.90.94,10/Nov/2016:00:01:03 +0800,10,54 ,video,7475
      22 114.249.93.42,10/Nov/2016:00:01:03 +0800,10,67 ,video,3221
      23 171.8.152.203,10/Nov/2016:00:01:03 +0800,10,54 ,video,5914
      24 199.30.25.88,10/Nov/2016:00:01:03 +0800,10,271 ,article,11325
      25 199.30.25.88,10/Nov/2016:00:01:03 +0800,10,62 ,article,11325
      26 39.186.247.142,10/Nov/2016:00:01:03 +0800,10,2311 ,video,3237
      27 222.168.40.31,10/Nov/2016:00:01:03 +0800,10,54 ,video,2452
      28 39.186.247.142,10/Nov/2016:00:01:03 +0800,10,307 ,video,3237
      29 58.241.76.18,10/Nov/2016:00:01:03 +0800,10,2957 ,video,3235
      30 49.81.162.183,10/Nov/2016:00:01:03 +0800,10,141 ,video,1816
      31 125.94.93.221,10/Nov/2016:00:01:03 +0800,10,54 ,video,4441
      32 101.200.101.201,10/Nov/2016:00:01:03 +0800,10,4468 ,article,4779
      33 39.186.247.142,10/Nov/2016:00:01:03 +0800,10,951 ,video,3237
      34 101.200.101.21,10/Nov/2016:00:01:03 +0800,10,524288 ,video,10506
      35 58.241.76.18,10/Nov/2016:00:01:03 +0800,10,66 ,video,3235
      36 101.200.101.21,10/Nov/2016:00:01:03 +0800,10,524288 ,video,10506
      37 67.82.64.254,10/Nov/2016:00:01:03 +0800,10,54 ,video,2875
      38 39.186.247.142,10/Nov/2016:00:01:03 +0800,10,72 ,video,3237
      39 117.100.106.26,10/Nov/2016:00:01:03 +0800,10,54 ,video,4908
      40 113.91.162.210,10/Nov/2016:00:01:03 +0800,10,54 ,video,10506
      41 58.241.76.18,10/Nov/2016:00:01:03 +0800,10,951 ,video,3235
      42 58.241.76.18,10/Nov/2016:00:01:03 +0800,10,5234 ,video,3235
      43 139.211.44.77,10/Nov/2016:00:01:03 +0800,10,54 ,video,4848
      44 39.186.247.142,10/Nov/2016:00:01:03 +0800,10,7227 ,video,3237
      45 111.172.46.191,10/Nov/2016:00:01:04 +0800,10,67 ,video,3069
      46 60.21.206.184,10/Nov/2016:00:01:04 +0800,10,67 ,video,6228
      47 39.186.247.142,10/Nov/2016:00:01:04 +0800,10,4496 ,video,3237
      48 39.186.247.142,10/Nov/2016:00:01:04 +0800,10,317 ,video,3237
      49 112.64.61.203,10/Nov/2016:00:01:04 +0800,10,54 ,video,12532
      50 222.171.107.65,10/Nov/2016:00:01:04 +0800,10,54 ,video,6837
      51 183.60.162.108,10/Nov/2016:00:01:04 +0800,10,54 ,video,13168
      52 171.214.155.3,10/Nov/2016:00:01:04 +0800,10,67 ,video,7558
      53 39.186.247.142,10/Nov/2016:00:01:04 +0800,10,1092 ,video,3237
      54 14.219.24.67,10/Nov/2016:00:01:04 +0800,10,54 ,video,773
      55 115.195.60.166,10/Nov/2016:00:01:04 +0800,10,54 ,video,2769
      56 175.20.94.66,10/Nov/2016:00:01:04 +0800,10,54 ,video,12299
      57 101.81.42.203,10/Nov/2016:00:01:04 +0800,10,54 ,video,4017
      58 60.191.47.90,10/Nov/2016:00:01:04 +0800,10,54 ,video,3664
      59 114.249.202.36,10/Nov/2016:00:01:04 +0800,10,54 ,video,13330
      60 120.198.231.150,10/Nov/2016:00:01:04 +0800,10,54 ,video,774
      61 58.241.76.18,10/Nov/2016:00:01:04 +0800,10,95 ,video,3235
      62 115.193.172.253,10/Nov/2016:00:01:04 +0800,10,67 ,video,2858
      63 183.128.164.83,10/Nov/2016:00:01:04 +0800,10,67 ,video,12299
      64 118.250.42.145,10/Nov/2016:00:01:04 +0800,10,67 ,video,11307
      65 175.10.104.158,10/Nov/2016:00:01:04 +0800,10,54 ,video,3217
      66 110.53.175.199,10/Nov/2016:00:01:04 +0800,10,54 ,video,8469
      67 106.37.127.231,10/Nov/2016:00:01:04 +0800,10,2195 ,video,8199
      68 171.216.125.79,10/Nov/2016:00:01:04 +0800,10,54 ,video,5219
      69 115.193.172.253,10/Nov/2016:00:01:04 +0800,10,6589 ,video,2858
      70 106.37.127.231,10/Nov/2016:00:01:04 +0800,10,349 ,video,8199
      71 182.100.18.242,10/Nov/2016:00:01:05 +0800,10,54 ,video,8995
      72 125.122.198.123,10/Nov/2016:00:01:05 +0800,10,54 ,video,10897
      73 199.30.25.88,10/Nov/2016:00:01:05 +0800,10,5994 ,article,11325
      74 115.193.172.253,10/Nov/2016:00:01:05 +0800,10,2961 ,video,3078
      75 119.122.183.89,10/Nov/2016:00:01:05 +0800,10,7226 ,video,3244
      76 140.207.97.98,10/Nov/2016:00:01:05 +0800,10,68 ,video,10936
      77 183.128.164.83,10/Nov/2016:00:01:05 +0800,10,67 ,video,953
      78 106.37.127.231,10/Nov/2016:00:01:05 +0800,10,1355 ,video,8199
      79 116.23.248.47,10/Nov/2016:00:01:05 +0800,10,54 ,video,1034
      80 111.112.84.51,10/Nov/2016:00:01:05 +0800,10,54 ,video,6843
      81 115.193.172.253,10/Nov/2016:00:01:05 +0800,10,362 ,video,3078
      82 106.37.127.231,10/Nov/2016:00:01:05 +0800,10,72 ,video,8199
      83 117.135.159.4,10/Nov/2016:00:01:05 +0800,10,68 ,video,353
      84 117.173.0.113,10/Nov/2016:00:01:05 +0800,10,2956 ,video,8135
      85 211.162.33.107,10/Nov/2016:00:01:05 +0800,10,54 ,video,9815
      86 106.37.127.231,10/Nov/2016:00:01:05 +0800,10,74 ,video,8199
      87 116.23.155.253,10/Nov/2016:00:01:05 +0800,10,54 ,video,9661
      88 106.37.127.231,10/Nov/2016:00:01:05 +0800,10,66 ,video,8199
      89 115.193.172.253,10/Nov/2016:00:01:05 +0800,10,945 ,video,3078
      90 112.65.57.88,10/Nov/2016:00:01:05 +0800,10,54 ,video,9593
      91 117.173.0.113,10/Nov/2016:00:01:05 +0800,10,348 ,video,8135
      92 58.20.14.170,10/Nov/2016:00:01:05 +0800,10,67 ,video,5682
      93 113.139.190.95,10/Nov/2016:00:01:05 +0800,10,67 ,video,9832
      94 119.122.183.89,10/Nov/2016:00:01:05 +0800,10,7226 ,video,3244
      95 125.122.2.73,10/Nov/2016:00:01:05 +0800,10,54 ,video,243
      96 106.37.127.231,10/Nov/2016:00:01:05 +0800,10,306 ,video,8199
      97 117.173.0.113,10/Nov/2016:00:01:05 +0800,10,66 ,video,8135
      98 115.193.172.253,10/Nov/2016:00:01:05 +0800,10,2345 ,video,3078
      99 14.145.74.175,10/Nov/2016:00:01:05 +0800,10,72 ,video,678
     100 115.193.172.253,10/Nov/2016:00:01:05 +0800,10,221 ,video,3078
     101 115.193.172.253,10/Nov/2016:00:01:05 +0800,10,4042 ,video,3078
     102 106.37.127.231,10/Nov/2016:00:01:05 +0800,10,3427 ,video,8199
     103 122.206.190.75,10/Nov/2016:00:01:05 +0800,10,54 ,video,7707
     104 115.193.172.253,10/Nov/2016:00:01:05 +0800,10,66 ,video,3078
     105 110.65.101.188,10/Nov/2016:00:01:05 +0800,10,54 ,video,11786
     106 58.20.14.170,10/Nov/2016:00:01:05 +0800,10,6417 ,video,5682
     107 1.194.187.2,10/Nov/2016:00:01:05 +0800,10,54 ,video,2212
     108 119.124.164.57,10/Nov/2016:00:01:05 +0800,10,54 ,video,4320
     109 106.37.127.231,10/Nov/2016:00:01:05 +0800,10,3280 ,video,8199
     110 58.20.14.170,10/Nov/2016:00:01:05 +0800,10,2957 ,video,5683
     111 223.72.89.88,10/Nov/2016:00:01:05 +0800,10,67 ,video,2139
     112 117.173.0.113,10/Nov/2016:00:01:05 +0800,10,1161 ,video,8135
     113 115.193.172.253,10/Nov/2016:00:01:06 +0800,10,1801 ,video,3078
     114 122.234.60.39,10/Nov/2016:00:01:06 +0800,10,6398 ,video,8837
     115 117.173.0.113,10/Nov/2016:00:01:06 +0800,10,4882 ,video,8135
     116 115.193.172.253,10/Nov/2016:00:01:06 +0800,10,362 ,video,3078
     117 106.37.127.231,10/Nov/2016:00:01:06 +0800,10,302 ,video,8199
     118 117.173.0.113,10/Nov/2016:00:01:06 +0800,10,16776 ,video,8135
     119 115.193.172.253,10/Nov/2016:00:01:06 +0800,10,72 ,video,3078
     120 14.154.180.16,10/Nov/2016:00:01:06 +0800,10,54 ,video,9886
     121 49.4.156.97,10/Nov/2016:00:01:06 +0800,10,54 ,video,5914
     122 101.81.50.177,10/Nov/2016:00:01:06 +0800,10,54 ,video,828
     123 223.104.25.65,10/Nov/2016:00:01:06 +0800,10,54 ,video,9101
     124 58.20.14.170,10/Nov/2016:00:01:06 +0800,10,347 ,video,5683
     125 117.173.0.113,10/Nov/2016:00:01:06 +0800,10,305 ,video,8135
     126 116.22.196.231,10/Nov/2016:00:01:06 +0800,10,54 ,video,6711
     127 58.20.14.170,10/Nov/2016:00:01:06 +0800,10,66 ,video,5683
     128 101.200.101.13,10/Nov/2016:00:01:06 +0800,10,524288 ,video,11938
     129 106.37.127.231,10/Nov/2016:00:01:06 +0800,10,6412 ,video,8199
     130 115.193.172.253,10/Nov/2016:00:01:06 +0800,10,395 ,video,3078
     131 101.200.101.9,10/Nov/2016:00:01:06 +0800,10,524288 ,video,6139
     132 58.20.14.170,10/Nov/2016:00:01:06 +0800,10,1201 ,video,5683
     133 120.27.173.217,10/Nov/2016:00:01:06 +0800,10,4468 ,article,1167
     134 220.191.6.44,10/Nov/2016:00:01:06 +0800,10,6323 ,video,1101
     135 117.173.0.113,10/Nov/2016:00:01:06 +0800,10,72 ,video,8135
     136 101.200.101.13,10/Nov/2016:00:01:06 +0800,10,524288 ,video,11938
     137 112.5.237.224,10/Nov/2016:00:01:06 +0800,10,54 ,video,12478
     138 106.37.127.231,10/Nov/2016:00:01:06 +0800,10,72 ,video,8199
     139 115.193.172.253,10/Nov/2016:00:01:06 +0800,10,4496 ,video,3078
     140 117.164.191.130,10/Nov/2016:00:01:06 +0800,10,54 ,video,6556
     141 49.81.162.183,10/Nov/2016:00:01:06 +0800,10,67 ,video,1816
     142 115.183.25.238,10/Nov/2016:00:01:06 +0800,10,54 ,video,5139
     143 124.64.76.206,10/Nov/2016:00:01:06 +0800,10,54 ,video,3475
     144 120.198.231.152,10/Nov/2016:00:01:06 +0800,10,54 ,video,8652
     145 180.102.115.191,10/Nov/2016:00:01:06 +0800,10,54 ,video,10077
     146 117.173.0.113,10/Nov/2016:00:01:06 +0800,10,2614 ,video,8135
     147 223.93.140.242,10/Nov/2016:00:01:07 +0800,10,67 ,video,2147
     148 115.193.172.253,10/Nov/2016:00:01:07 +0800,10,301 ,video,3078
     149 113.105.128.252,10/Nov/2016:00:01:07 +0800,10,54 ,video,1671
     150 117.173.0.113,10/Nov/2016:00:01:07 +0800,10,6784 ,video,8135
     151 42.243.125.117,10/Nov/2016:00:01:07 +0800,10,54 ,video,8864
     152 117.173.0.113,10/Nov/2016:00:01:07 +0800,10,572 ,video,8135
     153 106.37.127.231,10/Nov/2016:00:01:07 +0800,10,6412 ,video,8199
     154 112.87.108.52,10/Nov/2016:00:01:07 +0800,10,54 ,video,8671
     155 120.85.202.68,10/Nov/2016:00:01:07 +0800,10,54 ,video,3096
     156 115.193.172.253,10/Nov/2016:00:01:07 +0800,10,6589 ,video,3078
     157 117.173.0.113,10/Nov/2016:00:01:07 +0800,10,72 ,video,8135
     158 115.193.172.253,10/Nov/2016:00:01:07 +0800,10,72 ,video,3078
     159 218.75.34.250,10/Nov/2016:00:01:07 +0800,10,54 ,video,9103
     160 115.193.172.253,10/Nov/2016:00:01:07 +0800,10,6589 ,video,3078
     161 58.20.14.170,10/Nov/2016:00:01:07 +0800,10,5485 ,video,5683
     162 175.9.181.138,10/Nov/2016:00:01:07 +0800,10,67 ,video,2877
     163 58.20.14.170,10/Nov/2016:00:01:07 +0800,10,72 ,video,5683
     164 58.20.14.170,10/Nov/2016:00:01:08 +0800,10,3561 ,video,5683
     165 114.42.37.247,10/Nov/2016:00:01:08 +0800,10,54 ,video,6492
     166 14.145.74.175,10/Nov/2016:00:01:08 +0800,10,72 ,video,678
     167 36.46.203.138,10/Nov/2016:00:01:08 +0800,10,54 ,video,2633
     168 58.20.14.170,10/Nov/2016:00:01:08 +0800,10,2230 ,video,5683
     169 101.200.101.207,10/Nov/2016:00:01:08 +0800,10,4468 ,article,11325
     170 58.20.14.170,10/Nov/2016:00:01:08 +0800,10,2195 ,video,5683
     171 58.20.14.170,10/Nov/2016:00:01:08 +0800,10,3388 ,video,5683
     172 124.225.62.61,10/Nov/2016:00:01:08 +0800,10,54 ,video,9704
     173 117.173.0.113,10/Nov/2016:00:01:08 +0800,10,6784 ,video,8135
     174 121.33.168.58,10/Nov/2016:00:01:08 +0800,10,67 ,video,1803
     175 58.20.14.170,10/Nov/2016:00:01:08 +0800,10,324 ,video,5683
     176 222.70.27.27,10/Nov/2016:00:01:08 +0800,10,67 ,video,4877
     177 58.20.14.170,10/Nov/2016:00:01:08 +0800,10,347 ,video,5683
     178 58.20.14.170,10/Nov/2016:00:01:08 +0800,10,348 ,video,5683
     179 106.37.127.231,10/Nov/2016:00:01:08 +0800,10,72 ,video,8199
     180 111.201.78.80,10/Nov/2016:00:01:08 +0800,10,54 ,video,2544
     181 119.139.136.103,10/Nov/2016:00:01:08 +0800,10,54 ,video,4831
     182 61.51.82.242,10/Nov/2016:00:01:09 +0800,10,67 ,video,8792
     183 120.85.77.238,10/Nov/2016:00:01:09 +0800,10,54 ,video,7624
     184 113.200.27.28,10/Nov/2016:00:01:09 +0800,10,54 ,video,2427
     185 61.242.42.35,10/Nov/2016:00:01:09 +0800,10,54 ,video,4736
     186 211.97.105.190,10/Nov/2016:00:01:09 +0800,10,141 ,video,13003
     187 49.52.99.46,10/Nov/2016:00:01:09 +0800,10,54 ,video,2168
     188 106.120.213.44,10/Nov/2016:00:01:09 +0800,10,54 ,video,7533
     189 121.35.180.159,10/Nov/2016:00:01:09 +0800,10,54 ,video,9808
     190 119.131.106.128,10/Nov/2016:00:01:09 +0800,10,54 ,video,8378
     191 180.170.100.94,10/Nov/2016:00:01:09 +0800,10,67 ,video,1412
     192 59.42.128.119,10/Nov/2016:00:01:09 +0800,10,54 ,video,5539
     193 218.106.145.12,10/Nov/2016:00:01:09 +0800,10,67 ,video,9447
     194 183.166.10.212,10/Nov/2016:00:01:09 +0800,10,54 ,video,5867
     195 121.69.41.98,10/Nov/2016:00:01:09 +0800,10,54 ,video,2710
     196 211.157.164.39,10/Nov/2016:00:01:09 +0800,10,54 ,video,1667
     197 115.198.204.33,10/Nov/2016:00:01:10 +0800,10,54 ,video,2929
     198 180.156.241.168,10/Nov/2016:00:01:10 +0800,10,54 ,video,3208
     199 39.182.64.209,10/Nov/2016:00:01:10 +0800,10,54 ,video,3221
     200 218.76.42.130,10/Nov/2016:00:01:10 +0800,10,54 ,video,11561
     201 183.157.162.62,10/Nov/2016:00:01:10 +0800,10,54 ,video,9319
     202 218.17.207.61,10/Nov/2016:00:01:10 +0800,10,54 ,video,8711
     203 122.233.75.87,10/Nov/2016:00:01:10 +0800,10,54 ,video,5475
     204 101.200.101.204,10/Nov/2016:00:01:10 +0800,10,4468 ,article,11325
     205 183.39.154.199,10/Nov/2016:00:01:10 +0800,10,141 ,video,13097
     206 122.96.31.8,10/Nov/2016:00:01:10 +0800,10,54 ,video,13097
     207 182.150.161.68,10/Nov/2016:00:01:10 +0800,10,54 ,video,3725
     208 117.174.26.224,10/Nov/2016:00:01:10 +0800,10,54 ,video,4525
     209 59.172.176.158,10/Nov/2016:00:01:10 +0800,10,67 ,video,4030
     210 221.221.55.197,10/Nov/2016:00:01:11 +0800,10,54 ,video,3734
     211 39.186.247.142,10/Nov/2016:00:01:11 +0800,10,72 ,video,3237
     212 140.207.223.189,10/Nov/2016:00:01:11 +0800,10,54 ,video,13192
     213 120.52.92.2,10/Nov/2016:00:01:11 +0800,10,67 ,video,12342
     214 219.73.46.243,10/Nov/2016:00:01:11 +0800,10,54 ,video,4547
     215 115.193.172.253,10/Nov/2016:00:01:11 +0800,10,6589 ,video,3078
     216 183.39.154.199,10/Nov/2016:00:01:11 +0800,10,67 ,video,13097
     217 27.38.115.174,10/Nov/2016:00:01:11 +0800,10,54 ,video,4519
     218 183.14.120.94,10/Nov/2016:00:01:11 +0800,10,54 ,video,12344
     219 183.63.102.133,10/Nov/2016:00:01:11 +0800,10,54 ,video,5139
     220 106.185.43.251,10/Nov/2016:00:01:11 +0800,10,54 ,video,11950
     221 27.47.233.232,10/Nov/2016:00:01:11 +0800,10,54 ,video,889
     222 110.52.221.73,10/Nov/2016:00:01:11 +0800,10,54 ,video,2212
     223 112.64.61.162,10/Nov/2016:00:01:11 +0800,10,54 ,video,2872
     224 222.210.3.220,10/Nov/2016:00:01:11 +0800,10,54 ,video,5986
     225 121.33.48.151,10/Nov/2016:00:01:11 +0800,10,54 ,video,4932
     226 36.110.49.98,10/Nov/2016:00:01:11 +0800,10,54 ,video,4188
     227 183.17.254.189,10/Nov/2016:00:01:12 +0800,10,54 ,video,371
     228 113.66.21.10,10/Nov/2016:00:01:12 +0800,10,54 ,video,11447
     229 119.122.183.89,10/Nov/2016:00:01:12 +0800,10,72 ,video,3244
     230 1.84.205.195,10/Nov/2016:00:01:12 +0800,10,54 ,video,1412
     231 222.74.205.119,10/Nov/2016:00:01:12 +0800,10,54 ,video,2316
     232 122.234.60.39,10/Nov/2016:00:01:12 +0800,10,54 ,video,11549
     233 113.204.170.2,10/Nov/2016:00:01:12 +0800,10,67 ,video,2163
     234 220.181.38.111,10/Nov/2016:00:01:12 +0800,10,54 ,video,3735
     235 218.6.242.42,10/Nov/2016:00:01:12 +0800,10,54 ,video,10694
     236 123.117.40.2,10/Nov/2016:00:01:12 +0800,10,54 ,video,13311
     237 183.17.235.181,10/Nov/2016:00:01:13 +0800,10,54 ,video,12466
     238 118.26.11.9,10/Nov/2016:00:01:13 +0800,10,68 ,video,10688
     239 112.192.207.41,10/Nov/2016:00:01:13 +0800,10,54 ,video,12302
     240 58.20.14.170,10/Nov/2016:00:01:13 +0800,10,72 ,video,5683
     241 125.124.158.86,10/Nov/2016:00:01:13 +0800,10,67 ,video,2863
     242 116.3.7.232,10/Nov/2016:00:01:13 +0800,10,54 ,video,9028
     243 116.231.194.12,10/Nov/2016:00:01:13 +0800,10,72 ,video,2469
     244 139.196.128.78,10/Nov/2016:00:01:13 +0800,10,524288 ,video,9478
     245 125.120.150.55,10/Nov/2016:00:01:13 +0800,10,67 ,video,9902
     246 122.225.227.162,10/Nov/2016:00:01:13 +0800,10,54 ,video,10683
     247 119.131.143.179,10/Nov/2016:00:01:13 +0800,10,141 ,video,2401
     248 58.250.245.239,10/Nov/2016:00:01:13 +0800,10,54 ,video,10750
     249 117.151.49.48,10/Nov/2016:00:01:13 +0800,10,54 ,video,3399
     250 58.20.14.170,10/Nov/2016:00:01:13 +0800,10,6417 ,video,5683
     251 112.86.38.76,10/Nov/2016:00:01:13 +0800,10,54 ,video,2926
     252 113.140.11.123,10/Nov/2016:00:01:13 +0800,10,54 ,video,1803
     253 140.205.253.132,10/Nov/2016:00:01:13 +0800,10,524288 ,video,7557
     254 58.243.193.233,10/Nov/2016:00:01:14 +0800,10,54 ,video,6468
     255 182.84.104.185,10/Nov/2016:00:01:14 +0800,10,54 ,video,5170
     256 113.65.125.190,10/Nov/2016:00:01:14 +0800,10,54 ,video,8602
     257 118.207.107.228,10/Nov/2016:00:01:14 +0800,10,67 ,video,4962
     258 183.17.254.189,10/Nov/2016:00:01:14 +0800,10,6637 ,video,371
     259 223.104.11.225,10/Nov/2016:00:01:14 +0800,10,54 ,video,889
     260 183.6.25.202,10/Nov/2016:00:01:14 +0800,10,54 ,video,13044
     261 124.78.41.245,10/Nov/2016:00:01:14 +0800,10,54 ,video,13010
     262 210.30.193.153,10/Nov/2016:00:01:14 +0800,10,67 ,video,3521
     263 218.18.125.103,10/Nov/2016:00:01:14 +0800,10,54 ,video,12344
     264 59.63.249.151,10/Nov/2016:00:01:14 +0800,10,54 ,video,633
     265 119.225.142.2,10/Nov/2016:00:01:14 +0800,10,54 ,video,4345
     266 139.196.128.67,10/Nov/2016:00:01:14 +0800,10,524288 ,video,13109
     267 125.94.93.221,10/Nov/2016:00:01:14 +0800,10,72 ,video,4441
     268 113.66.254.162,10/Nov/2016:00:01:14 +0800,10,54 ,video,5915
     269 120.41.28.17,10/Nov/2016:00:01:14 +0800,10,67 ,video,13277
     270 1.192.25.84,10/Nov/2016:00:01:14 +0800,10,54 ,video,5551
     271 119.136.147.91,10/Nov/2016:00:01:14 +0800,10,54 ,video,7740
     272 113.120.48.150,10/Nov/2016:00:01:14 +0800,10,67 ,video,2869
     273 116.236.162.66,10/Nov/2016:00:01:14 +0800,10,54 ,video,8880
     274 139.196.128.67,10/Nov/2016:00:01:14 +0800,10,524288 ,video,13109
     275 124.200.190.34,10/Nov/2016:00:01:15 +0800,10,54 ,video,9025
     276 223.93.140.242,10/Nov/2016:00:01:15 +0800,10,67 ,video,9905
     277 36.33.5.19,10/Nov/2016:00:01:15 +0800,10,54 ,video,12504
     278 223.20.138.152,10/Nov/2016:00:01:15 +0800,10,54 ,video,1818
     279 115.192.189.58,10/Nov/2016:00:01:15 +0800,10,54 ,video,9904
     280 124.200.190.34,10/Nov/2016:00:01:15 +0800,10,67 ,video,9022
     281 59.47.8.126,10/Nov/2016:00:01:15 +0800,10,54 ,video,4526
     282 163.125.235.161,10/Nov/2016:00:01:15 +0800,10,54 ,video,11257
     283 60.22.87.125,10/Nov/2016:00:01:15 +0800,10,72 ,video,1336
     284 116.231.133.23,10/Nov/2016:00:01:15 +0800,10,67 ,video,11822
     285 116.19.167.208,10/Nov/2016:00:01:15 +0800,10,54 ,video,7550
     286 124.200.190.34,10/Nov/2016:00:01:15 +0800,10,67 ,video,9025
     287 120.198.231.151,10/Nov/2016:00:01:15 +0800,10,54 ,video,2544
     288 101.81.225.61,10/Nov/2016:00:01:15 +0800,10,54 ,video,12479
     289 60.191.99.129,10/Nov/2016:00:01:15 +0800,10,54 ,video,6000
     290 113.119.8.170,10/Nov/2016:00:01:15 +0800,10,54 ,video,11820
     291 219.82.203.225,10/Nov/2016:00:01:15 +0800,10,54 ,video,2183
     292 183.39.154.199,10/Nov/2016:00:01:15 +0800,10,67 ,video,13097
     293 58.213.93.130,10/Nov/2016:00:01:15 +0800,10,67 ,video,775
     294 183.39.154.199,10/Nov/2016:00:01:15 +0800,10,6195 ,video,13097
     295 116.231.194.12,10/Nov/2016:00:01:15 +0800,10,54 ,video,2469
     296 120.198.231.154,10/Nov/2016:00:01:15 +0800,10,54 ,video,902
     297 120.193.5.12,10/Nov/2016:00:01:15 +0800,10,54 ,video,11620
     298 14.106.225.10,10/Nov/2016:00:01:16 +0800,10,54 ,video,7623
     299 106.89.87.107,10/Nov/2016:00:01:16 +0800,10,54 ,video,2523
     300 113.71.152.167,10/Nov/2016:00:01:16 +0800,10,54 ,video,2492
     301 112.86.205.25,10/Nov/2016:00:01:16 +0800,10,54 ,video,2499
     302 49.4.161.46,10/Nov/2016:00:01:16 +0800,10,54 ,video,12396
     303 218.88.46.108,10/Nov/2016:00:01:16 +0800,10,54 ,video,12576
     304 122.191.204.232,10/Nov/2016:00:01:16 +0800,10,54 ,video,6074
     305 183.39.154.199,10/Nov/2016:00:01:16 +0800,10,2959 ,video,13098
     306 58.22.61.92,10/Nov/2016:00:01:16 +0800,10,54 ,video,3727
     307 183.39.154.199,10/Nov/2016:00:01:16 +0800,10,348 ,video,13098
     308 183.63.97.232,10/Nov/2016:00:01:16 +0800,10,54 ,video,7557
     309 39.179.202.119,10/Nov/2016:00:01:16 +0800,10,67 ,video,1546
     310 14.23.9.50,10/Nov/2016:00:01:16 +0800,10,54 ,video,5118
     311 221.221.148.132,10/Nov/2016:00:01:16 +0800,10,1041 ,video,13153
     312 128.250.0.113,10/Nov/2016:00:01:16 +0800,10,68 ,video,6584
     313 110.179.148.54,10/Nov/2016:00:01:16 +0800,10,54 ,video,11698
     314 183.39.154.199,10/Nov/2016:00:01:16 +0800,10,2027 ,video,13098
     315 221.221.148.132,10/Nov/2016:00:01:16 +0800,10,3991 ,video,13153
     316 58.60.6.23,10/Nov/2016:00:01:16 +0800,10,54 ,video,2257
     317 210.30.100.2,10/Nov/2016:00:01:16 +0800,10,68 ,video,11551
     318 183.39.154.199,10/Nov/2016:00:01:16 +0800,10,72 ,video,13098
     319 111.0.200.141,10/Nov/2016:00:01:16 +0800,10,67 ,video,3400
     320 183.228.49.158,10/Nov/2016:00:01:16 +0800,10,54 ,video,9633
     321 183.39.154.199,10/Nov/2016:00:01:16 +0800,10,74 ,video,13098
     322 221.221.148.132,10/Nov/2016:00:01:16 +0800,10,2700 ,video,13153
     323 183.60.175.193,10/Nov/2016:00:01:16 +0800,10,54 ,video,1805
     324 183.39.154.199,10/Nov/2016:00:01:16 +0800,10,348 ,video,13098
     325 119.131.143.179,10/Nov/2016:00:01:16 +0800,10,67 ,video,2401
     326 113.118.96.208,10/Nov/2016:00:01:16 +0800,10,54 ,video,9022
     327 221.130.253.135,10/Nov/2016:00:01:16 +0800,10,67 ,video,12302
     328 183.39.154.199,10/Nov/2016:00:01:17 +0800,10,2804 ,video,13098
     329 119.131.143.179,10/Nov/2016:00:01:17 +0800,10,9035 ,video,2401
     330 183.39.154.199,10/Nov/2016:00:01:17 +0800,10,324 ,video,13098
     331 183.39.154.199,10/Nov/2016:00:01:17 +0800,10,185 ,video,13098
     332 118.249.208.191,10/Nov/2016:00:01:17 +0800,10,8589 ,video,12831
     333 183.39.154.199,10/Nov/2016:00:01:17 +0800,10,106 ,video,13098
     334 117.32.216.53,10/Nov/2016:00:01:17 +0800,10,54 ,video,3326
     335 183.39.154.199,10/Nov/2016:00:01:17 +0800,10,6195 ,video,13098
     336 183.39.154.199,10/Nov/2016:00:01:17 +0800,10,4941 ,video,13098
     337 119.131.143.179,10/Nov/2016:00:01:17 +0800,10,2959 ,video,2402
     338 183.16.11.146,10/Nov/2016:00:01:17 +0800,10,54 ,video,7226
     339 183.24.141.90,10/Nov/2016:00:01:17 +0800,10,54 ,video,7214
     340 183.39.154.199,10/Nov/2016:00:01:17 +0800,10,72 ,video,13098
     341 119.131.143.179,10/Nov/2016:00:01:17 +0800,10,354 ,video,2402
     342 118.249.208.191,10/Nov/2016:00:01:17 +0800,10,8589 ,video,12831
     343 183.39.154.199,10/Nov/2016:00:01:17 +0800,10,66 ,video,13098
     344 119.131.143.179,10/Nov/2016:00:01:17 +0800,10,1422 ,video,2402
     345 115.60.82.2,10/Nov/2016:00:01:17 +0800,10,54 ,video,12572
     346 101.40.215.190,10/Nov/2016:00:01:17 +0800,10,54 ,video,4906
     347 114.91.111.210,10/Nov/2016:00:01:18 +0800,10,54 ,video,696
     348 119.131.143.179,10/Nov/2016:00:01:18 +0800,10,17707 ,video,2402
     349 183.39.154.199,10/Nov/2016:00:01:18 +0800,10,4947 ,video,13098
     350 101.227.12.253,10/Nov/2016:00:01:18 +0800,10,54 ,video,5646
     351 223.74.37.85,10/Nov/2016:00:01:18 +0800,10,54 ,video,5694
     352 61.148.244.107,10/Nov/2016:00:01:18 +0800,10,54 ,video,4825
     353 125.119.38.58,10/Nov/2016:00:01:18 +0800,10,54 ,video,12560
     354 119.131.143.179,10/Nov/2016:00:01:18 +0800,10,2635 ,video,2402
     355 119.131.143.179,10/Nov/2016:00:01:18 +0800,10,4471 ,video,2402
     356 119.131.143.179,10/Nov/2016:00:01:18 +0800,10,66 ,video,2402
     357 58.20.14.170,10/Nov/2016:00:01:18 +0800,10,6417 ,video,5683
     358 119.131.143.179,10/Nov/2016:00:01:18 +0800,10,354 ,video,2402
     359 111.137.134.93,10/Nov/2016:00:01:18 +0800,10,7233 ,video,2752
     360 58.242.129.249,10/Nov/2016:00:01:18 +0800,10,54 ,video,7228
     361 58.250.176.134,10/Nov/2016:00:01:18 +0800,10,54 ,video,9214
     362 119.131.143.179,10/Nov/2016:00:01:18 +0800,10,72 ,video,2402
     363 119.131.143.179,10/Nov/2016:00:01:18 +0800,10,4373 ,video,2402
     364 1.203.177.243,10/Nov/2016:00:01:18 +0800,10,6050 ,video,7361
     365 119.131.143.179,10/Nov/2016:00:01:18 +0800,10,1081 ,video,2402
     366 183.39.54.240,10/Nov/2016:00:01:18 +0800,10,54 ,video,13263
     367 119.131.143.179,10/Nov/2016:00:01:19 +0800,10,329 ,video,2402
     368 59.53.31.168,10/Nov/2016:00:01:19 +0800,10,54 ,video,9495
     369 36.33.5.19,10/Nov/2016:00:01:19 +0800,10,6833 ,video,12504
     370 119.131.143.179,10/Nov/2016:00:01:19 +0800,10,390 ,video,2402
     371 1.203.177.243,10/Nov/2016:00:01:19 +0800,10,72 ,video,7361
     372 60.186.195.123,10/Nov/2016:00:01:19 +0800,10,54 ,video,3653
     373 115.156.237.9,10/Nov/2016:00:01:19 +0800,10,67 ,video,8746
     374 125.120.150.55,10/Nov/2016:00:01:19 +0800,10,54 ,video,2450
     375 106.37.179.179,10/Nov/2016:00:01:19 +0800,10,54 ,video,1430
     376 123.112.21.116,10/Nov/2016:00:01:19 +0800,10,54 ,video,4441
     377 221.221.148.132,10/Nov/2016:00:01:19 +0800,10,72 ,video,13153
     378 122.71.75.164,10/Nov/2016:00:01:19 +0800,10,141 ,video,3354
     379 119.131.143.179,10/Nov/2016:00:01:19 +0800,10,9035 ,video,2402
     380 221.221.148.132,10/Nov/2016:00:01:19 +0800,10,319 ,video,13153
     381 106.38.51.208,10/Nov/2016:00:01:19 +0800,10,54 ,video,3720
     382 221.221.148.132,10/Nov/2016:00:01:19 +0800,10,3991 ,video,13153
     383 71.17.103.212,10/Nov/2016:00:01:19 +0800,10,67 ,video,7075
     384 183.228.51.173,10/Nov/2016:00:01:19 +0800,10,54 ,video,12484
     385 42.236.157.243,10/Nov/2016:00:01:19 +0800,10,54 ,video,10694
     386 124.133.245.246,10/Nov/2016:00:01:19 +0800,10,67 ,video,10681
     387 125.77.188.210,10/Nov/2016:00:01:19 +0800,10,54 ,video,9356
     388 110.184.220.157,10/Nov/2016:00:01:19 +0800,10,54 ,video,10427
     389 139.196.128.65,10/Nov/2016:00:01:19 +0800,10,524288 ,video,7974
     390 221.221.148.132,10/Nov/2016:00:01:19 +0800,10,6287 ,video,13153
     391 119.131.143.179,10/Nov/2016:00:01:19 +0800,10,72 ,video,2402
     392 120.1.177.245,10/Nov/2016:00:01:20 +0800,10,67 ,video,3723
     393 183.39.154.199,10/Nov/2016:00:01:20 +0800,10,6195 ,video,13098
     394 120.52.94.104,10/Nov/2016:00:01:20 +0800,10,54 ,video,8217
     395 221.221.148.132,10/Nov/2016:00:01:20 +0800,10,349 ,video,13153
     396 117.89.227.188,10/Nov/2016:00:01:20 +0800,10,66 ,video,1336
     397 121.35.185.119,10/Nov/2016:00:01:20 +0800,10,68 ,video,6161
     398 61.173.68.158,10/Nov/2016:00:01:20 +0800,10,54 ,video,12534
     399 221.221.148.132,10/Nov/2016:00:01:20 +0800,10,2256 ,video,13153
     400 125.91.244.214,10/Nov/2016:00:01:20 +0800,10,54 ,video,1416
     401 117.35.88.30,10/Nov/2016:00:01:20 +0800,10,54 ,video,5926
     402 14.23.136.224,10/Nov/2016:00:01:20 +0800,10,67 ,video,2316
     403 117.89.227.188,10/Nov/2016:00:01:20 +0800,10,1416 ,video,1336
     404 221.221.148.132,10/Nov/2016:00:01:20 +0800,10,72 ,video,13153
     405 117.89.227.188,10/Nov/2016:00:01:20 +0800,10,4192 ,video,1336
     406 124.65.98.198,10/Nov/2016:00:01:20 +0800,10,54 ,video,9887
     407 219.157.250.14,10/Nov/2016:00:01:20 +0800,10,54 ,video,1328
     408 221.221.148.132,10/Nov/2016:00:01:20 +0800,10,74 ,video,13153
     409 117.89.227.188,10/Nov/2016:00:01:20 +0800,10,72 ,video,1336
     410 61.190.33.6,10/Nov/2016:00:01:20 +0800,10,67 ,video,2858
     411 117.89.227.188,10/Nov/2016:00:01:20 +0800,10,4418 ,video,1336
     412 117.89.227.188,10/Nov/2016:00:01:20 +0800,10,678 ,video,1336
     413 101.95.153.34,10/Nov/2016:00:01:20 +0800,10,54 ,video,1716
     414 112.93.198.226,10/Nov/2016:00:01:20 +0800,10,54 ,video,3520
     415 125.118.5.247,10/Nov/2016:00:01:20 +0800,10,54 ,video,1990
     416 117.89.227.188,10/Nov/2016:00:01:20 +0800,10,2263 ,video,1336
     417 1.194.144.222,10/Nov/2016:00:01:20 +0800,10,54 ,video,3589
     418 114.249.202.36,10/Nov/2016:00:01:20 +0800,10,67 ,video,12505
     419 122.71.75.164,10/Nov/2016:00:01:21 +0800,10,67 ,video,3354
     420 117.89.227.188,10/Nov/2016:00:01:21 +0800,10,328 ,video,1336
     421 116.19.167.230,10/Nov/2016:00:01:21 +0800,10,54 ,video,2004
     422 110.184.67.238,10/Nov/2016:00:01:21 +0800,10,54 ,video,5539
     423 223.80.97.99,10/Nov/2016:00:01:21 +0800,10,67 ,video,5553
     424 122.71.75.164,10/Nov/2016:00:01:21 +0800,10,7766 ,video,3354
     425 117.89.227.188,10/Nov/2016:00:01:21 +0800,10,2227 ,video,1336
     426 125.88.24.35,10/Nov/2016:00:01:21 +0800,10,54 ,video,1901
     427 112.115.177.220,10/Nov/2016:00:01:21 +0800,10,54 ,video,4285
     428 117.89.227.188,10/Nov/2016:00:01:21 +0800,10,306 ,video,1336
     429 222.240.165.84,10/Nov/2016:00:01:21 +0800,10,54 ,video,3520
     430 222.131.22.52,10/Nov/2016:00:01:21 +0800,10,67 ,video,2789
     431 122.234.60.39,10/Nov/2016:00:01:21 +0800,10,8443 ,video,8837
     432 124.205.212.177,10/Nov/2016:00:01:21 +0800,10,54 ,video,10505
     433 122.71.75.164,10/Nov/2016:00:01:21 +0800,10,2958 ,video,3369
     434 210.12.48.132,10/Nov/2016:00:01:21 +0800,10,54 ,video,11822
     435 61.183.118.241,10/Nov/2016:00:01:21 +0800,10,54 ,video,7682
     436 117.89.227.188,10/Nov/2016:00:01:21 +0800,10,313 ,video,1336
     437 183.128.108.110,10/Nov/2016:00:01:21 +0800,10,54 ,video,1778
     438 218.18.157.66,10/Nov/2016:00:01:21 +0800,10,297 ,video,3659
     439 121.207.180.238,10/Nov/2016:00:01:21 +0800,10,54 ,video,2685
     440 14.23.183.93,10/Nov/2016:00:01:21 +0800,10,54 ,video,8925
     441 122.71.75.164,10/Nov/2016:00:01:21 +0800,10,358 ,video,3369
     442 122.71.75.164,10/Nov/2016:00:01:21 +0800,10,66 ,video,3369
     443 59.46.181.226,10/Nov/2016:00:01:21 +0800,10,54 ,video,2469
     444 49.74.38.249,10/Nov/2016:00:01:21 +0800,10,141 ,video,634
     445 115.220.63.20,10/Nov/2016:00:01:21 +0800,10,54 ,video,4375
     446 124.90.145.106,10/Nov/2016:00:01:21 +0800,10,54 ,video,5691
     447 122.71.75.164,10/Nov/2016:00:01:21 +0800,10,1214 ,video,3369
     448 117.89.227.188,10/Nov/2016:00:01:21 +0800,10,6665 ,video,1336
     449 122.71.75.164,10/Nov/2016:00:01:22 +0800,10,2345 ,video,3369
     450 58.217.139.123,10/Nov/2016:00:01:22 +0800,10,54 ,video,12701
     451 218.18.157.66,10/Nov/2016:00:01:22 +0800,10,2345 ,video,3659
     452 221.234.230.60,10/Nov/2016:00:01:22 +0800,10,54 ,video,9088
     453 122.71.75.164,10/Nov/2016:00:01:22 +0800,10,358 ,video,3369
     454 122.71.75.164,10/Nov/2016:00:01:22 +0800,10,4004 ,video,3369
     455 117.89.227.188,10/Nov/2016:00:01:22 +0800,10,72 ,video,1336
     456 218.18.157.66,10/Nov/2016:00:01:22 +0800,10,297 ,video,3659
     457 36.57.168.12,10/Nov/2016:00:01:22 +0800,10,54 ,video,7557
     458 117.172.25.86,10/Nov/2016:00:01:22 +0800,10,54 ,video,6694
     459 125.90.50.60,10/Nov/2016:00:01:22 +0800,10,54 ,video,3151
     460 122.71.75.164,10/Nov/2016:00:01:22 +0800,10,2535 ,video,3369
     461 117.100.121.159,10/Nov/2016:00:01:22 +0800,10,54 ,video,6711
     462 114.249.199.177,10/Nov/2016:00:01:22 +0800,10,54 ,video,11551
     463 218.18.157.66,10/Nov/2016:00:01:22 +0800,10,308 ,video,3659
     464 122.71.75.164,10/Nov/2016:00:01:22 +0800,10,1650 ,video,3369
     465 121.33.51.254,10/Nov/2016:00:01:22 +0800,10,54 ,video,6512
     466 182.100.20.75,10/Nov/2016:00:01:22 +0800,10,54 ,video,3244
     467 122.71.75.164,10/Nov/2016:00:01:22 +0800,10,328 ,video,3369
     468 27.41.88.229,10/Nov/2016:00:01:22 +0800,10,54 ,video,2911
     469 123.118.216.81,10/Nov/2016:00:01:22 +0800,10,54 ,video,6421
     470 1.203.177.243,10/Nov/2016:00:01:22 +0800,10,6050 ,video,7361
     471 122.71.75.164,10/Nov/2016:00:01:22 +0800,10,72 ,video,3369
     472 218.18.157.66,10/Nov/2016:00:01:22 +0800,10,448 ,video,3659
     473 122.71.75.164,10/Nov/2016:00:01:23 +0800,10,742 ,video,3369
     474 117.169.140.25,10/Nov/2016:00:01:23 +0800,10,54 ,video,1412
     475 122.71.75.164,10/Nov/2016:00:01:23 +0800,10,4481 ,video,3369
     476 218.18.157.66,10/Nov/2016:00:01:23 +0800,10,1884 ,video,3659
     477 122.71.75.164,10/Nov/2016:00:01:23 +0800,10,7766 ,video,3369
     478 210.21.221.18,10/Nov/2016:00:01:23 +0800,10,54 ,video,11736
     479 117.100.231.8,10/Nov/2016:00:01:23 +0800,10,190 ,video,4017
     480 108.61.180.213,10/Nov/2016:00:01:23 +0800,10,54 ,video,6841
     481 114.141.190.122,10/Nov/2016:00:01:23 +0800,10,67 ,video,13160
     482 36.57.145.114,10/Nov/2016:00:01:23 +0800,10,54 ,video,13271
     483 120.86.130.234,10/Nov/2016:00:01:23 +0800,10,54 ,video,8175
     484 210.41.96.62,10/Nov/2016:00:01:23 +0800,10,54 ,video,3604
     485 218.18.157.66,10/Nov/2016:00:01:23 +0800,10,395 ,video,3659
     486 27.154.86.14,10/Nov/2016:00:01:23 +0800,10,54 ,video,7863
     487 117.100.231.8,10/Nov/2016:00:01:23 +0800,10,3168 ,video,4017
     488 113.65.160.153,10/Nov/2016:00:01:23 +0800,10,54 ,video,3370
     489 123.150.205.98,10/Nov/2016:00:01:23 +0800,10,68 ,video,1758
     490 122.71.75.164,10/Nov/2016:00:01:23 +0800,10,72 ,video,3369
     491 106.120.124.49,10/Nov/2016:00:01:23 +0800,10,54 ,video,3471
     492 36.110.17.19,10/Nov/2016:00:01:24 +0800,10,54 ,video,13160
     493 61.51.82.242,10/Nov/2016:00:01:24 +0800,10,67 ,video,6606
     494 120.198.231.151,10/Nov/2016:00:01:24 +0800,10,54 ,video,13315
     495 125.90.50.156,10/Nov/2016:00:01:24 +0800,10,54 ,video,2147
     496 222.72.45.34,10/Nov/2016:00:01:24 +0800,10,54 ,video,11425
     497 180.102.214.19,10/Nov/2016:00:01:24 +0800,10,54 ,video,7743
     498 171.13.241.97,10/Nov/2016:00:01:24 +0800,10,54074 ,video,5534
     499 171.13.241.97,10/Nov/2016:00:01:24 +0800,10,3212 ,video,5534
     500 58.63.21.177,10/Nov/2016:00:01:24 +0800,10,67 ,video,9332
     501 118.249.208.191,10/Nov/2016:00:01:24 +0800,10,54 ,video,12831
     502 171.13.241.97,10/Nov/2016:00:01:24 +0800,10,2950 ,video,5534
     503 112.64.10.8,10/Nov/2016:00:01:24 +0800,10,54 ,video,3521
     504 119.130.104.156,10/Nov/2016:00:01:24 +0800,10,54 ,video,5677
     505 110.185.16.31,10/Nov/2016:00:01:24 +0800,10,54 ,video,8652
     506 171.13.241.97,10/Nov/2016:00:01:24 +0800,10,205544 ,video,5534
     507 182.201.172.107,10/Nov/2016:00:01:24 +0800,10,54 ,video,13249
     508 180.161.236.98,10/Nov/2016:00:01:24 +0800,10,54 ,video,156
     509 183.48.71.10,10/Nov/2016:00:01:24 +0800,10,54 ,video,10400
     510 58.250.247.130,10/Nov/2016:00:01:24 +0800,10,67 ,video,2872
     511 59.40.133.15,10/Nov/2016:00:01:24 +0800,10,54 ,video,12501
     512 110.90.61.111,10/Nov/2016:00:01:24 +0800,10,54 ,video,179
     513 119.145.15.156,10/Nov/2016:00:01:25 +0800,10,54 ,video,11050
     514 183.54.198.81,10/Nov/2016:00:01:25 +0800,10,54 ,video,1625
     515 116.22.115.108,10/Nov/2016:00:01:25 +0800,10,54 ,video,3301
     516 27.46.6.191,10/Nov/2016:00:01:25 +0800,10,54 ,video,1681
     517 125.92.121.122,10/Nov/2016:00:01:25 +0800,10,54 ,video,13339
     518 222.92.141.18,10/Nov/2016:00:01:25 +0800,10,54 ,video,11689
     519 118.112.58.228,10/Nov/2016:00:01:25 +0800,10,54 ,video,8491
     520 218.109.108.228,10/Nov/2016:00:01:25 +0800,10,54 ,video,9669
     521 182.18.117.210,10/Nov/2016:00:01:25 +0800,10,54 ,video,8515
     522 111.161.148.23,10/Nov/2016:00:01:25 +0800,10,54 ,video,9566
     523 183.240.20.42,10/Nov/2016:00:01:26 +0800,10,54 ,video,525
     524 58.44.240.162,10/Nov/2016:00:01:26 +0800,10,54 ,video,12815
     525 60.186.5.64,10/Nov/2016:00:01:26 +0800,10,54 ,video,11551
     526 222.129.145.85,10/Nov/2016:00:01:26 +0800,10,54 ,video,10324
     527 183.207.178.205,10/Nov/2016:00:01:26 +0800,10,54 ,video,7409
     528 101.224.111.144,10/Nov/2016:00:01:26 +0800,10,54 ,video,3085
     529 111.198.233.158,10/Nov/2016:00:01:26 +0800,10,54 ,video,2633
     530 119.131.106.128,10/Nov/2016:00:01:26 +0800,10,67 ,video,8485
     531 123.53.190.91,10/Nov/2016:00:01:26 +0800,10,54 ,video,11316
     532 123.157.208.18,10/Nov/2016:00:01:26 +0800,10,67 ,video,12622
     533 175.152.2.169,10/Nov/2016:00:01:26 +0800,10,141 ,video,2644
     534 45.32.34.196,10/Nov/2016:00:01:26 +0800,10,67 ,video,6687
     535 171.120.24.254,10/Nov/2016:00:01:26 +0800,10,54 ,video,2520
     536 171.8.148.158,10/Nov/2016:00:01:26 +0800,10,54 ,video,8299
     537 202.107.210.51,10/Nov/2016:00:01:26 +0800,10,68 ,video,1904
     538 58.250.198.7,10/Nov/2016:00:01:26 +0800,10,54 ,video,6701
     539 118.207.116.20,10/Nov/2016:00:01:26 +0800,10,54 ,video,3002
     540 222.79.80.123,10/Nov/2016:00:01:27 +0800,10,54 ,video,4415
     541 182.242.227.199,10/Nov/2016:00:01:27 +0800,10,67 ,video,1628
     542 42.48.158.135,10/Nov/2016:00:01:27 +0800,10,54 ,video,703
     543 125.120.150.55,10/Nov/2016:00:01:27 +0800,10,67 ,video,8286
     544 59.46.175.212,10/Nov/2016:00:01:27 +0800,10,54 ,video,12680
     545 222.137.65.229,10/Nov/2016:00:01:27 +0800,10,54 ,video,7544
     546 210.12.145.219,10/Nov/2016:00:01:27 +0800,10,54 ,video,1689
     547 222.128.172.20,10/Nov/2016:00:01:27 +0800,10,54 ,video,10061
     548 117.89.227.188,10/Nov/2016:00:01:27 +0800,10,6665 ,video,1336
     549 210.30.58.22,10/Nov/2016:00:01:27 +0800,10,54 ,video,8152
     550 119.130.185.151,10/Nov/2016:00:01:27 +0800,10,54 ,video,5647
     551 124.65.98.198,10/Nov/2016:00:01:27 +0800,10,54 ,video,5987
     552 61.142.10.231,10/Nov/2016:00:01:27 +0800,10,54 ,video,12482
     553 14.153.236.58,10/Nov/2016:00:01:27 +0800,10,320 ,video,6689
     554 14.153.236.58,10/Nov/2016:00:01:27 +0800,10,4166 ,video,6689
     555 223.93.140.242,10/Nov/2016:00:01:28 +0800,10,67 ,video,9813
     556 14.153.236.58,10/Nov/2016:00:01:28 +0800,10,66 ,video,6689
     557 27.38.44.210,10/Nov/2016:00:01:28 +0800,10,54 ,video,816
     558 14.153.236.58,10/Nov/2016:00:01:28 +0800,10,10732 ,video,6689
     559 222.80.96.74,10/Nov/2016:00:01:28 +0800,10,54 ,video,1326
     560 220.181.38.110,10/Nov/2016:00:01:28 +0800,10,54 ,video,12886
     561 14.153.236.58,10/Nov/2016:00:01:28 +0800,10,2612 ,video,6689
     562 61.183.118.245,10/Nov/2016:00:01:28 +0800,10,54 ,video,2752
     563 14.153.236.58,10/Nov/2016:00:01:28 +0800,10,914 ,video,6689
     564 125.90.50.87,10/Nov/2016:00:01:28 +0800,10,54 ,video,9579
     565 117.41.234.99,10/Nov/2016:00:01:28 +0800,10,67 ,video,1091
     566 120.198.231.151,10/Nov/2016:00:01:28 +0800,10,342 ,video,5644
     567 120.198.231.151,10/Nov/2016:00:01:28 +0800,10,66 ,video,5644
     568 14.153.236.58,10/Nov/2016:00:01:28 +0800,10,72 ,video,6689
     569 120.198.231.151,10/Nov/2016:00:01:28 +0800,10,2959 ,video,5644
     570 120.198.231.150,10/Nov/2016:00:01:28 +0800,10,54 ,video,10692
     571 42.236.157.243,10/Nov/2016:00:01:28 +0800,10,67 ,video,10694
     572 14.153.236.58,10/Nov/2016:00:01:28 +0800,10,74 ,video,6689
     573 140.205.253.145,10/Nov/2016:00:01:28 +0800,10,524288 ,video,5609
     574 14.153.236.58,10/Nov/2016:00:01:28 +0800,10,179 ,video,6689
     575 219.243.215.194,10/Nov/2016:00:01:28 +0800,10,54 ,video,774
     576 120.198.231.151,10/Nov/2016:00:01:28 +0800,10,1052 ,video,5644
     577 120.196.62.207,10/Nov/2016:00:01:28 +0800,10,54 ,video,6510
     578 14.153.236.58,10/Nov/2016:00:01:29 +0800,10,320 ,video,6689
     579 175.152.2.169,10/Nov/2016:00:01:29 +0800,10,67 ,video,2644
     580 115.192.161.60,10/Nov/2016:00:01:29 +0800,10,54 ,video,12897
     581 112.64.60.228,10/Nov/2016:00:01:29 +0800,10,54 ,video,5433
     582 113.107.163.197,10/Nov/2016:00:01:29 +0800,10,54 ,video,2808
     583 122.71.75.164,10/Nov/2016:00:01:29 +0800,10,7766 ,video,3369
     584 58.241.76.18,10/Nov/2016:00:01:29 +0800,10,2635 ,video,1802
     585 175.152.2.169,10/Nov/2016:00:01:29 +0800,10,5 ,video,2644
     586 120.198.231.151,10/Nov/2016:00:01:29 +0800,10,342 ,video,5644
     587 110.88.48.16,10/Nov/2016:00:01:29 +0800,10,54 ,video,1762
     588 123.157.217.162,10/Nov/2016:00:01:29 +0800,10,67 ,video,4417
     589 117.41.234.99,10/Nov/2016:00:01:29 +0800,10,67 ,video,1202
     590 60.191.78.148,10/Nov/2016:00:01:29 +0800,10,67 ,video,5478
     591 120.198.231.151,10/Nov/2016:00:01:29 +0800,10,4849 ,video,5644
     592 42.248.114.145,10/Nov/2016:00:01:29 +0800,10,54 ,video,4242
     593 175.152.2.169,10/Nov/2016:00:01:29 +0800,10,8182 ,video,2644
     594 80.78.215.116,10/Nov/2016:00:01:29 +0800,10,67 ,video,9905
     595 125.120.150.55,10/Nov/2016:00:01:29 +0800,10,67 ,video,8286
     596 111.37.29.165,10/Nov/2016:00:01:29 +0800,10,67 ,video,8413
     597 14.153.236.58,10/Nov/2016:00:01:29 +0800,10,6777 ,video,6689
     598 101.200.101.21,10/Nov/2016:00:01:29 +0800,10,524288 ,video,10506
     599 58.241.76.18,10/Nov/2016:00:01:29 +0800,10,95 ,video,1802
     600 218.245.66.245,10/Nov/2016:00:01:29 +0800,10,54 ,video,10674
     601 120.196.62.207,10/Nov/2016:00:01:29 +0800,10,67 ,video,4525
     602 113.120.49.46,10/Nov/2016:00:01:30 +0800,10,54 ,video,6206
     603 182.242.227.199,10/Nov/2016:00:01:30 +0800,10,54 ,video,1626
     604 120.198.231.151,10/Nov/2016:00:01:30 +0800,10,1921 ,video,5644
     605 101.200.101.21,10/Nov/2016:00:01:30 +0800,10,524288 ,video,10506
     606 114.251.179.129,10/Nov/2016:00:01:30 +0800,10,54 ,video,10450
     607 113.132.11.88,10/Nov/2016:00:01:30 +0800,10,54 ,video,5664
     608 115.171.143.119,10/Nov/2016:00:01:30 +0800,10,54 ,video,4713
     609 115.199.179.156,10/Nov/2016:00:01:30 +0800,10,54 ,video,7099
     610 120.52.92.3,10/Nov/2016:00:01:30 +0800,10,141 ,video,11288
     611 220.181.38.112,10/Nov/2016:00:01:30 +0800,10,54 ,video,2475
     612 183.5.244.42,10/Nov/2016:00:01:30 +0800,10,54 ,video,2474
     613 59.172.176.229,10/Nov/2016:00:01:30 +0800,10,54 ,video,1328
     614 218.205.169.193,10/Nov/2016:00:01:30 +0800,10,54 ,video,7950
     615 59.172.142.93,10/Nov/2016:00:01:30 +0800,10,54 ,video,7704
     616 219.143.13.59,10/Nov/2016:00:01:30 +0800,10,67 ,video,9547
     617 14.153.236.58,10/Nov/2016:00:01:30 +0800,10,72 ,video,6689
     618 39.176.195.5,10/Nov/2016:00:01:31 +0800,10,54 ,video,2687
     619 122.224.33.106,10/Nov/2016:00:01:31 +0800,10,54 ,video,1455
     620 61.141.142.19,10/Nov/2016:00:01:31 +0800,10,54 ,video,2882
     621 116.233.89.239,10/Nov/2016:00:01:31 +0800,10,54 ,video,4708
     622 1.85.61.18,10/Nov/2016:00:01:31 +0800,10,54 ,video,6578
     623 58.209.20.172,10/Nov/2016:00:01:31 +0800,10,54 ,video,2174
     624 112.80.186.13,10/Nov/2016:00:01:31 +0800,10,54 ,video,3345
     625 120.210.189.251,10/Nov/2016:00:01:31 +0800,10,54 ,video,11224
     626 119.131.143.179,10/Nov/2016:00:01:31 +0800,10,9035 ,video,2402
     627 219.150.53.96,10/Nov/2016:00:01:31 +0800,10,54 ,video,1709
     628 114.248.224.214,10/Nov/2016:00:01:31 +0800,10,67 ,video,1308
     629 117.166.15.72,10/Nov/2016:00:01:31 +0800,10,54 ,video,4323
     630 114.248.224.214,10/Nov/2016:00:01:31 +0800,10,6690 ,video,1308
     631 110.80.26.230,10/Nov/2016:00:01:31 +0800,10,54 ,video,12481
     632 58.62.103.176,10/Nov/2016:00:01:32 +0800,10,67 ,video,6429
     633 222.212.194.52,10/Nov/2016:00:01:32 +0800,10,54 ,video,5615
     634 182.18.111.38,10/Nov/2016:00:01:32 +0800,10,54 ,video,4451
     635 114.249.93.42,10/Nov/2016:00:01:32 +0800,10,54 ,video,11950
     636 113.246.94.4,10/Nov/2016:00:01:32 +0800,10,54 ,video,773
     637 119.145.72.168,10/Nov/2016:00:01:32 +0800,10,54 ,video,6209
     638 114.248.224.214,10/Nov/2016:00:01:32 +0800,10,2958 ,video,1309
     639 113.87.230.207,10/Nov/2016:00:01:32 +0800,10,67 ,video,9802
     640 117.100.231.8,10/Nov/2016:00:01:32 +0800,10,141 ,video,4017
     641 118.207.116.20,10/Nov/2016:00:01:32 +0800,10,72 ,video,3002
     642 222.168.40.123,10/Nov/2016:00:01:32 +0800,10,67 ,video,12883
     643 49.74.38.249,10/Nov/2016:00:01:32 +0800,10,67 ,video,634
     644 211.80.86.94,10/Nov/2016:00:01:32 +0800,10,67 ,video,5288
     645 220.240.226.90,10/Nov/2016:00:01:32 +0800,10,54 ,video,2634
     646 114.248.224.214,10/Nov/2016:00:01:32 +0800,10,339 ,video,1309
     647 123.234.233.109,10/Nov/2016:00:01:32 +0800,10,67 ,video,11225
     648 221.221.202.248,10/Nov/2016:00:01:32 +0800,10,54 ,video,3345
     649 113.109.214.12,10/Nov/2016:00:01:32 +0800,10,54 ,video,10802
     650 27.38.0.184,10/Nov/2016:00:01:32 +0800,10,54 ,video,7198
     651 114.248.224.214,10/Nov/2016:00:01:32 +0800,10,1246 ,video,1309
     652 124.127.79.228,10/Nov/2016:00:01:32 +0800,10,54 ,video,9819
     653 101.40.175.228,10/Nov/2016:00:01:32 +0800,10,54 ,video,12905
     654 116.243.183.21,10/Nov/2016:00:01:32 +0800,10,54 ,video,9970
     655 220.198.208.176,10/Nov/2016:00:01:32 +0800,10,54 ,video,2789
     656 114.248.224.214,10/Nov/2016:00:01:33 +0800,10,1955 ,video,1309
     657 114.248.224.214,10/Nov/2016:00:01:33 +0800,10,519 ,video,1309
     658 111.172.46.191,10/Nov/2016:00:01:33 +0800,10,54 ,video,1708
     659 222.173.219.54,10/Nov/2016:00:01:33 +0800,10,54 ,video,5941
     660 114.248.224.214,10/Nov/2016:00:01:33 +0800,10,339 ,video,1309
     661 114.248.224.214,10/Nov/2016:00:01:33 +0800,10,306 ,video,1309
     662 139.196.128.78,10/Nov/2016:00:01:33 +0800,10,524288 ,video,9478
     663 39.179.202.119,10/Nov/2016:00:01:33 +0800,10,54 ,video,2159
     664 58.250.198.10,10/Nov/2016:00:01:33 +0800,10,54 ,video,6712
     665 221.221.223.134,10/Nov/2016:00:01:33 +0800,10,54 ,video,371
     666 42.243.70.197,10/Nov/2016:00:01:33 +0800,10,54 ,video,4188
     667 114.248.224.214,10/Nov/2016:00:01:33 +0800,10,323 ,video,1309
     668 58.33.184.252,10/Nov/2016:00:01:33 +0800,10,67 ,video,4247
     669 113.132.11.206,10/Nov/2016:00:01:33 +0800,10,54 ,video,11823
     670 218.65.215.17,10/Nov/2016:00:01:33 +0800,10,54 ,video,11041
     671 114.248.224.214,10/Nov/2016:00:01:33 +0800,10,2700 ,video,1309
     672 114.248.224.214,10/Nov/2016:00:01:33 +0800,10,3421 ,video,1309
     673 114.248.224.214,10/Nov/2016:00:01:33 +0800,10,66 ,video,1309
     674 140.207.223.190,10/Nov/2016:00:01:33 +0800,10,54 ,video,3665
     675 114.248.224.214,10/Nov/2016:00:01:33 +0800,10,3421 ,video,1309
     676 183.4.176.116,10/Nov/2016:00:01:33 +0800,10,54 ,video,2427
     677 114.248.224.214,10/Nov/2016:00:01:33 +0800,10,72 ,video,1309
     678 122.224.33.97,10/Nov/2016:00:01:33 +0800,10,54 ,video,3016
     679 123.149.32.122,10/Nov/2016:00:01:33 +0800,10,54 ,video,3645
     680 211.83.242.122,10/Nov/2016:00:01:33 +0800,10,54 ,video,4451
     681 106.5.219.134,10/Nov/2016:00:01:33 +0800,10,54 ,video,7479
     682 182.100.26.109,10/Nov/2016:00:01:33 +0800,10,54 ,video,11709
     683 114.248.224.214,10/Nov/2016:00:01:33 +0800,10,6690 ,video,1309
     684 101.40.175.228,10/Nov/2016:00:01:34 +0800,10,67 ,video,11716
     685 61.51.82.242,10/Nov/2016:00:01:34 +0800,10,54 ,video,3262
     686 121.69.23.250,10/Nov/2016:00:01:34 +0800,10,54 ,video,12495
     687 218.88.29.153,10/Nov/2016:00:01:34 +0800,10,54 ,video,1446
     688 117.41.234.99,10/Nov/2016:00:01:34 +0800,10,54 ,video,1092
     689 113.57.24.53,10/Nov/2016:00:01:34 +0800,10,54 ,video,2523
     690 60.191.99.129,10/Nov/2016:00:01:34 +0800,10,54 ,video,3520
     691 115.156.142.179,10/Nov/2016:00:01:34 +0800,10,54 ,video,12280
     692 223.21.111.79,10/Nov/2016:00:01:34 +0800,10,54 ,video,11714
     693 111.132.18.241,10/Nov/2016:00:01:34 +0800,10,54 ,video,3473
     694 71.17.103.212,10/Nov/2016:00:01:34 +0800,10,67 ,video,7075
     695 14.23.188.111,10/Nov/2016:00:01:34 +0800,10,54 ,video,2418
     696 125.88.24.91,10/Nov/2016:00:01:34 +0800,10,54 ,video,1501
     697 115.193.172.253,10/Nov/2016:00:01:34 +0800,10,72 ,video,3078
     698 112.12.192.150,10/Nov/2016:00:01:34 +0800,10,54 ,video,1861
     699 113.91.162.210,10/Nov/2016:00:01:34 +0800,10,67 ,video,1809
     700 14.23.136.224,10/Nov/2016:00:01:34 +0800,10,54 ,video,2316
     701 125.122.26.81,10/Nov/2016:00:01:35 +0800,10,54 ,video,3225
     702 183.240.20.251,10/Nov/2016:00:01:35 +0800,10,54 ,video,3225
     703 117.136.39.218,10/Nov/2016:00:01:35 +0800,10,54 ,video,1414
     704 121.35.2.128,10/Nov/2016:00:01:35 +0800,10,54 ,video,12580
     705 222.76.251.186,10/Nov/2016:00:01:35 +0800,10,54 ,video,11725
     706 140.205.253.137,10/Nov/2016:00:01:35 +0800,10,524288 ,video,13181
     707 14.28.139.202,10/Nov/2016:00:01:35 +0800,10,54 ,video,7727
     708 171.37.141.121,10/Nov/2016:00:01:35 +0800,10,54 ,video,12163
     709 180.173.242.43,10/Nov/2016:00:01:35 +0800,10,54 ,video,6046
     710 223.20.63.251,10/Nov/2016:00:01:35 +0800,10,54 ,video,3246
     711 27.42.25.21,10/Nov/2016:00:01:35 +0800,10,67 ,video,9888
     712 113.87.161.137,10/Nov/2016:00:01:35 +0800,10,141 ,video,8006
     713 183.66.87.224,10/Nov/2016:00:01:35 +0800,10,54 ,video,12133
     714 220.168.79.189,10/Nov/2016:00:01:35 +0800,10,54 ,video,13038
     715 175.10.206.212,10/Nov/2016:00:01:35 +0800,10,54 ,video,3956
     716 118.207.116.20,10/Nov/2016:00:01:35 +0800,10,72 ,video,3002
     717 112.10.27.228,10/Nov/2016:00:01:35 +0800,10,828 ,article,3669
     718 112.10.27.228,10/Nov/2016:00:01:35 +0800,10,549 ,article,3669
     719 112.10.27.228,10/Nov/2016:00:01:35 +0800,10,16756 ,article,3669
     720 111.196.209.12,10/Nov/2016:00:01:35 +0800,10,54 ,video,11443
     721 112.10.27.228,10/Nov/2016:00:01:35 +0800,10,498 ,article,3669
     722 112.10.27.228,10/Nov/2016:00:01:35 +0800,10,12541 ,article,3669
     723 171.8.199.118,10/Nov/2016:00:01:35 +0800,10,68 ,video,3738
     724 112.10.27.228,10/Nov/2016:00:01:35 +0800,10,9800 ,article,3669
     725 120.52.94.106,10/Nov/2016:00:01:36 +0800,10,54 ,video,678
     726 112.10.27.228,10/Nov/2016:00:01:36 +0800,10,628 ,article,3669
     727 112.10.27.228,10/Nov/2016:00:01:36 +0800,10,591 ,article,3669
     728 112.10.27.228,10/Nov/2016:00:01:36 +0800,10,2951 ,article,3669
     729 112.10.27.228,10/Nov/2016:00:01:36 +0800,10,270967 ,article,3669
     730 117.100.231.8,10/Nov/2016:00:01:36 +0800,10,67 ,video,4017
     731 182.138.128.41,10/Nov/2016:00:01:36 +0800,10,330 ,video,11239
     732 182.138.128.41,10/Nov/2016:00:01:36 +0800,10,3892 ,video,11239
     733 182.138.128.41,10/Nov/2016:00:01:36 +0800,10,66 ,video,11239
     734 101.200.101.21,10/Nov/2016:00:01:36 +0800,10,524288 ,video,10506
     735 182.138.128.41,10/Nov/2016:00:01:36 +0800,10,2959 ,video,11239
     736 112.64.60.41,10/Nov/2016:00:01:36 +0800,10,54 ,video,4366
     737 117.100.231.8,10/Nov/2016:00:01:36 +0800,10,7269 ,video,4017
     738 112.10.27.228,10/Nov/2016:00:01:36 +0800,10,4468 ,article,3669
     739 112.10.27.228,10/Nov/2016:00:01:36 +0800,10,2023 ,article,3669
     740 182.138.128.41,10/Nov/2016:00:01:36 +0800,10,72 ,video,11239
     741 114.242.167.68,10/Nov/2016:00:01:36 +0800,10,6511 ,video,4451
     742 221.237.87.40,10/Nov/2016:00:01:36 +0800,10,54 ,video,8809
     743 112.10.27.228,10/Nov/2016:00:01:36 +0800,10,18906 ,article,3669
     744 1.85.61.37,10/Nov/2016:00:01:36 +0800,10,54 ,video,7212
     745 112.10.27.228,10/Nov/2016:00:01:36 +0800,10,5102 ,article,3669
     746 182.139.108.80,10/Nov/2016:00:01:36 +0800,10,54 ,video,1459
     747 101.200.101.31,10/Nov/2016:00:01:36 +0800,10,524288 ,video,8175
     748 182.138.128.41,10/Nov/2016:00:01:36 +0800,10,113 ,video,11239
     749 114.248.224.214,10/Nov/2016:00:01:36 +0800,10,72 ,video,1309
     750 182.138.128.41,10/Nov/2016:00:01:36 +0800,10,2614 ,video,11239
     751 112.10.27.228,10/Nov/2016:00:01:36 +0800,10,890 ,article,3669
     752 182.138.128.41,10/Nov/2016:00:01:36 +0800,10,330 ,video,11239
     753 182.138.128.41,10/Nov/2016:00:01:36 +0800,10,643 ,video,11239
     754 113.119.10.98,10/Nov/2016:00:01:36 +0800,10,67 ,video,6224
     755 58.249.67.242,10/Nov/2016:00:01:37 +0800,10,54 ,video,11014
     756 182.138.128.41,10/Nov/2016:00:01:37 +0800,10,303 ,video,11239
     757 182.138.128.41,10/Nov/2016:00:01:37 +0800,10,318 ,video,11239
     758 120.41.120.245,10/Nov/2016:00:01:37 +0800,10,54 ,video,5984
     759 58.217.165.114,10/Nov/2016:00:01:37 +0800,10,54 ,video,10692
     760 117.100.231.8,10/Nov/2016:00:01:37 +0800,10,2957 ,video,4018
     761 182.138.128.41,10/Nov/2016:00:01:37 +0800,10,1541 ,video,11239
     762 121.69.23.250,10/Nov/2016:00:01:37 +0800,10,67 ,video,12495
     763 182.138.128.41,10/Nov/2016:00:01:37 +0800,10,74 ,video,11239
     764 123.151.12.154,10/Nov/2016:00:01:37 +0800,10,3493 ,video,5865
     765 182.138.128.41,10/Nov/2016:00:01:37 +0800,10,72 ,video,11239
     766 39.159.109.210,10/Nov/2016:00:01:37 +0800,10,54 ,video,6203
     767 222.73.202.154,10/Nov/2016:00:01:37 +0800,10,68 ,video,12678
     768 61.152.132.230,10/Nov/2016:00:01:37 +0800,10,54 ,video,6495
     769 182.138.128.41,10/Nov/2016:00:01:37 +0800,10,6207 ,video,11239
     770 116.235.102.120,10/Nov/2016:00:01:37 +0800,10,54 ,video,8999
     771 58.246.74.211,10/Nov/2016:00:01:37 +0800,10,67 ,video,11731
     772 222.65.226.176,10/Nov/2016:00:01:37 +0800,10,54 ,video,10511
     773 123.151.12.154,10/Nov/2016:00:01:37 +0800,10,2957 ,video,5866
     774 218.106.145.12,10/Nov/2016:00:01:37 +0800,10,54 ,video,9447
     775 110.65.101.188,10/Nov/2016:00:01:37 +0800,10,67 ,video,6721
     776 117.100.231.8,10/Nov/2016:00:01:37 +0800,10,357 ,video,4018
     777 116.237.53.200,10/Nov/2016:00:01:37 +0800,10,54 ,video,4161
     778 27.41.69.240,10/Nov/2016:00:01:38 +0800,10,67 ,video,11610
     779 58.217.165.114,10/Nov/2016:00:01:38 +0800,10,67 ,video,10690
     780 71.17.103.212,10/Nov/2016:00:01:38 +0800,10,67 ,video,7075
     781 117.100.231.8,10/Nov/2016:00:01:38 +0800,10,66 ,video,4018
     782 117.100.231.8,10/Nov/2016:00:01:38 +0800,10,951 ,video,4018
     783 49.77.220.79,10/Nov/2016:00:01:38 +0800,10,54 ,video,1102
     784 117.100.231.8,10/Nov/2016:00:01:38 +0800,10,5363 ,video,4018
     785 58.63.21.177,10/Nov/2016:00:01:38 +0800,10,54 ,video,10314
     786 117.100.231.8,10/Nov/2016:00:01:38 +0800,10,894 ,video,4018
     787 120.198.231.152,10/Nov/2016:00:01:38 +0800,10,54 ,video,1803
     788 117.100.231.8,10/Nov/2016:00:01:38 +0800,10,5155 ,video,4018
     789 117.100.231.8,10/Nov/2016:00:01:38 +0800,10,2286 ,video,4018
     790 71.17.103.212,10/Nov/2016:00:01:38 +0800,10,6260 ,video,7075
     791 121.207.222.221,10/Nov/2016:00:01:38 +0800,10,54 ,video,9328
     792 39.187.166.65,10/Nov/2016:00:01:38 +0800,10,54 ,video,3632
     793 117.100.231.8,10/Nov/2016:00:01:38 +0800,10,2536 ,video,4018
     794 171.216.69.80,10/Nov/2016:00:01:38 +0800,10,54 ,video,8714
     795 123.119.218.242,10/Nov/2016:00:01:38 +0800,10,54 ,video,13013
     796 223.81.137.65,10/Nov/2016:00:01:38 +0800,10,54 ,video,7303
     797 117.100.231.8,10/Nov/2016:00:01:38 +0800,10,357 ,video,4018
     798 192.240.123.193,10/Nov/2016:00:01:38 +0800,10,67 ,video,12881
     799 117.100.231.8,10/Nov/2016:00:01:38 +0800,10,72 ,video,4018
     800 116.24.24.10,10/Nov/2016:00:01:38 +0800,10,54 ,video,2910
     801 117.100.231.8,10/Nov/2016:00:01:38 +0800,10,1092 ,video,4018
     802 114.248.224.214,10/Nov/2016:00:01:39 +0800,10,4022 ,video,1309
     803 113.143.158.241,10/Nov/2016:00:01:39 +0800,10,141 ,video,4299
     804 36.5.155.118,10/Nov/2016:00:01:39 +0800,10,54 ,video,4251
     805 114.248.224.214,10/Nov/2016:00:01:39 +0800,10,13241 ,video,1309
     806 117.100.231.8,10/Nov/2016:00:01:39 +0800,10,321 ,video,4018
     807 39.186.247.142,10/Nov/2016:00:01:39 +0800,10,7227 ,video,3237
     808 119.123.177.2,10/Nov/2016:00:01:39 +0800,10,54 ,video,6420
     809 110.80.187.200,10/Nov/2016:00:01:39 +0800,10,54 ,video,8356
     810 114.24.40.251,10/Nov/2016:00:01:39 +0800,10,54 ,video,1059
     811 14.127.27.212,10/Nov/2016:00:01:39 +0800,10,54 ,video,10686
     812 113.87.161.137,10/Nov/2016:00:01:39 +0800,10,67 ,video,8006
     813 49.72.238.254,10/Nov/2016:00:01:39 +0800,10,54 ,video,2664
     814 115.231.148.38,10/Nov/2016:00:01:39 +0800,10,54 ,video,5645
     815 106.39.200.44,10/Nov/2016:00:01:39 +0800,10,54 ,video,9579
     816 222.178.202.108,10/Nov/2016:00:01:39 +0800,10,54 ,video,2861
     817 115.174.68.92,10/Nov/2016:00:01:39 +0800,10,54 ,video,9809
     818 183.204.48.118,10/Nov/2016:00:01:39 +0800,10,54 ,video,8212
     819 119.130.229.205,10/Nov/2016:00:01:39 +0800,10,54 ,video,4761
     820 59.41.95.198,10/Nov/2016:00:01:39 +0800,10,54 ,video,9023
     821 101.38.157.182,10/Nov/2016:00:01:39 +0800,10,67 ,video,2163
     822 221.226.97.31,10/Nov/2016:00:01:40 +0800,10,54 ,video,5139
     823 202.107.210.51,10/Nov/2016:00:01:40 +0800,10,68 ,video,8476
     824 183.185.57.58,10/Nov/2016:00:01:40 +0800,10,54 ,video,10679
     825 140.207.223.186,10/Nov/2016:00:01:40 +0800,10,54 ,video,13310
     826 101.39.103.224,10/Nov/2016:00:01:40 +0800,10,54 ,video,1412
     827 140.207.223.186,10/Nov/2016:00:01:40 +0800,10,67 ,video,5609
     828 202.107.210.51,10/Nov/2016:00:01:40 +0800,10,68 ,video,3380
     829 210.30.109.61,10/Nov/2016:00:01:40 +0800,10,54 ,video,9819
     830 202.118.102.15,10/Nov/2016:00:01:40 +0800,10,54 ,video,8141
     831 116.227.96.89,10/Nov/2016:00:01:40 +0800,10,54 ,video,7600
     832 118.113.41.210,10/Nov/2016:00:01:40 +0800,10,54 ,video,1054
     833 119.129.80.141,10/Nov/2016:00:01:40 +0800,10,54 ,video,13048
     834 171.34.223.23,10/Nov/2016:00:01:40 +0800,10,54 ,video,9813
     835 95.85.18.128,10/Nov/2016:00:01:40 +0800,10,67 ,video,12302
     836 117.152.76.120,10/Nov/2016:00:01:40 +0800,10,54 ,video,2667
     837 60.29.171.162,10/Nov/2016:00:01:41 +0800,10,54 ,video,8913
     838 180.175.49.155,10/Nov/2016:00:01:41 +0800,10,54 ,video,3665
     839 113.143.158.241,10/Nov/2016:00:01:41 +0800,10,67 ,video,4299
     840 183.128.139.254,10/Nov/2016:00:01:41 +0800,10,54 ,video,365
     841 115.60.4.28,10/Nov/2016:00:01:41 +0800,10,67 ,video,10198
     842 58.132.202.208,10/Nov/2016:00:01:41 +0800,10,54 ,video,10710
     843 113.143.158.241,10/Nov/2016:00:01:41 +0800,10,6686 ,video,4299
     844 222.65.233.105,10/Nov/2016:00:01:41 +0800,10,67 ,video,1627
     845 122.91.39.170,10/Nov/2016:00:01:41 +0800,10,54 ,video,9366
     846 113.143.158.241,10/Nov/2016:00:01:41 +0800,10,2958 ,video,4311
     847 112.10.127.193,10/Nov/2016:00:01:41 +0800,10,67 ,video,1090
     848 123.124.147.8,10/Nov/2016:00:01:41 +0800,10,54 ,video,5677
     849 120.198.231.151,10/Nov/2016:00:01:41 +0800,10,141 ,video,4242
     850 113.143.158.241,10/Nov/2016:00:01:41 +0800,10,377 ,video,4311
     851 113.67.224.172,10/Nov/2016:00:01:41 +0800,10,54 ,video,818
     852 113.143.158.241,10/Nov/2016:00:01:41 +0800,10,752 ,video,4311
     853 113.143.158.241,10/Nov/2016:00:01:41 +0800,10,66 ,video,4311
     854 113.143.158.241,10/Nov/2016:00:01:41 +0800,10,395 ,video,4311
     855 113.143.158.241,10/Nov/2016:00:01:41 +0800,10,3416 ,video,4311
     856 113.97.199.198,10/Nov/2016:00:01:41 +0800,10,67 ,video,772
     857 113.143.158.241,10/Nov/2016:00:01:41 +0800,10,2345 ,video,4311
     858 111.0.200.141,10/Nov/2016:00:01:41 +0800,10,54 ,video,7558
     859 111.201.78.80,10/Nov/2016:00:01:41 +0800,10,67 ,video,2452
     860 113.143.158.241,10/Nov/2016:00:01:41 +0800,10,332 ,video,4311
     861 27.38.60.148,10/Nov/2016:00:01:41 +0800,10,54 ,video,4650
     862 182.138.128.41,10/Nov/2016:00:01:41 +0800,10,6207 ,video,11239
     863 113.143.158.241,10/Nov/2016:00:01:42 +0800,10,348 ,video,4311
     864 58.217.142.142,10/Nov/2016:00:01:42 +0800,10,72 ,video,6045
     865 58.217.142.142,10/Nov/2016:00:01:42 +0800,10,66 ,video,6045
     866 202.119.41.28,10/Nov/2016:00:01:42 +0800,10,67 ,video,2801
     867 60.12.51.243,10/Nov/2016:00:01:42 +0800,10,54 ,video,6565
     868 58.213.112.35,10/Nov/2016:00:01:42 +0800,10,54 ,video,5656
     869 124.239.251.50,10/Nov/2016:00:01:42 +0800,10,67 ,video,2544
     870 71.17.103.212,10/Nov/2016:00:01:42 +0800,10,2959 ,video,7076
     871 113.14.0.15,10/Nov/2016:00:01:42 +0800,10,54 ,video,10811
     872 27.38.115.174,10/Nov/2016:00:01:42 +0800,10,67 ,video,5986
     873 120.236.154.86,10/Nov/2016:00:01:42 +0800,10,54 ,video,3653
     874 58.217.142.142,10/Nov/2016:00:01:42 +0800,10,1953 ,video,6045
     875 116.232.174.6,10/Nov/2016:00:01:42 +0800,10,54 ,video,2473
     876 113.143.158.241,10/Nov/2016:00:01:42 +0800,10,6686 ,video,4311
     877 171.217.47.216,10/Nov/2016:00:01:42 +0800,10,0 ,article,1204
     878 202.119.41.28,10/Nov/2016:00:01:42 +0800,10,9013 ,video,2801
     879 58.213.102.242,10/Nov/2016:00:01:42 +0800,10,54 ,video,9584
     880 112.64.60.127,10/Nov/2016:00:01:42 +0800,10,54 ,video,9819
     881 58.217.142.142,10/Nov/2016:00:01:42 +0800,10,3750 ,video,6045
     882 113.143.158.241,10/Nov/2016:00:01:42 +0800,10,1296 ,video,4311
     883 58.217.142.142,10/Nov/2016:00:01:42 +0800,10,179 ,video,6045
     884 218.26.154.77,10/Nov/2016:00:01:42 +0800,10,54 ,video,1628
     885 114.214.182.197,10/Nov/2016:00:01:42 +0800,10,67 ,video,1092
     886 171.217.47.216,10/Nov/2016:00:01:42 +0800,10,2023 ,article,1204
     887 113.143.158.241,10/Nov/2016:00:01:42 +0800,10,72 ,video,4311
     888 125.85.67.44,10/Nov/2016:00:01:42 +0800,10,54 ,video,5224
     889 58.217.142.142,10/Nov/2016:00:01:42 +0800,10,2353 ,video,6045
     890 58.61.235.7,10/Nov/2016:00:01:42 +0800,10,54 ,video,10421
     891 58.217.142.142,10/Nov/2016:00:01:42 +0800,10,634 ,video,6045
     892 113.143.158.241,10/Nov/2016:00:01:42 +0800,10,377 ,video,4311
     893 202.119.41.28,10/Nov/2016:00:01:42 +0800,10,2956 ,video,2801
     894 118.198.203.49,10/Nov/2016:00:01:42 +0800,10,54 ,video,1478
     895 61.142.10.231,10/Nov/2016:00:01:42 +0800,10,67 ,video,12483
     896 14.156.71.170,10/Nov/2016:00:01:42 +0800,10,54 ,video,9906
     897 117.23.82.56,10/Nov/2016:00:01:43 +0800,10,54 ,video,6845
     898 113.143.158.241,10/Nov/2016:00:01:43 +0800,10,72 ,video,4311
     899 140.205.253.137,10/Nov/2016:00:01:43 +0800,10,524288 ,video,4029
     900 60.186.39.35,10/Nov/2016:00:01:43 +0800,10,67 ,video,7704
     901 116.31.61.97,10/Nov/2016:00:01:43 +0800,10,67 ,video,4596
     902 113.143.158.241,10/Nov/2016:00:01:43 +0800,10,4091 ,video,4311
     903 222.209.9.194,10/Nov/2016:00:01:43 +0800,10,54 ,video,12535
     904 202.119.41.28,10/Nov/2016:00:01:43 +0800,10,360 ,video,2801
     905 163.125.235.161,10/Nov/2016:00:01:43 +0800,10,67 ,video,11639
     906 119.131.143.179,10/Nov/2016:00:01:43 +0800,10,67 ,video,2402
     907 202.119.41.28,10/Nov/2016:00:01:43 +0800,10,1422 ,video,2801
     908 71.17.103.212,10/Nov/2016:00:01:43 +0800,10,66 ,video,7076
     909 202.119.41.28,10/Nov/2016:00:01:43 +0800,10,66 ,video,2801
     910 119.131.143.179,10/Nov/2016:00:01:43 +0800,10,12233 ,video,2402
     911 60.186.194.249,10/Nov/2016:00:01:43 +0800,10,67 ,video,8643
     912 202.119.41.28,10/Nov/2016:00:01:43 +0800,10,89 ,video,2801
     913 117.100.231.8,10/Nov/2016:00:01:43 +0800,10,72 ,video,4018
     914 59.172.246.60,10/Nov/2016:00:01:43 +0800,10,54 ,video,9820
     915 58.217.142.142,10/Nov/2016:00:01:43 +0800,10,0 ,video,6045
     916 58.217.142.142,10/Nov/2016:00:01:43 +0800,10,0 ,video,6045
     917 60.176.120.135,10/Nov/2016:00:01:43 +0800,10,54 ,video,816
     918 60.12.51.243,10/Nov/2016:00:01:43 +0800,10,67 ,video,6565
     919 103.204.172.213,10/Nov/2016:00:01:43 +0800,10,54 ,video,7831
     920 71.17.103.212,10/Nov/2016:00:01:43 +0800,10,516 ,video,7076
     921 140.205.253.145,10/Nov/2016:00:01:43 +0800,10,524288 ,video,5609
     922 118.250.42.145,10/Nov/2016:00:01:43 +0800,10,54 ,video,11307
     923 180.102.237.112,10/Nov/2016:00:01:43 +0800,10,54 ,video,702
     924 58.217.142.142,10/Nov/2016:00:01:43 +0800,10,2956 ,video,6042
     925 210.12.14.35,10/Nov/2016:00:01:44 +0800,10,67 ,video,8599
     926 27.223.6.43,10/Nov/2016:00:01:44 +0800,10,54 ,video,3723
     927 58.217.142.142,10/Nov/2016:00:01:44 +0800,10,313 ,video,6042
     928 58.217.142.142,10/Nov/2016:00:01:44 +0800,10,179 ,video,6042
     929 120.52.92.5,10/Nov/2016:00:01:44 +0800,10,54 ,video,5118
     930 131.107.0.115,10/Nov/2016:00:01:44 +0800,10,54 ,video,3179
     931 117.100.231.8,10/Nov/2016:00:01:44 +0800,10,7269 ,video,4018
     932 58.217.142.142,10/Nov/2016:00:01:44 +0800,10,66 ,video,6042
     933 58.250.198.10,10/Nov/2016:00:01:44 +0800,10,67 ,video,6713
     934 210.30.100.2,10/Nov/2016:00:01:44 +0800,10,68 ,video,7965
     935 27.36.220.125,10/Nov/2016:00:01:44 +0800,10,54 ,video,6346
     936 58.62.203.255,10/Nov/2016:00:01:44 +0800,10,54 ,video,6695
     937 27.38.183.139,10/Nov/2016:00:01:44 +0800,10,54 ,video,5210
     938 39.174.34.217,10/Nov/2016:00:01:44 +0800,10,54 ,video,9882
     939 113.87.161.137,10/Nov/2016:00:01:44 +0800,10,67 ,video,8006
     940 59.47.8.86,10/Nov/2016:00:01:44 +0800,10,54 ,video,7599
     941 58.217.142.142,10/Nov/2016:00:01:44 +0800,10,2041 ,video,6042
     942 14.219.128.52,10/Nov/2016:00:01:44 +0800,10,66 ,video,3850
     943 101.95.9.246,10/Nov/2016:00:01:44 +0800,10,54 ,video,11225
     944 123.157.208.18,10/Nov/2016:00:01:44 +0800,10,54 ,video,7727
     945 59.175.227.254,10/Nov/2016:00:01:44 +0800,10,54 ,video,8601
     946 202.119.41.28,10/Nov/2016:00:01:44 +0800,10,1081 ,video,2801
     947 120.198.231.150,10/Nov/2016:00:01:44 +0800,10,54 ,video,2671
     948 14.219.128.52,10/Nov/2016:00:01:44 +0800,10,366 ,video,3850
     949 110.65.101.188,10/Nov/2016:00:01:44 +0800,10,67 ,video,2225
     950 14.151.213.221,10/Nov/2016:00:01:44 +0800,10,67 ,video,9817
     951 202.119.41.28,10/Nov/2016:00:01:44 +0800,10,360 ,video,2801
     952 211.80.84.252,10/Nov/2016:00:01:44 +0800,10,54 ,video,11091
     953 14.219.128.52,10/Nov/2016:00:01:44 +0800,10,395 ,video,3850
     954 222.73.203.30,10/Nov/2016:00:01:44 +0800,10,54 ,video,11176
     955 58.217.142.142,10/Nov/2016:00:01:44 +0800,10,2353 ,video,6042
     956 101.39.103.224,10/Nov/2016:00:01:44 +0800,10,72 ,video,1412
     957 71.17.103.212,10/Nov/2016:00:01:44 +0800,10,6260 ,video,7076
     958 183.240.25.11,10/Nov/2016:00:01:45 +0800,10,54 ,video,4472
     959 218.83.152.2,10/Nov/2016:00:01:45 +0800,10,54 ,video,7226
     960 180.157.62.124,10/Nov/2016:00:01:45 +0800,10,54 ,video,8692
     961 14.219.128.52,10/Nov/2016:00:01:45 +0800,10,4221 ,video,3850
     962 125.33.135.73,10/Nov/2016:00:01:45 +0800,10,54 ,video,3075
     963 14.219.128.52,10/Nov/2016:00:01:45 +0800,10,448 ,video,3850
     964 122.206.190.75,10/Nov/2016:00:01:45 +0800,10,2443 ,video,7707
     965 58.217.142.142,10/Nov/2016:00:01:45 +0800,10,1539 ,video,6042
     966 58.217.142.142,10/Nov/2016:00:01:45 +0800,10,0 ,video,6042
     967 58.217.142.142,10/Nov/2016:00:01:45 +0800,10,0 ,video,6042
     968 58.217.142.142,10/Nov/2016:00:01:45 +0800,10,0 ,video,6042
     969 14.219.128.52,10/Nov/2016:00:01:45 +0800,10,366 ,video,3850
     970 59.42.128.119,10/Nov/2016:00:01:45 +0800,10,67 ,video,5289
     971 123.157.217.162,10/Nov/2016:00:01:45 +0800,10,54 ,video,1445
     972 120.34.233.118,10/Nov/2016:00:01:45 +0800,10,54 ,video,3521
     973 125.119.38.58,10/Nov/2016:00:01:45 +0800,10,141 ,video,12560
     974 113.66.157.53,10/Nov/2016:00:01:45 +0800,10,67 ,video,7501
     975 98.25.241.43,10/Nov/2016:00:01:45 +0800,10,67 ,video,2360
     976 183.58.250.1,10/Nov/2016:00:01:45 +0800,10,54 ,video,4359
     977 129.10.9.110,10/Nov/2016:00:01:45 +0800,10,141 ,video,1708
     978 210.41.96.62,10/Nov/2016:00:01:45 +0800,10,67 ,video,3354
     979 14.219.128.52,10/Nov/2016:00:01:45 +0800,10,2345 ,video,3850
     980 120.198.231.151,10/Nov/2016:00:01:45 +0800,10,5823 ,video,4242
     981 119.80.170.215,10/Nov/2016:00:01:45 +0800,10,54 ,video,10506
     982 120.198.231.152,10/Nov/2016:00:01:45 +0800,10,54 ,video,12495
     983 222.65.107.24,10/Nov/2016:00:01:45 +0800,10,67 ,video,7648
     984 117.191.16.103,10/Nov/2016:00:01:45 +0800,10,54 ,video,12677
     985 14.219.128.52,10/Nov/2016:00:01:45 +0800,10,2519 ,video,3850
     986 116.231.133.23,10/Nov/2016:00:01:45 +0800,10,54 ,video,8940
     987 125.47.60.164,10/Nov/2016:00:01:45 +0800,10,54 ,video,3521
     988 115.193.172.253,10/Nov/2016:00:01:46 +0800,10,72 ,video,3078
     989 183.45.120.249,10/Nov/2016:00:01:46 +0800,10,54 ,video,3521
     990 114.250.95.200,10/Nov/2016:00:01:46 +0800,10,54 ,video,9973
     991 114.248.224.214,10/Nov/2016:00:01:46 +0800,10,6690 ,video,1309
     992 221.217.59.20,10/Nov/2016:00:01:46 +0800,10,54 ,video,5647
     993 218.85.36.129,10/Nov/2016:00:01:46 +0800,10,54 ,video,12471
     994 101.200.101.31,10/Nov/2016:00:01:46 +0800,10,524288 ,video,8175
     995 111.85.126.197,10/Nov/2016:00:01:46 +0800,10,54 ,video,4443
     996 60.186.194.249,10/Nov/2016:00:01:46 +0800,10,54 ,video,8601
     997 171.8.148.158,10/Nov/2016:00:01:46 +0800,10,67 ,video,8292
     998 183.45.120.249,10/Nov/2016:00:01:46 +0800,10,67 ,video,13108
     999 120.198.231.150,10/Nov/2016:00:01:46 +0800,10,54 ,video,7227
    1000 202.119.41.28,10/Nov/2016:00:01:46 +0800,10,4992 ,video,2801
    1001 114.242.249.126,10/Nov/2016:00:01:46 +0800,10,54 ,video,11950
    1002 117.151.58.220,10/Nov/2016:00:01:46 +0800,10,54 ,video,1805
    1003 175.9.181.84,10/Nov/2016:00:01:46 +0800,10,54 ,video,9821
    1004 14.219.128.52,10/Nov/2016:00:01:46 +0800,10,6696 ,video,3850
    1005 202.119.41.28,10/Nov/2016:00:01:46 +0800,10,2635 ,video,2801
    1006 101.30.71.71,10/Nov/2016:00:01:46 +0800,10,54 ,video,8541
    1007 120.198.231.151,10/Nov/2016:00:01:46 +0800,10,339 ,video,4246
    1008 202.119.41.28,10/Nov/2016:00:01:46 +0800,10,2910 ,video,2801
    1009 125.71.99.165,10/Nov/2016:00:01:46 +0800,10,54 ,video,2524
    1010 14.219.128.52,10/Nov/2016:00:01:46 +0800,10,72 ,video,3850
    1011 1.30.162.63,10/Nov/2016:00:01:46 +0800,10,54 ,video,3639
    1012 202.119.41.28,10/Nov/2016:00:01:46 +0800,10,348 ,video,2801
    1013 61.154.14.45,10/Nov/2016:00:01:46 +0800,10,54 ,video,11704
    1014 183.12.65.111,10/Nov/2016:00:01:47 +0800,10,54 ,video,2803
    1015 221.233.125.242,10/Nov/2016:00:01:47 +0800,10,54 ,video,2949
    1016 223.93.140.242,10/Nov/2016:00:01:47 +0800,10,54 ,video,9277
    1017 117.152.72.30,10/Nov/2016:00:01:47 +0800,10,54 ,video,8743
    1018 119.131.143.179,10/Nov/2016:00:01:47 +0800,10,1422 ,video,2402
    1019 113.120.48.150,10/Nov/2016:00:01:47 +0800,10,54 ,video,5868
    1020 120.198.231.151,10/Nov/2016:00:01:47 +0800,10,66 ,video,4246
    1021 202.119.41.28,10/Nov/2016:00:01:47 +0800,10,4547 ,video,2801
    1022 119.131.143.179,10/Nov/2016:00:01:47 +0800,10,2959 ,video,2402
    1023 39.186.247.142,10/Nov/2016:00:01:47 +0800,10,54 ,video,2168
    1024 112.64.60.228,10/Nov/2016:00:01:47 +0800,10,67 ,video,5995
    1025 202.119.41.28,10/Nov/2016:00:01:47 +0800,10,4253 ,video,2801
    1026 218.18.222.206,10/Nov/2016:00:01:47 +0800,10,54 ,video,481
    1027 120.39.8.104,10/Nov/2016:00:01:47 +0800,10,54 ,video,6688
    1028 119.131.143.179,10/Nov/2016:00:01:47 +0800,10,17700 ,video,2402
    1029 119.39.67.214,10/Nov/2016:00:01:47 +0800,10,54 ,video,1459
    1030 120.198.231.151,10/Nov/2016:00:01:47 +0800,10,312 ,video,4246
    1031 120.198.231.152,10/Nov/2016:00:01:47 +0800,10,67 ,video,11671
    1032 218.29.60.105,10/Nov/2016:00:01:47 +0800,10,54 ,video,12485
    1033 221.11.20.109,10/Nov/2016:00:01:47 +0800,10,54 ,video,5475
    1034 119.131.143.179,10/Nov/2016:00:01:47 +0800,10,72 ,video,2402
    1035 113.87.161.137,10/Nov/2016:00:01:47 +0800,10,6361 ,video,8006
    1036 202.119.41.28,10/Nov/2016:00:01:47 +0800,10,9013 ,video,2801
    1037 125.71.163.15,10/Nov/2016:00:01:47 +0800,10,54 ,video,12898
    1038 202.119.41.28,10/Nov/2016:00:01:47 +0800,10,72 ,video,2801
    1039 114.242.167.68,10/Nov/2016:00:01:47 +0800,10,54 ,video,4451
    1040 120.236.154.145,10/Nov/2016:00:01:48 +0800,10,54 ,video,8990
    1041 119.131.143.179,10/Nov/2016:00:01:48 +0800,10,66 ,video,2402
    1042 171.34.223.30,10/Nov/2016:00:01:48 +0800,10,54 ,video,3663
    1043 119.131.143.179,10/Nov/2016:00:01:48 +0800,10,390 ,video,2402
    1044 219.82.237.114,10/Nov/2016:00:01:48 +0800,10,54 ,video,1501
    1045 120.198.231.151,10/Nov/2016:00:01:48 +0800,10,72 ,video,4246
    1046 171.113.106.131,10/Nov/2016:00:01:48 +0800,10,54 ,video,12136
    1047 14.219.128.52,10/Nov/2016:00:01:48 +0800,10,6696 ,video,3850
    1048 119.131.143.179,10/Nov/2016:00:01:48 +0800,10,1081 ,video,2402
    1049 119.131.143.179,10/Nov/2016:00:01:48 +0800,10,4373 ,video,2402
    1050 221.226.97.31,10/Nov/2016:00:01:48 +0800,10,54 ,video,4980
    1051 14.120.160.170,10/Nov/2016:00:01:48 +0800,10,54 ,video,6407
    1052 223.72.105.208,10/Nov/2016:00:01:48 +0800,10,54 ,video,5646
    1053 173.254.225.7,10/Nov/2016:00:01:48 +0800,10,5 ,video,12814
    1054 222.216.31.41,10/Nov/2016:00:01:48 +0800,10,54 ,video,1706
    1055 101.229.244.33,10/Nov/2016:00:01:48 +0800,10,353 ,video,2030
    1056 112.10.158.199,10/Nov/2016:00:01:48 +0800,10,54 ,video,7647
    1057 115.156.237.9,10/Nov/2016:00:01:48 +0800,10,67 ,video,10966
    1058 125.119.38.58,10/Nov/2016:00:01:49 +0800,10,67 ,video,12560
    1059 125.90.49.233,10/Nov/2016:00:01:49 +0800,10,54 ,video,7714
    1060 106.185.43.251,10/Nov/2016:00:01:49 +0800,10,72 ,video,11950
    1061 180.155.124.103,10/Nov/2016:00:01:49 +0800,10,67 ,video,4710
    1062 61.51.249.58,10/Nov/2016:00:01:49 +0800,10,54 ,video,1627
    1063 183.240.27.98,10/Nov/2016:00:01:49 +0800,10,66 ,video,2779
    1064 119.131.143.179,10/Nov/2016:00:01:49 +0800,10,354 ,video,2402
    1065 101.229.244.33,10/Nov/2016:00:01:49 +0800,10,1246 ,video,2030
    1066 180.155.124.103,10/Nov/2016:00:01:49 +0800,10,67 ,video,5984
    1067 101.69.240.6,10/Nov/2016:00:01:49 +0800,10,54 ,video,4441
    1068 58.249.67.242,10/Nov/2016:00:01:49 +0800,10,67 ,video,11018
    1069 27.18.106.137,10/Nov/2016:00:01:49 +0800,10,54 ,video,6710
    1070 101.229.244.33,10/Nov/2016:00:01:49 +0800,10,72 ,video,2030
    1071 125.119.38.58,10/Nov/2016:00:01:49 +0800,10,6152 ,video,12560
    1072 111.201.154.45,10/Nov/2016:00:01:49 +0800,10,54 ,video,11614
    1073 119.131.143.179,10/Nov/2016:00:01:49 +0800,10,354 ,video,2402
    1074 123.82.184.10,10/Nov/2016:00:01:49 +0800,10,54 ,video,4417
    1075 175.25.164.134,10/Nov/2016:00:01:49 +0800,10,54 ,video,8086
    1076 117.151.45.16,10/Nov/2016:00:01:49 +0800,10,54 ,video,7423
    1077 125.119.38.58,10/Nov/2016:00:01:49 +0800,10,2958 ,video,12552
    1078 101.229.244.33,10/Nov/2016:00:01:49 +0800,10,2700 ,video,2030
    1079 120.41.120.245,10/Nov/2016:00:01:49 +0800,10,141 ,video,5984
    1080 113.140.11.120,10/Nov/2016:00:01:49 +0800,10,54 ,video,1448
    1081 120.236.174.170,10/Nov/2016:00:01:49 +0800,10,54 ,video,2007
    1082 101.229.244.33,10/Nov/2016:00:01:49 +0800,10,4285 ,video,2030
    1083 101.229.244.33,10/Nov/2016:00:01:49 +0800,10,137 ,video,2030
    1084 173.254.225.7,10/Nov/2016:00:01:49 +0800,10,1774 ,video,12814
    1085 218.30.109.26,10/Nov/2016:00:01:49 +0800,10,54 ,video,5940
    1086 115.236.164.58,10/Nov/2016:00:01:49 +0800,10,54 ,video,1803
    1087 182.119.231.213,10/Nov/2016:00:01:49 +0800,10,54 ,video,4187
    1088 114.255.40.55,10/Nov/2016:00:01:49 +0800,10,54 ,video,5537
    1089 59.40.133.15,10/Nov/2016:00:01:49 +0800,10,67 ,video,7846
    1090 183.157.31.247,10/Nov/2016:00:01:49 +0800,10,329 ,video,12552
    1091 222.44.80.121,10/Nov/2016:00:01:49 +0800,10,54 ,video,492
    1092 183.240.27.98,10/Nov/2016:00:01:49 +0800,10,72 ,video,2779
    1093 122.70.48.217,10/Nov/2016:00:01:49 +0800,10,54 ,video,12499
    1094 115.60.58.190,10/Nov/2016:00:01:49 +0800,10,54 ,video,2496
    1095 183.157.31.247,10/Nov/2016:00:01:49 +0800,10,74 ,video,12552
    1096 101.229.244.33,10/Nov/2016:00:01:49 +0800,10,353 ,video,2030
    1097 123.182.240.4,10/Nov/2016:00:01:50 +0800,10,141 ,video,6553
    1098 14.219.128.52,10/Nov/2016:00:01:50 +0800,10,54 ,video,3850
    1099 111.198.26.195,10/Nov/2016:00:01:50 +0800,10,54 ,video,4187
    1100 120.198.231.154,10/Nov/2016:00:01:50 +0800,10,67 ,video,456
    1101 183.240.27.98,10/Nov/2016:00:01:50 +0800,10,1188 ,video,2779
    1102 119.131.153.247,10/Nov/2016:00:01:50 +0800,10,54 ,video,1948
    1103 42.236.157.243,10/Nov/2016:00:01:50 +0800,10,141 ,video,10694
    1104 59.63.249.142,10/Nov/2016:00:01:50 +0800,10,54 ,video,7254
    1105 120.52.92.2,10/Nov/2016:00:01:50 +0800,10,67 ,video,13171
    1106 218.17.157.250,10/Nov/2016:00:01:50 +0800,10,54 ,video,11201
    1107 116.77.239.141,10/Nov/2016:00:01:50 +0800,10,2957 ,video,6541
    1108 59.46.24.56,10/Nov/2016:00:01:50 +0800,10,54 ,video,5639
    1109 119.131.143.179,10/Nov/2016:00:01:50 +0800,10,2635 ,video,2402
    1110 124.205.5.242,10/Nov/2016:00:01:50 +0800,10,54 ,video,2170
    1111 101.229.244.33,10/Nov/2016:00:01:50 +0800,10,1891 ,video,2030
    1112 125.119.38.58,10/Nov/2016:00:01:50 +0800,10,621 ,video,12552
    1113 218.244.198.7,10/Nov/2016:00:01:50 +0800,10,54 ,video,1803
    1114 116.77.239.141,10/Nov/2016:00:01:50 +0800,10,322 ,video,6541
    1115 101.229.244.33,10/Nov/2016:00:01:50 +0800,10,4285 ,video,2030
    1116 119.101.92.177,10/Nov/2016:00:01:50 +0800,10,54 ,video,1430
    1117 124.193.169.82,10/Nov/2016:00:01:50 +0800,10,54 ,video,12051
    1118 112.10.127.193,10/Nov/2016:00:01:50 +0800,10,54 ,video,9819
    1119 183.11.223.82,10/Nov/2016:00:01:50 +0800,10,54 ,video,10652
    1120 125.119.38.58,10/Nov/2016:00:01:50 +0800,10,141 ,video,12552
    1121 183.157.31.247,10/Nov/2016:00:01:50 +0800,10,3705 ,video,12552
    1122 119.131.143.179,10/Nov/2016:00:01:50 +0800,10,4465 ,video,2402
    1123 114.248.224.214,10/Nov/2016:00:01:50 +0800,10,54 ,video,1309
    1124 125.119.38.58,10/Nov/2016:00:01:50 +0800,10,3705 ,video,12552
    1125 115.216.30.106,10/Nov/2016:00:01:50 +0800,10,54 ,video,9136
    1126 47.88.213.206,10/Nov/2016:00:01:50 +0800,10,54 ,video,5553
    1127 183.240.27.98,10/Nov/2016:00:01:50 +0800,10,2345 ,video,2779
    1128 101.229.244.33,10/Nov/2016:00:01:50 +0800,10,342 ,video,2030
    1129 101.229.244.33,10/Nov/2016:00:01:50 +0800,10,74 ,video,2030
    1130 183.157.31.247,10/Nov/2016:00:01:50 +0800,10,312 ,video,12552
    1131 117.147.54.119,10/Nov/2016:00:01:50 +0800,10,54 ,video,2210
    1132 114.248.224.214,10/Nov/2016:00:01:50 +0800,10,8875 ,video,1309
    1133 124.79.111.37,10/Nov/2016:00:01:50 +0800,10,54 ,video,10834
    1134 116.77.239.141,10/Nov/2016:00:01:50 +0800,10,322 ,video,6541
    1135 125.119.38.58,10/Nov/2016:00:01:50 +0800,10,2472 ,video,12552
    1136 119.131.143.179,10/Nov/2016:00:01:50 +0800,10,327 ,video,2402
    1137 116.77.239.141,10/Nov/2016:00:01:50 +0800,10,66 ,video,6541
    1138 117.147.54.119,10/Nov/2016:00:01:50 +0800,10,67 ,video,10656
    1139 58.100.180.246,10/Nov/2016:00:01:50 +0800,10,54 ,video,3628
    1140 123.14.16.49,10/Nov/2016:00:01:50 +0800,10,54 ,video,3296
    1141 115.231.149.114,10/Nov/2016:00:01:50 +0800,10,54 ,video,11330
    1142 125.119.38.58,10/Nov/2016:00:01:51 +0800,10,72 ,video,12552
    1143 101.229.244.33,10/Nov/2016:00:01:51 +0800,10,6382 ,video,2030
    1144 183.240.27.98,10/Nov/2016:00:01:51 +0800,10,7753 ,video,2779
    1145 222.79.80.123,10/Nov/2016:00:01:51 +0800,10,67 ,video,2032
    1146 124.207.69.26,10/Nov/2016:00:01:51 +0800,10,54 ,video,2138
    1147 183.17.238.190,10/Nov/2016:00:01:51 +0800,10,54 ,video,9885
    1148 58.135.115.122,10/Nov/2016:00:01:51 +0800,10,54 ,video,394
    1149 183.240.27.98,10/Nov/2016:00:01:51 +0800,10,4519 ,video,2779
    1150 219.143.13.59,10/Nov/2016:00:01:51 +0800,10,54 ,video,3474
    1151 101.229.244.33,10/Nov/2016:00:01:51 +0800,10,72 ,video,2030
    1152 122.224.99.166,10/Nov/2016:00:01:51 +0800,10,54 ,video,7857
    1153 183.128.164.83,10/Nov/2016:00:01:51 +0800,10,54 ,video,10802
    1154 140.205.253.147,10/Nov/2016:00:01:51 +0800,10,524288 ,video,2030
    1155 125.119.38.58,10/Nov/2016:00:01:51 +0800,10,6152 ,video,12552
    1156 183.240.27.98,10/Nov/2016:00:01:51 +0800,10,361 ,video,2779
    1157 59.42.206.250,10/Nov/2016:00:01:51 +0800,10,67 ,video,12466
    1158 180.167.7.200,10/Nov/2016:00:01:51 +0800,10,54 ,video,3479
    1159 218.28.137.3,10/Nov/2016:00:01:51 +0800,10,54 ,video,4018
    1160 120.198.231.152,10/Nov/2016:00:01:51 +0800,10,67 ,video,7475
    1161 125.119.38.58,10/Nov/2016:00:01:51 +0800,10,72 ,video,12552
    1162 101.229.244.33,10/Nov/2016:00:01:51 +0800,10,6382 ,video,2030
    1163 119.131.143.179,10/Nov/2016:00:01:51 +0800,10,72 ,video,2402
    1164 110.17.128.214,10/Nov/2016:00:01:51 +0800,10,54 ,video,4443
    1165 125.119.38.58,10/Nov/2016:00:01:51 +0800,10,66 ,video,12552
    1166 45.78.18.110,10/Nov/2016:00:01:51 +0800,10,54 ,video,4451
    1167 202.119.41.28,10/Nov/2016:00:01:51 +0800,10,9013 ,video,2801
    1168 182.100.43.246,10/Nov/2016:00:01:51 +0800,10,67 ,video,8322
    1169 39.184.237.240,10/Nov/2016:00:01:51 +0800,10,66 ,video,10686
    1170 183.240.27.98,10/Nov/2016:00:01:51 +0800,10,2865 ,video,2779
    1171 115.35.190.57,10/Nov/2016:00:01:51 +0800,10,54 ,video,11825
    1172 125.119.38.58,10/Nov/2016:00:01:51 +0800,10,6152 ,video,12552
    1173 101.38.157.182,10/Nov/2016:00:01:51 +0800,10,67 ,video,2163
    1174 116.77.239.141,10/Nov/2016:00:01:51 +0800,10,4882 ,video,6541
    1175 115.174.68.92,10/Nov/2016:00:01:51 +0800,10,67 ,video,9804
    1176 125.119.38.58,10/Nov/2016:00:01:51 +0800,10,329 ,video,12552
    1177 125.81.90.200,10/Nov/2016:00:01:51 +0800,10,54 ,video,8143
    1178 39.184.237.240,10/Nov/2016:00:01:52 +0800,10,72 ,video,10686
    1179 183.240.27.98,10/Nov/2016:00:01:52 +0800,10,7753 ,video,2779
    1180 116.213.171.153,10/Nov/2016:00:01:52 +0800,10,54 ,video,1748
    1181 140.205.253.135,10/Nov/2016:00:01:52 +0800,10,524288 ,video,11724
    1182 58.48.139.85,10/Nov/2016:00:01:52 +0800,10,54 ,video,9088
    1183 183.45.18.241,10/Nov/2016:00:01:52 +0800,10,54 ,video,7726
    1184 112.16.92.55,10/Nov/2016:00:01:52 +0800,10,54 ,video,3661
    1185 125.119.38.58,10/Nov/2016:00:01:52 +0800,10,2195 ,video,12552
    1186 116.77.239.141,10/Nov/2016:00:01:52 +0800,10,72 ,video,6541
    1187 222.35.76.74,10/Nov/2016:00:01:52 +0800,10,54 ,video,2938
    1188 59.33.240.171,10/Nov/2016:00:01:52 +0800,10,54 ,video,10290
    1189 140.205.253.135,10/Nov/2016:00:01:52 +0800,10,524288 ,video,11724
    1190 125.122.26.81,10/Nov/2016:00:01:52 +0800,10,141 ,video,3225
    1191 39.184.237.240,10/Nov/2016:00:01:52 +0800,10,2411 ,video,10686
    1192 116.77.239.141,10/Nov/2016:00:01:52 +0800,10,54 ,video,6541
    1193 45.115.145.36,10/Nov/2016:00:01:52 +0800,10,54 ,video,3474
    1194 59.111.99.119,10/Nov/2016:00:01:52 +0800,10,54 ,video,1625
    1195 120.52.94.109,10/Nov/2016:00:01:52 +0800,10,54 ,video,4588
    1196 39.184.237.240,10/Nov/2016:00:01:52 +0800,10,312 ,video,10686
    1197 122.224.33.106,10/Nov/2016:00:01:52 +0800,10,54 ,video,1090
    1198 183.60.162.112,10/Nov/2016:00:01:52 +0800,10,6127 ,video,12353
    1199 183.60.162.107,10/Nov/2016:00:01:52 +0800,10,54 ,video,7767
    1200 39.184.237.240,10/Nov/2016:00:01:52 +0800,10,361 ,video,10686
    1201 42.234.105.133,10/Nov/2016:00:01:52 +0800,10,54 ,video,2860
    1202 39.184.237.240,10/Nov/2016:00:01:52 +0800,10,2353 ,video,10686
    1203 60.22.87.125,10/Nov/2016:00:01:52 +0800,10,54 ,video,1336
    1204 101.200.101.21,10/Nov/2016:00:01:53 +0800,10,524288 ,video,10506
    1205 58.248.197.207,10/Nov/2016:00:01:53 +0800,10,67 ,video,7063
    1206 171.217.174.22,10/Nov/2016:00:01:53 +0800,10,54 ,video,4215
    1207 60.191.78.148,10/Nov/2016:00:01:53 +0800,10,54 ,video,3590
    1208 116.77.239.141,10/Nov/2016:00:01:53 +0800,10,7663 ,video,6541
    1209 119.57.253.66,10/Nov/2016:00:01:53 +0800,10,54 ,video,2752
    1210 39.184.237.240,10/Nov/2016:00:01:53 +0800,10,6685 ,video,10686
    1211 180.160.68.63,10/Nov/2016:00:01:53 +0800,10,141 ,video,2634
    1212 222.178.202.115,10/Nov/2016:00:01:53 +0800,10,54 ,video,3305
    1213 140.207.223.189,10/Nov/2016:00:01:53 +0800,10,67 ,video,13192
    1214 117.181.194.121,10/Nov/2016:00:01:53 +0800,10,54 ,video,2314
    1215 210.30.109.61,10/Nov/2016:00:01:53 +0800,10,67 ,video,5911
    1216 39.184.237.240,10/Nov/2016:00:01:53 +0800,10,3758 ,video,10686
    1217 14.145.74.175,10/Nov/2016:00:01:53 +0800,10,54 ,video,678
    数据

     关键代码:

    数据清洗:

    AccessLogCleanMapper:

      定义常量,设置时间格式,并设置方法进行时间格式转化:

     

       重写map方法,将数据分割后,取出,封装发送;

       

    AccessLogCleanReduce:

      接收写出;

    AccessLogWritable:


        在封装类中,需要重写这几个方法,用于序列化和反序列化对于字节的读取以及toString方法的返回格式:

    数据输出(二次排序):

     一次排序的话按照MapReduce的WordCount的排序方式就可以。

    二次排序时,将统计到的数据全部分装到key中进行发送,并且重写CompareTo方法进行降序排序。

    将数据存储到hive:

     利用命令可以从hdfs上将数据按照一定格式进行上传到表中。

    1 create table data(  ip string,  time string , day string, traffic bigint,type string, id   string )row format delimited fields terminated by ","2 //创建表,处理以逗号隔开的数据
    3 show tables;
    4 
    5 load data inpath  '文件地址' into table data;
    6 //将hdfs上的文件上传到hive中
    7 select * from data;

      最后进行数据的可视化展示,利用echarts就可以。


      说实话,第一次练手做的很是不满意,很多细节的点Git不到。在做的过程中还信心满满,但是越做越满手。本来还想的使用hive仓库进行操作(那样会更简单),但是在连接的过程中,一段操作猛如虎,最后还是不能进行正常的连接,没办法,索性就用二次排序了。但是做完事后还是发现使用TreeMap更加符合这次的要求,接下来会进行代码的优化,还会继续上传到github中的。

      说实在的,还是得把基础打牢啊,所以,对于这次的代码,个人感觉写的很烂,事实就是这样,欠的,迟早是要还的。

      

  • 相关阅读:
    .net core下直接执行SQL语句并生成DataTable
    asp.net core获取HttpContext相关操作
    连接Oracle的几种方式
    数据库(表)的逻辑备份与恢复
    Oracle函数
    Oracle 11g ORA-12514:TNS:监听程序当前无法识别连接描述符中请求的服务
    未在本地计算机上注册"MSDAORA.1"提供程序
    如果在安装32位oracle 客户端组件时的情况下以64位模式运行,将出现问题
    Oracle Client安装与基本配置
    事务
  • 原文地址:https://www.cnblogs.com/yandashan666/p/11853695.html
Copyright © 2020-2023  润新知