Hive Serialization.ddl to Create Table helper

ddl.py

import sys

for l in sys.stdin:
        l = l.strip()
        name = l[0:l.find("{")]
        cols = [x.strip().split(" ") for x in l[l.find("{")+1:l.find("}")].split(",")]
        print "create table ", name, "(",
        print ",".join(["%s %s" % (b,a) for (a,b) in cols]), ");"
[gopal@cn041-10 comcast]$ 

grep --text serialization.ddl orig_plan.txt | sort | sed "s/ *//" | uniq | python ddl.py