Skip to main content
PhilHibbs's user avatar
PhilHibbs's user avatar
PhilHibbs's user avatar
PhilHibbs
  • Member for 8 years, 9 months
  • Last seen more than 1 year ago
9 votes
1 answer
17k views

How to get the sequence name for a serial column

6 votes
2 answers
3k views

How can I drop an index on all partitions?

4 votes
2 answers
1k views

Does Greenplum support dynamic sql?

3 votes
1 answer
869 views

How bad is it to delete from a Greenplum AO table?

2 votes
1 answer
116 views

Why would a Greenplum procedure not recognize a view change?

2 votes
1 answer
62 views

Why do PostgreSQL examples say `+ integer '7'`? [closed]

1 vote
0 answers
2k views

Hive query with RANK() in a WHERE clause

1 vote
0 answers
23 views

Defining external table on JSON with an @ sign in an element

1 vote
0 answers
59 views

Why gather stats on all columns?

1 vote
1 answer
394 views

Can a plpgsql stored procedure monitor for a query and kill it?

1 vote
0 answers
47 views

When was a table created? [duplicate]

1 vote
1 answer
113 views

How to retrieve a view column derivation in PostgreSQL or Greenplum

1 vote
1 answer
74 views

What could cause a text comparison to fail?

1 vote
1 answer
1k views

How can I add multiple partitions to a Greenplum table using dynamic SQL

1 vote
1 answer
4k views

Get total size for all Postgres or Greenplum tables including partitions

1 vote
0 answers
69 views

Can I assign an index to an exploded array?

0 votes
1 answer
6k views

Testing a Hive array for IS NULL says not null

0 votes
1 answer
78 views

Is a partition a relation?

0 votes
1 answer
123 views

Partition elimination and date variables

0 votes
1 answer
1k views

Get partition column for a table in Greenplum

0 votes
1 answer
705 views

Can I MERGE INTO ... INSERT with a column list in Hive?