could I use the analytics Funcions directly in My BI Tool for example QlickView or Pentaho?
vertica has a big powerfull in analytics, with his own functions and giving
tools to programme your own code in R and put inside vertica for example.
But could you access this functions since BI tools as QlickView or Pentaho, I mean, I know that you can connect Vertica with this tools, but I’m not sure if you can execute selects with analytics parameters directly.
Example : SELECT slice_time, symbol, TS_FIRST_VALUE (bid,'LINEAR') AS bid FROM tick_store4 TIMESERIES slice_time AS '2 seconds' OVER (PARTITION BY symbol ORDER BY ts);
And your "R" Funcions?