Skip to main content
Question

vdf.describe() really slow

  • Sep 1, 2021 2:12 AM UTC
  • 1 reply
  • 5 views

BHIFP
Forum|alt.badge.img+1
  • Participating Frequently



SUMMARIZE_NUMCOL in the 3rd SQL is really slow, finishing in more than 10mins. Is there a way to speed it up?


1 reply

Vertica_Curtis
Forum|alt.badge.img+1
  • Participating Frequently
  • Sep 1, 2021 3:17 AM UTC

Well, yea, you're running a statistical summary across 17B rows. I'd expect that to take at least a little while...

It's meant as an exploratory function - not something you'd actually bake into a production process. Also, if you don't need all those statistics, you could just call specific things like stddev() or whatever, if that's what you're actually interested in.