Skip to content

Instantly share code, notes, and snippets.

View skghosh-invn's full-sized avatar

Sumit Kumar Ghosh skghosh-invn

  • Invensense
  • San Jose
View GitHub Profile
@skghosh-invn
skghosh-invn / dynamo_json_to_csv.py
Created August 23, 2019 14:27 — forked from eliocapelati/dynamo_json_to_csv.py
Convert a dynamodb result [json] to csv
#!/usr/bin/python3
# -*- coding: UTF-8 -*-
__author__ = "Elio Capelati Jr"
__version__ = "1.0.0"
import csv, json, sys, argparse
from pprint import pprint
#on cluster
thrift /spark/sbin/start-thriftserver.sh --master yarn-client
#ssh tunnel, direct 10000 to unused 8157
ssh -i ~/caserta-1.pem -N -L 8157:ec2-54-221-27-21.compute-1.amazonaws.com:10000 hadoop@ec2-54-221-27-21.compute-1.amazonaws.com
#see this for JDBC config on client http://blogs.aws.amazon.com/bigdata/post/TxT7CJ0E7CRX88/Using-Amazon-EMR-with-SQL-Workbench-and-other-BI-Tools