Skip to main content
PhilHibbs's user avatar
PhilHibbs's user avatar
PhilHibbs's user avatar
PhilHibbs
  • Member for 9 years, 3 months
  • Last seen more than 2 years ago
comment
Hive query with RANK() in a WHERE clause
@Akina A simple MAX() would not return multiple records.
asked
Loading…
awarded
awarded
comment
Greenplum DB changing table column length
pgAdmin will do a dependents report which should list everything.
Loading…
awarded
revised
Loading…
revised
Loading…
comment
Can a plpgsql stored procedure monitor for a query and kill it?
Ah. Not available in Greenplum. I will remove the postgresql tag.
revised
Loading…
revised
Loading…
revised
Loading…
Loading…
answered
Loading…
asked
Loading…
revised
When postgresql sequences get out of sync?
added 135 characters in body
Loading…
answered
Loading…
accepted
comment
How to accomplish local joins between facts and dimensions?
Postgres-XL has "distributed by replication" so every node gets a copy of the data, but I don't think that is a good idea for large tables! The inescapable fact is that you can only distribute the data once, unless you replicate it, and if you are going to replicate it then you should probably make some very careful choices about which columns you replicate by what key, so doing it yourself is the only sensible option.