Remove beeline pagination from a query result

unpaginate.py

import sys

sample="""
+------------------------------------------------------------------+--+
|                          createtab_stmt                          |
+------------------------------------------------------------------+--+
| CREATE TABLE `finance.xx_po_headers`(                            |
|   `po_header_id` bigint,                                         |
|   `requester_name` string,                                       |
+------------------------------------------------------------------+--+
|                          createtab_stmt                          |
+------------------------------------------------------------------+--+
|   `enabled_flag` string,                                         |
+------------------------------------------------------------------+--+
""".split("\n")

def main(args):
	lines = [x.strip() for x in open(args[0])]
	NONE='NONE'
	SEPARATOR1='SEPARATOR1'
	HEADER='HEADER'
	SEPARATOR2='SEPARATOR2'
	ROW='ROW'
	SEPARATOR3='SEPARATOR3'
	
	state=NONE
	
	for l in lines:
		if not(l.strip()):
			continue
		sep = (l.startswith("+-"))
		row = (l.startswith("|"))
		nstate = None
		if (state == NONE and sep):
			nstate = SEPARATOR1
		elif (state == SEPARATOR3 and sep):
			nstate = SEPARATOR1
		elif (state == SEPARATOR3 and row):
			nstate = HEADER
		elif (state == SEPARATOR1 and row):
			nstate = HEADER
		elif (state == HEADER and sep):
			nstate = SEPARATOR2
		elif (state == SEPARATOR2 and row):
			nstate = ROW
		elif (state == ROW and sep):
			nstate = SEPARATOR3
		elif (state == ROW and row):
			nstate = ROW
		if not(nstate):
			print l
		assert nstate != None
		if (nstate == ROW):
			print l[2:-2].rstrip()
			pass
		#print "%s -> %s" % (state, nstate)
		state = nstate

if __name__ == "__main__":
	main(sys.argv[1:])