myui

/*
 * Hivemall: Hive scalable Machine Learning Library
 *
 * Copyright (C) 2015 Makoto YUI
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *         http://www.apache.org/licenses/LICENSE-2.0

myui

/*
 * Hivemall: Hive scalable Machine Learning Library
 *
 * Copyright (C) 2015 Makoto YUI
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *         http://www.apache.org/licenses/LICENSE-2.0

myui

CREATE TABLE bprmf_model
as
WITH t as (
  select
    bpr_sampling(userid, pos_items, "-sampling_rate 5.0")
      as (userid, pos_item, neg_item)
  from
    ranking_train
)

myui

run: +main

_export:
  td:
    apikey: ${TD_API_KEY}
    database: rossmann
    engine: hive

+main:

myui

run: +main

_export:
  td:
    apikey: ${TD_API_KEY}
    database: rossmann
    engine: hive

+main:
  +prepare:

myui

SELECT 
  id,
  predicted as sales
FROM
  prediction
ORDER BY id ASC;

myui

INSERT OVERWRITE TABLE prediction
SELECT 
  id,
  EXP(predicted)-1 as predicted
FROM(
  SELECT
     id,
     avg(predicted) AS predicted
  FROM(
    SELECT

myui

WITH train_test as (
      select
        1 as train_first, false as output_row,
	rowid, stateholiday, store, promo, dayofweek, schoolholiday, promo2sinceweek, competitionopensinceyear, assortment, promo2sinceyear, competitiondistance, promointerval, promo2, storetype, competitionopensincemonth, year, month, day
      from
        training2
      union all
      select
        2 as train_first, true as output_row,
	rowid, stateholiday, store, promo, dayofweek, schoolholiday, promo2sinceweek, competitionopensinceyear, assortment, promo2sinceyear, competitiondistance, promointerval, promo2, storetype, competitionopensincemonth, year, month, day

myui

INSERT OVERWRITE TABLE testing2
SELECT
  rowid() as rowid,
  t1.id,
  t1.stateholiday, t1.store, t1.promo, t1.dayofweek, t1.date, t1.schoolholiday,
  SUBSTR(t1.date,1,4) as year,
  SUBSTR(t1.date,6,2) as month,
  SUBSTR(t1.date,9,2) as day,
  t2.promo2sinceweek,
  t2.competitionopensinceyear,

myui