Skip to content

Instantly share code, notes, and snippets.

View heartonbit's full-sized avatar

Minkyu Shim heartonbit

View GitHub Profile
@heartonbit
heartonbit / Bigquery_remove_tables_using_jupyternotebook
Last active April 24, 2018 06:31
[Bigquery] Remove tables using jupyternotebook
for idx in range(3,351):
tablename = "table_{0}".format(idx)
print(tablename)
!bq rm -f -t $tablename
CREATE TEMPORARY FUNCTION do(x float64, y float64)
RETURNS float64
LANGUAGE js AS """
function add(a, b) {
return a + b;
}
return add(x, y)
""";
with data as (
select *
@heartonbit
heartonbit / gist:2575ce02ca730559d2f2c65eb8682231
Created March 20, 2018 02:04
GCC 7 on Ubuntu 14.04 & 16.04
https://gist.github.com/application2000/73fd6f4bf1be6600a2cf9f56315a2d91
sudo apt-get update -y && \
sudo apt-get upgrade -y && \
sudo apt-get dist-upgrade -y && \
sudo apt-get install build-essential software-properties-common -y && \
sudo add-apt-repository ppa:ubuntu-toolchain-r/test -y && \
sudo apt-get update -y && \
sudo apt-get install gcc-7 g++-7 -y && \
sudo update-alternatives --install /usr/bin/gcc gcc /usr/bin/gcc-7 60 --slave /usr/bin/g++ g++ /usr/bin/g++-7 && \