销售人员日常销售记录mysql_spark SQL学习（案例-统计每日销售）

需求：统计每日销售额

package wujiadong_sparkSQL

import org.apache.spark.sql.types._

import org.apache.spark.sql.{Row, SQLContext}

import org.apache.spark.{SparkConf, SparkContext}

import org.apache.spark.sql.functions._

/**

* Created by Administrator on 2017/3/6.

*/

object DailySale {

def main(args: Array[String]): Unit = {

val conf = new SparkConf().setAppName("dailysale").setMaster("local")

val sc = new SparkContext(conf)

val sqlContext = new SQLContext(sc)

import sqlContext.implicits._

//模拟数据

val userSalelog = Array(

"2017-02-01,55,1122",

"2017-02-01,23,1133",

"2017-02-01,15,",

"2017-02-02,56,1155",

"2017-02-01,78,1123",

"2017-02-01,113,1144"

)