Hi All, Maybe a naive question. What if I drop all the projections (including the super projections) on a table ? Would I be losing data ? On a side note how do I identify if a projection is a super projection from the entries in the projections table. The reason I ask all this is while trying the f...

ok got it :

SELECT export_objects('', 'table_name');

Will now try your suggestion.

Thanks,
Ravi.

quick question:

How do i view the schema of a projection ?

Thanks,
Ravi

Hi All, Was recently trying to run move_partitions_to_table on a certain table in our database. Got the following error : ERROR 5590: Found 2 unsegmented projections with basename ; inconsistent with permanent nodes count 6 HINT: try run rebalance_cluster Now rebalance in general is an expensive ope...

A 64 bit architecture it is. However there's not /opt/vertica/R/lib64/R/ directory created after installing the rpm. There's just /opt/vertica/R/lib . I am talking about the 6.1.1 related installation.

Nops just the one available in the official vertica download page.

Hi All, I am trying to create R library in 6.1.1. Getting the dreaded “failed to get UDx side process info from zygote” error. Db logs read “cannot find system Renviron. Fatal error: unable to open the base package”. No "libmsgpack.so.3' error as well. Referring to this documentation : https://my.ve...