User PhilHibbs

9 votes

1 answer

18k views

How to get the sequence name for a serial column

asked Mar 22, 2017 at 15:22

6 votes

2 answers

3k views

How can I drop an index on all partitions?

asked Apr 27, 2016 at 15:16

4 votes

2 answers

1k views

Does Greenplum support dynamic sql?

asked Sep 17, 2015 at 11:10

3 votes

1 answer

974 views

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

asked Oct 12, 2016 at 12:17

2 votes

1 answer

137 views

Why would a Greenplum procedure not recognize a view change?

asked Nov 29, 2016 at 11:25

2 votes

1 answer

62 views

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

asked Jun 9, 2017 at 13:09

1 vote

0 answers

2k views

Hive query with RANK() in a WHERE clause

asked Dec 6, 2018 at 12:06

1 vote

0 answers

25 views

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

asked Mar 25, 2020 at 12:17

1 vote

0 answers

61 views

Why gather stats on all columns?

asked Apr 18, 2017 at 10:44

1 vote

1 answer

414 views

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

asked May 31, 2017 at 12:02

1 vote

0 answers

47 views

When was a table created? [duplicate]

asked Apr 20, 2016 at 9:23

1 vote

1 answer

119 views

How to retrieve a view column derivation in PostgreSQL or Greenplum

asked Jan 31, 2017 at 17:05

1 vote

1 answer

87 views

What could cause a text comparison to fail?

asked May 25, 2016 at 9:29

1 vote

1 answer

1k views

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

asked Jan 13, 2016 at 21:55

1 vote

1 answer

4k views

Get total size for all Postgres or Greenplum tables including partitions

asked Apr 6, 2016 at 11:30

1 vote

0 answers

90 views

Can I assign an index to an exploded array?

asked May 5, 2020 at 10:18

0 votes

1 answer

6k views

Testing a Hive array for IS NULL says not null

asked Jul 24, 2020 at 12:25

0 votes

1 answer

80 views

Is a partition a relation?

asked Apr 14, 2016 at 17:06

0 votes

1 answer

127 views

Partition elimination and date variables

asked Jun 16, 2016 at 13:00

0 votes

1 answer

1k views

Get partition column for a table in Greenplum

asked Jan 30, 2017 at 15:24

0 votes

1 answer

747 views

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

asked Apr 30, 2020 at 13:52

Stack Exchange Network

21 Questions

How to get the sequence name for a serial column

How can I drop an index on all partitions?

Does Greenplum support dynamic sql?

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

Why would a Greenplum procedure not recognize a view change?

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

Hive query with RANK() in a WHERE clause

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

Why gather stats on all columns?

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

When was a table created? [duplicate]

How to retrieve a view column derivation in PostgreSQL or Greenplum

What could cause a text comparison to fail?

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

Get total size for all Postgres or Greenplum tables including partitions

Can I assign an index to an exploded array?

Testing a Hive array for IS NULL says not null

Is a partition a relation?

Partition elimination and date variables

Get partition column for a table in Greenplum

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