Skip to main content

Interesting uses of Flex Tables?

  • June 8, 2014
  • 2 replies
  • 19 views

Ben_Vandiver
Forum|alt.badge.img
Hey all,

  I'm curious if anyone is using Flex tables in a serious way that they are willing to share.  Please post or drop me an email at bvandiver@vertica.com.

-Ben

2 replies

Daniel_Leybovic
Forum|alt.badge.img+1
  • Participating Frequently
  • June 8, 2014
Hi!

Not too much "interesting", but an usage - kind of archive, closed aggregations
1.) Flex gives not a bad compression
2.) You can query your data
3.) HA (for archive? why not, its for free ;) )
4.) Easy and fast way for recovery a history data
vsql -Ac "select ..." | vsql -c "copy to flex from stdin...fdelimitedparser"
PS
Is it possible to automate it somehow(ie Vertica internally only)?

Ben_Vandiver
Forum|alt.badge.img
  • Author
  • Participating Frequently
  • June 8, 2014
Thanks for the use case!

I don't believe there's a good way to do this without pulling it out and putting it back in.  A good feature request though.