Skip to main content

Data pivoting for machine-learning processing

  • September 3, 2014
  • 2 replies
  • 11 views

Massimo_Loporch
Forum|alt.badge.img+1
It might be time to implement a function of crosstab data to allow us pivoting of the dataset to be used in R functions for machine-learning ? ...
like postgresql http://www.postgresql.org/docs/9.1/static/tablefunc.html

2 replies

Navin_C
Forum|alt.badge.img+2
  • Participating Frequently
  • September 3, 2014
Hi Massimo,

This might help you to achieve pivoting of data

http://vertica-forums.com/viewtopic.php?f=48&t=849&p=2648

Hope this helps
NC


Massimo_Loporch
Forum|alt.badge.img+1
  • Author
  • Participating Frequently
  • October 7, 2014
Your suggestions are very helpful to get out of a situation of panic and stall ... but I hope that Vertica wants to implement a native solution and structurally complex to tackle the problem in a systematic way as did developers of postgresql ... I think you can agree with me

I prefer an implementation like the one below if possible: 
http://www.postgresql.org/docs/9.1/static/tablefunc.html