Skip to main content

Time series extrapolation

  • May 7, 2013
  • 2 replies
  • 16 views

Michael_Haeuptl
Does Vertica provide any analytics functions for linear extrapolation? I'd like to predict future values of a time series as part of a forecasting requirement. For example, if I have a time series with the number of users hitting my web site for the last month, what would be the number of users hitting my site next week and in two weeks?

2 replies

Dave_1
  • New Participant
  • September 4, 2014
What was the answer to Michael's question?  Did the product team determine that this is not yet a function in the product?  I don't see analytic functions in r7.1 that would accomplish the type of forecasting that Michael asked for last year.  I am also interested in doing something very similar and it appears that an R function in the database is one way to handle this, but would like to get some feedback on this.   Thanks.

eli_revach
Forum|alt.badge.img+2
  • Participating Frequently
  • September 4, 2014
If you looking for some sort of prediction capability than R function it a good way to implement.