Advertisement
Guest User

Untitled

a guest
Jul 20th, 2016
99
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.54 KB | None | 0 0
  1. creds <- read_credentials('../data/cred/bi.3bpo.com')
  2. my_db <- src_mysql( host = 'bi.3bpo.com', dbname = 'bu_adv_sem'
  3. , user = creds$user
  4. , password = creds$password)
  5.  
  6. tables_aggr <- list('stats_sklik_aggr', 'stats_etarget_aggr')
  7. tables_list <- lapply(tables_aggr, FUN = tbl, src = my_db)
  8. tables_list_filtered <- lapply(tables_list, FUN = filter, Day >= start_date & Day <= end_date)
  9.  
  10. DT_stats_aggr <- rbindlist(lapply(tables_list, collect))
  11.  
  12. DT_stats_aggr[, Day := as.Date(Day)]
  13.  
  14. disconnect_all_MySQL()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement