[YSQL] Support for HStore extension from PostgreSQL

yugabyte / yugabyte-db

YugabyteDB - the cloud native distributed SQL database for mission-critical applications.

https://www.yugabyte.com

Other

8.65k stars 1.04k forks source link

[YSQL] Support for HStore extension from PostgreSQL #2774

Open dodilp opened 4 years ago

dodilp commented 4 years ago

Jira Link: DB-2005 Hstore- adds a data type hstore which contains key, value pairs of every single row (generally used as part of the table ddl). Query execution is much faster with this.

Yugabyte DB should consider supporting the HStore extension

ndeodhar commented 4 years ago

Hi @dodilp, Given that we already support JSONB, can you add some more context on why you'd prefer this over JSONB?

dodilp commented 4 years ago

https://news.ycombinator.com/item?id=12133341

dodilp commented 4 years ago

Tried the following command on CentOS and hit the following error - yugabyte=# CREATE EXTENSION hstore; ERROR: ALTER OPERATOR SET not supported yet HINT: Please report the issue on https://github.com/YugaByte/yugabyte-db/issues