Skip to content

Instantly share code, notes, and snippets.

@abbr
abbr / gist:4d5367a058bfd1811e44a71117c4e2d1
Created January 15, 2020 23:07
Athena create partitioned parquet table from existing (external) table
CREATE TABLE test_parquet
WITH ( format = 'PARQUET', parquet_compression = 'SNAPPY', external_location = 's3://<bucket>/parquet/test', partitioned_by = ARRAY['office_id'] )
AS
SELECT *
FROM test
@abbr
abbr / client.js
Last active March 17, 2016 06:22 — forked from ardemiranda/client.js
Reproduce error deasync issues https://github.com/abbr/deasync/issues/34
var http = require('http'),
deasync = require('deasync');
console.log("client connect");
var i = 1;
var interval = setInterval(function() {
var postData = JSON.stringify({
'r': Math.random(),
'i': i