We have migrated to new Google sites!
Post date: Sep 19, 2014 3:4:49 PM
sachi=# create table sachi3(abc text);
NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'abc' as the Greenplum Database data distribution key for this table.
HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew.
CREATE TABLE
sachi=# select * from pg_stat_last_operation where objid = 'sachi3' ::regclass order by statime;
classid | objid | staactionname | stasysid | stausename | stasubtype | statime
---------+-------+---------------+----------+------------+------------+-------------------------------
1259 | 52386 | CREATE | 10 | gpadmin | TABLE | 2014-09-19 10:54:58.753318-04
(1 row)