Skip to content

Instantly share code, notes, and snippets.

View zyluo's full-sized avatar

Sammy Nah zyluo

75 followers · 1 following
View GitHub Profile
@zyluo
zyluo / cdh6-postgresql.sh
Last active October 2, 2018 19:06
CDH6.0.0 Postgresql Database setup script
export PG_PASSWD="USE_UR_PASSWD"
for db_name in scm amon rman hue metastore sentry nav navms oozie; do sudo -u postgres psql -c "CREATE ROLE $db_name LOGIN PASSWORD '$PG_PASSWD';"; sudo -u postgres psql -c "CREATE DATABASE $db_name OWNER $db_name ENCODING 'UTF8';"; done
sudo -u postgres psql -c "SELECT rolname FROM pg_roles;" && sudo -u postgres psql -c "\l"
for db_name in metastore oozie; do sudo -u postgres psql -c "ALTER DATABASE $db_name SET standard_conforming_strings=off;"; done
sudo /opt/cloudera/cm/schema/scm_prepare_database.sh postgresql scm scm $DB_PASSWD
@zyluo
zyluo / python_in_bash.sh
Last active December 7, 2018 21:15
Embedding python in bash script example
#/usr/bin/which sh
set -e
PRE_SOURCEFILE=$(mktemp)
$(which python) - "${0}" "${@}" "--source" "${PRE_SOURCEFILE}" "--prefix" "PRE" <<END
import argparse
import sys
import tempfile
@zyluo
zyluo / test.md
Created May 8, 2019 18:04

Hello World

This is content converted from Markdown!

Here's a JSON sample:

{
  "foo": "bar"
}
@zyluo
zyluo / test.html
Created May 8, 2019 18:05
<html>
<head>
<style>
h1 {
font-family: Calibri;
}
</style>
</head>
<body>
<h1>Hello World!</h1>