gistfile1.txt

wuhong@pivotal-2:~$ source ~/Desktop/local/greenplum_path.sh 

wuhong@pivotal-2:~$ ipython
In [1]: from pygresql import pg

In [2]: from gppylib.db import dbconn

In [3]: url = dbconn.DbURL(dbname='postgres')

In [4]: conn = pg.connect(dbname=url.pgdb, host=url.pghost, port=url.pgport, user=url.pguser, passwd=url.pgpass, opt='-c gp_session_role=utility')

In [5]: qry = 'create table xx(i int4) with (appendonly=true, orientation=Parquet, compresstype=None, compresslevel=0, pagesize=1048576, rowgroupsize=8388608, bucketnum=6) DISTRIBUTED RANDOMLY;'

In [6]: conn.query(qry)

In [7]: conn.query(qry)