Wei Zhang razhangwei

Open Automator and create Quick Action.
In the middle column, look for Run AppleScript
On the right, choose no input for workflow receives
input

on run {input, parameters}
    set dateString to do shell script "date +'(%m/%d/%y %H:%M %p)'"
    tell application "System Events"
    	keystroke dateString
 end tell

In terminal, run cupsctl WebInterface=yes
In a web browser, open

Table/partition management

drop table: drop table table_name
rename: ALTER TABLE old_table RENAME TO new_table
delete certain partitions: delete from shop_mall_post_attributes where ds <= '2020-06-14';
insert rows: INSERT INTO table_name QUERY

Important Topics

UDFs

First, adjust Key Repeat and Delay Until Repeat in Keyboard setting.
Disable press and hold.

defaults write -g ApplePressAndHoldEnabled -bool false

On PC, Generate ssh key: ssh-keygen -t rsa -b 4096
Add public keys to the server (recommend using ssh-copy-id)

ssh-copy-id -i .ssh/id_rsa user@hostname

Useful udf:

Use Daiquery 'interactive spark' to debug the query first.
HiveInsertOperatorWithSchema does not support CTE in select query; need to put it in preselect
empty map with types: FB_CAST(NULL, 'MAP<INT, ARRAY<DOUBLE>>')
array: FB_ARRAY_APPLY, FB_ARRAY_AGGREGATE, FB_ARRAY_GET, FB_ARRAY_SORT,
FB_PREV
aggregate: FB_COLLECT
sample:

DISTRIBUTE BY

	" vundle initialization
	" avoid modify this section, unless you are very sure of what you are doing

	" no vi-compatible
	set nocompatible
	filetype off " required! for Vundle

	" setting up vundle - the vim plugin bundler
	let icanhazvundle=1
	let vundle_readme=expand('~/.vim/bundle/vundle/README.md')

	'.source.python':

	'import numpy':
	'prefix': 'as np'
	'body': 'import numpy as np'
	'import pandas':
	'prefix': 'as pd'
	'body': 'import pandas as pd'
	'import matplotlib.pylot':
	'prefix': 'as plt'

	# IDs: 1 for stdout, 2 for stderr -2>&1: redirect stderr to stdout; vice versa for 1>&2.
	./some_command 2>&1 \| tee $(date +"%Y%m%d%H%M").log

	PID=xxx
	ps -p $PID -o etime