Loading Amazon review data into PostgreSQL

py-snippet.py

import json
def parse(path):
  g = open(path, 'r')
  for l in g:
    yield json.dumps(eval(l), allow_nan=False, ensure_ascii=True)

f = open("kcore_5_strict.json", 'w')
for l in parse("kcore_5.json"):
  f.write(l + '\n')

f = open("metadata_strict.json", 'w')
for l in parse("metadata.json"):
  f.write(l + '\n')

s1.sql

create table meta_json (values text);
create table reviews_json (values text);