spark-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From 宫勐 <shadowinl...@gmail.com>
Subject Re: HIVE SparkSQL
Date Wed, 18 Mar 2015 10:10:16 GMT
Hi:

   I need to count some Game Player Events in the game.
  Such as :   How Many  Players stay in the game scene 1------Save the
Princess from a Dragon
                   Moneys they have paid in the last 5 min
                   How many players pay money for go through this scene
much more esily
                   age distribution of them    gender distribution of them
                   How many players have not login the game for 5 days
after they go through this game scene

T  The log file have been pre-format, can be load into the mysql directly:

     RoleLevelUp|1426251269733|5503232ae4b00f39751f1012|2015-03-14
02:22:46|192.168.1.16|1048630|220|0|2|57|1993|
     RoleLevelUp|1426251269734|5503232ae4b00f39751f1012|2015-03-14
02:22:52|192.168.1.16|1048630|水奈坤|0|0|3|67|1999|
     RoleLevelUp|1426251269735|550329f9e4b00f39751f101d|2015-03-14
02:24:57|192.168.1.137|1048631|z12|0|0|41|0|380|
     RoleLevelUp|1426251269736|5503232ae4b00f39751f1012|2015-03-14
02:39:01|192.168.1.16|1048630|水奈坤|0|0|15|0|2968


       Now mysql can't satisfy the analysis needs, we want to use other
technical to rebuild all static Systems

     Thanks

    Best Regards

    Yours
     Meng

Mime
View raw message