bigquery_ml_0005.sql

CREATE TABLE `kaggle-adfraud.kaggle_talkingdata_adtracking.dataset_test_with_prediction_logreg_0001`
AS
SELECT * FROM ML.PREDICT(MODEL `kaggle-adfraud.kaggle_talkingdata_adtracking.talkingdata_logreg_0001`, 
(SELECT
  click_id,
  CAST(ip AS STRING) as ip,
  CAST(app AS STRING) as app,
  CAST(device AS STRING) as device,
  CAST(os AS STRING) as os,
  CAST(channel AS STRING) as channel,
  CAST(EXTRACT(hour from click_time) AS STRING) as hod,
  CONCAT('app_', CAST(app AS STRING), '_device_', CAST(device AS STRING)) app_x_device,
  CONCAT('os_', CAST(os AS STRING), '_channel_', CAST(channel AS STRING)) os_x_channel,
  click_time                                                   
FROM `kaggle_talkingdata_adtracking.dataset_test`));