frankyaorenjie

echo '{"date_hour":"1497232800","event_action":"visit","account_id":"6","campaign_id":"271","path":"/women/","media_type":"image","count":"183","vtt_source":"","style_id":""}' | bq insert ctc_stats.event_action_stats_hourly


bq rm -ft dashboard.dashboard_search_history\$20170303

frankyaorenjie

bq show --format=prettyjson data-platform-163807:samples.wikipedia | jq '.schema.fields' 

frankyaorenjie

WITH params AS
  (SELECT "[vtt_source=visenze_admin&error_page=5&error_limit=100]" as param
  UNION ALL
  SELECT "[__vs_inner=true&vtt_source=visenze_admin]" as param
  UNION ALL
  SELECT "[a=1]" as param)

SELECT
  REGEXP_EXTRACT(param, r"vtt_source=(\w+)")
  AS vtt_source

frankyaorenjie

select tbl as tbl_id, stv_tbl_perm.name as table_name,
col, interleaved_skew, last_reindex
from svv_interleaved_columns, stv_tbl_perm
where svv_interleaved_columns.tbl = stv_tbl_perm.id
and interleaved_skew is not null;

frankyaorenjie

# Python implementation of the MySQL client-server protocol
# http://dev.mysql.com/doc/internals/en/client-server-protocol.html
# Error codes:
# http://dev.mysql.com/doc/refman/5.5/en/error-messages-client.html
from __future__ import print_function
from ._compat import PY2, range_type, text_type, str_type, JYTHON, IRONPYTHON

import errno
from functools import partial
import hashlib

frankyaorenjie

package com.google.code.or.Sample;

import org.apache.log4j.Logger;
import org.apache.zookeeper.CreateMode;
import org.apache.zookeeper.KeeperException;
import org.apache.zookeeper.ZooDefs;
import org.apache.zookeeper.ZooKeeper;

import java.io.IOException;