Skip to content

Instantly share code, notes, and snippets.

View Cistron's full-sized avatar
🤜
*fist-bump*

Michael Baron Cistron

🤜
*fist-bump*
View GitHub Profile
@shotahorii
shotahorii / 20171104_2.md
Last active March 26, 2025 15:19
(un)pivot on Presto

Pivot

Query
SELECT
  uid,
  kv['c1'] AS c1,
  kv['c2'] AS c2,
  kv['c3'] AS c3
FROM (
import json
import os
import webbrowser
from configparser import ConfigParser
from datetime import datetime, timedelta, timezone
from pathlib import Path
import boto3
import dateutil
from botocore import UNSIGNED