Damon P. Cortesi dacort

Download the JDBC driver from here: https://docs.aws.amazon.com/athena/latest/ug/connect-with-jdbc.html - I used the JDBC driver with the Athena SDK, AthenaJDBC42-2.0.35.1000.jar.
Start pyspark with the --jars option.

pyspark --jars AthenaJDBC42-2.0.35.1000.jar

Use spark.read.jdbc to connect to Athena. You need to specify either a User/Password in the properties or set the AwsCredentialsProviderClass property.

In The Zone

When you're in the zone, nothing can stop you. Let your coworkers know what tunes you were listening to in the moment.

Overview

There are two modes in life:

(R)ecord - when you want to make a mixtape for somebody
(P)layback - when you want to feel the mood

Athena CTAS Update

An approach for updating partitions in an existing table using CTAS queries.

Overview

With the release of CTAS functionality for Athena, you're now able to create derivative tables in Athena with different data formats or S3 locations.

Sometimes, though, you want to be able to add data to a partition of an existing table. As long as that partition doesn't already exist, you can do this with Athena by using CTAS with a temporary table.

Keybase proof

I hereby claim:

I am dacort on github.
I am dacort (https://keybase.io/dacort) on keybase.
I have a public key whose fingerprint is 0931 E57B 9A91 8338 5B93 201B F594 2FCD 9F8D 1C6D

To claim this, I am signing this object:

	import json
	import sys

	BS = "0123456789abcdefghijklmnopqrstuvwxyz"

	def parse_input():
	input = sys.stdin.read()
	return json.loads(input)

	def to_base(n, b):

	FROM 895885662937.dkr.ecr.us-west-2.amazonaws.com/spark/emr-6.3.0:latest

	### Switch to root for installation
	USER root

	### setup for conda
	RUN yum install -y wget

	### Install Conda into shared location
	RUN wget https://repo.anaconda.com/miniconda/Miniconda3-py39_4.10.3-Linux-x86_64.sh \

	import sys
	import boto3
	from slacker import Slacker
	import ConfigParser

	import csv
	from datetime import datetime

	reload(sys)
	sys.setdefaultencoding('utf8')

	#!/bin/sh
	#
	#
	# Poor man's version. Good 'ol bash and shell commands.

	# Initialize stat counters
	COPIES=0
	FROM_APPS=()
	TO_APPS=()

	package main

	import (
	"code.google.com/p/go.crypto/pbkdf2"
	"crypto/aes"
	"crypto/cipher"
	"crypto/sha1"
	"database/sql"
	"fmt"
	"log"