bskim45

-- Identify how many S3 objects each COPY command loads
SELECT
    query, COUNT(*) num_files,
    ROUND(MAX(wq.total_exec_time/1000000.0),2) execution_secs,
    ROUND(SUM(transfer_size)/(1024.0*1024.0),2) total_mb,
    SUBSTRING(querytxt,1,60) copy_sql
FROM stl_s3client s
JOIN stl_query q USING (query)
JOIN stl_wlm_query wq USING (query)
WHERE s.userid>1 AND http_method = 'GET'

bskim45

#!/bin/bash

if test -n "$GIT_PUSH_OPTION_COUNT"
then
  i=0
  while test "$i" -lt "$GIT_PUSH_OPTION_COUNT"
  do
    eval "value=\$GIT_PUSH_OPTION_$i"
    case "$value" in
    force)

bskim45

Req id:

parse @message '(*) *' as reqId, message
| filter reqId like "c19dd3fc-5f27-11e9-a823-930d231e2ab8"
| sort @timestamp asc
| limit 50

Status code:

bskim45

from pynamodb.models import Model
from pynamodb.attributes import UnicodeAttribute, NumberAttribute


class MyModel(Model):
    class Meta:
        table_name = 'mytable'

    group = UnicodeAttribute(hash_key=True)
    id = NumberAttribute(range_key=True)

bskim45

import java.awt.*;
import java.awt.event.ComponentAdapter;
import java.awt.event.ComponentEvent;
import java.awt.image.BufferedImage;
import java.io.File;
import java.io.IOException;
import java.util.concurrent.*;

import javax.imageio.ImageIO;
import javax.swing.JComponent;

bskim45

{
	"id": "124e573f-bc1b-4d9a-a7ec-c4c17f2095e1",
	"name": "Team",
	"description": "",
	"order": [
		"0fa78cfe-0d72-19c6-3ac7-b299a3e95540",
		"57194727-54b8-caa3-bb58-c78f0cfcb32f",
		"c36dccba-09af-3b85-f3d0-b3bfb925dd59",
		"34bea456-2f76-d5ea-f39a-0305ed2bab4e",
		"4b5a2548-c9ab-73bb-13d5-e35d256a4e19",

bskim45

# In order for gpg to find gpg-agent, gpg-agent must be running, and there must be an env
# variable pointing GPG to the gpg-agent socket. This little script, which must be sourced
# in your shell's init script (ie, .bash_profile, .zshrc, whatever), will either start
# gpg-agent or set up the GPG_AGENT_INFO variable if it's already running.

# Add the following to your shell init to set up gpg-agent automatically for every shell
if [ -f ~/.gnupg/.gpg-agent-info ] && [ -n "$(pgrep gpg-agent)" ]; then
    source ~/.gnupg/.gpg-agent-info
    export GPG_AGENT_INFO
else

bskim45

Keybase proof

I hereby claim:

• I am bskim45 on github.
• I am bskim45 (https://keybase.io/bskim45) on keybase.
• I have a public key whose fingerprint is 5F9B EE3E 8AE2 8666 03D3 DCF9 24F4 8870 6F28 783F

To claim this, I am signing this object:

bskim45

// File: pjson.h - written by Rich Geldreich 2012 - License: Unlicense http://unlicense.org/
#ifndef PURPLE_JSON_H
#define PURPLE_JSON_H

#ifdef WIN32
#pragma once
#endif

#include <string>
#include <vector>

bskim45

Keybase proof

I hereby claim:

• I am bskim45 on github.
• I am bskim45 (https://keybase.io/bskim45) on keybase.
• I have a public key whose fingerprint is 5F9B EE3E 8AE2 8666 03D3 DCF9 24F4 8870 6F28 783F

To claim this, I am signing this object: