yujihamaguchi

select pid, starttime, duration,
trim(user_name) as user,
trim (query) as querytxt
from stv_recents
where status = 'Running';

yujihamaguchi

lsof -i -n -P

yujihamaguchi

(defn fizzbuzz [x]
  (condp #(= (mod %2 %1) 0) x
    15 "FizzBuzz"
    3 "Fizz"
    5 "Buzz"
    x))

yujihamaguchi

SELECT
  (SELECT relname FROM pg_class r2 WHERE r2.oid = r1.conrelid) AS table_name
  ,conname AS constraint_name
FROM
  pg_constraint r1

yujihamaguchi

UNLOAD ('SELECT * FROM <table name>')
TO 's3://<bucket name>/<dir name>/'
CREDENTIALS 'aws_access_key_id=<access key>;aws_secret_access_key=<secret key>'
NULL AS 'This is null value'
GZIP;

-- One File
UNLOAD ('SELECT * FROM <table name>')
TO 's3://<bucket name>/<dir name>/'
CREDENTIALS 'aws_access_key_id=<access key>;aws_secret_access_key=<secret key>'

yujihamaguchi

COPY <table name> FROM 's3://<bucket name>/<dir name>/'
credentials 'aws_access_key_id=<access key>;aws_secret_access_key=<secret key>'
NULL AS 'This is null value'
GZIP

COPY <table name> FROM 's3://<bucket name>/<dir name>/<file name>.csv'
credentials 'aws_access_key_id=<access key>;aws_secret_access_key=<secret key>' CSV DATEFORMAT 'YYYYMMDD' TRIMBLANKS

yujihamaguchi

SELECT
  nspname
  ,relname
  ,conname
  ,attnum
  ,attname
  ,conkey
FROM
  pg_constraint r1
  ,pg_namespace r2

yujihamaguchi

--[grep] 標準入力について、文字列パターンに一致する部分を持つ行を出力する。
-- [Usage] grep {pattern(regex)}
import System
import Text.Regex.Posix
main = do cs <- getContents
          args <- getArgs
          putStr $ unlines $ filter (¥str -> contain (head args) str) $ lines cs
contain :: String -> String -> Bool
contain cs cs' = cs' =‾ cs :: Bool

yujihamaguchi

-- Haskell
import System
import Text.ParserCombinators.Parsec
main = do args <- getArgs
          run parens (head args)
run :: Show a => Parser a -> String -> IO()
run p cs = case (parse p "" cs) of
             Left e -> print e
             Right x -> print x
parens :: Parser Int

yujihamaguchi

SELECT
  owner
  ,name
  ,type
  ,referenced_link_name
  ,dependency_type
FROM
  dba_dependencies
WHERE
  referenced_owner = UPPER('&owner')