PetStoreStatistics.scala

      /**
       * Transform the non-sparksql mappable calendar
       * into a spark sql freindly field.
       */
      val mappableTransactions:RDD[TransactionM] =
        r._5.map(trans =>
          TransactionM(trans.customerId, trans.transactionId, trans.storeId, Map("dayOfWeek"->"Wed"), trans.productId));

      mappableTransactions.registerTempTable("transactionsM");
      val results: SchemaRDD = sql("SELECT * FROM transactionsM")
      return Statistics(results.count());