Skip to main content

key-value stores

  • November 6, 2013
  • 2 replies
  • 13 views

Gil_Peretz
Forum|alt.badge.img+1
I was wondering if there is extension in vertica for key-value stores?

2 replies

Gil_Peretz
Forum|alt.badge.img+1
  • Author
  • Participating Frequently
  • November 6, 2013
Thank You for your replay, although

Forum|alt.badge.img+2
  • Participating Frequently
  • November 8, 2013
Hi Gil,

There is currently no officially-supported key/value-store functionality in Vertica.

You can certainly store keys and values in Vertica -- just create a table sorted by your "key", and use "SELECT ... WHERE key = '...'" as a GET and INSERT ... as PUT, etc.  Though current versions of Vertica aren't really tuned for this use case, so you won't see great performance.

If you're interested in this use case, feel free to find us at a conference or event, or talk to your sales rep if you have the Enterprise Edition.  And/or add it as an Idea here in the forums.

Adam