wutingjia

手动分区

对于需要定时分区的表，必须先进行一次手动分区。
对于新建的表,在建表语句后添加：

partition by range(partition_key)( #对于基于日期分期 推荐使用 to_days(pdate) to_days函数会将日期类型转化为int值提高效率
  partition p20190301 values less than (to_days('2019-03-02')), # 分区名字 一般习惯以p开头后面接日期
  partition p20190302 values less than (to_days('2019-03-03'),
);

对于已经存在的表创建分区：

endel

export function* generateUserAgent() { 
   let webkitVersion = 10; 
   let chromeVersion = 1000; 
  
   const so = [ 
     'Windows NT 6.1; WOW64', 
     'Windows NT 6.2; Win64; x64', 
     "Windows NT 5.1; Win64; x64",, 
     'Macintosh; Intel Mac OS X 10_12_6', 
     "X11; Linux x86_64", 

atyachin

Update (2022): https://gist.github.com/atyachin/2f7c6054c4cd6945397165a23623987d


Steps for installing the Android Emulator from EC2 console:
-----------------------------------------------------------
sudo apt install default-jdk
wget https://dl.google.com/android/repository/sdk-tools-linux-4333796.zip
unzip sdk-tools-linux-4333796.zip -d android-sdk
sudo mv android-sdk /opt/
export ANDROID_SDK_ROOT=/opt/android-sdk

jan-warchol

# Synchronize history between bash sessions
#
# Make history from other terminals available to the current one. However,
# don't mix all histories together - make sure that *all* commands from the
# current session are on top of its history, so that pressing up arrow will
# give you most recent command from this session, not from any session.
#
# Since history is saved on each prompt, this additionally protects it from
# terminal crashes.

peatiscoding

#!/usr/bin/python

import os
import subprocess
import time
import yaml
import re

user_name = os.environ.get("DOCKERHUB_USER")

jancurn

const puppeteer = require('puppeteer');
const proxyChain = require('proxy-chain');

(async() => {
    const oldProxyUrl = 'http://bob:password123@proxy.example.com:8000';
    const newProxyUrl = await proxyChain.anonymizeProxy(oldProxyUrl);

    // Prints something like "http://127.0.0.1:45678"
    console.log(newProxyUrl);

mcastilho

.PHONY: all tags clean test build install generate image release

REGISTRY_REPO = <..redacted..>

OK_COLOR=\033[32;01m
NO_COLOR=\033[0m
ERROR_COLOR=\033[31;01m
WARN_COLOR=\033[33;01m

# Build Flags

eduardcloud

import boto3
import time
region = 'eu-west-1'
user_data_script  = """#!/bin/bash 
instanceid=$(curl http://169.254.169.254/latest/meta-data/instance-id) 
cd /
mkdir moodledata
mount -t nfs4 -o nfsvers=4.1,rsize=1048576,wsize=1048576,hard,timeo=600,retrans=2 fs-xxxxxxxxxxc.efs.eu-west-1.amazonaws.com:/ moodledata
tar czf mooodledata-backup-$(date +%d-%m-%Y_%H-%M).tar.gz /moodledata
aws s3 mv mooodledata-backup-*.tar.gz s3://xxxxxxxxx/

roylee0704

docker logs nginx 2>&1 | grep "127." 

# ref: http://stackoverflow.com/questions/34724980/finding-a-string-in-docker-logs-of-container

arikfr

with 

time_frame as (
select current_date - 14
),

population as (
  select created_at::date as cohort_date, id as unique_id
  from organizations
  where created_at > (select * from time_frame)