mirgation from bq to mysql

132

bq
===
SELECT
  *
FROM
  [data-platform-163807:visearch_stats.access_logs_stats_hourly]
where date_hour >= '2014-01-01 00:00:00' and date_hour < '2015-01-01 00:00:00'

image
====
SELECT
  date,
  app_id,
  image_count
FROM visearch_user_image_count
WHERE date >= '2016-01-01' AND date < '2017-01-01'


SELECT
  date              AS date_hour,
  account_id,
  app_id,
  method            AS api_method,
  vtt_source,
  'fail'              AS status,
  api_count - api_count_success AS count
FROM visearch_stats_per_hour
WHERE date >= '2017-08-24 00:00:00' AND date <= '2017-10-03 00:00:00';

action_click_rank
===

SELECT
  date AS date_hour,
  account_id,
  app_id,
  source_action,
  rank
FROM actions_click_rank_hour
WHERE date >= '2017-08-24 00:00:00' AND date <= '2017-10-03 00:00:00';


qps
=====
SELECT
  date       AS date_hour,
  account_id AS account_id,
  app_id     AS app_id,
  method     AS api_method,
  vtt_source AS vtt_source,
  qps        AS qps
FROM visearch_qps_stats_hourly
where date >= '2017-01-01 00:00:00' AND date < '2017-03-06 00:00:00'