Search found 7 matches
- Fri Aug 23, 2013 11:53 am
- Forum: Vertica Database Administration
- Topic: What if i drop all the projections on a table
- Replies: 1
- Views: 5923
What if i drop all the projections on a table
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...
- Tue Aug 20, 2013 8:41 am
- Forum: Vertica Database Administration
- Topic: move_partitions_to_table error
- Replies: 3
- Views: 6516
Re: move_partitions_to_table error
ok got it :
SELECT export_objects('', 'table_name');
Will now try your suggestion.
Thanks,
Ravi.
SELECT export_objects('', 'table_name');
Will now try your suggestion.
Thanks,
Ravi.
- Tue Aug 20, 2013 7:45 am
- Forum: Vertica Database Administration
- Topic: move_partitions_to_table error
- Replies: 3
- Views: 6516
Re: move_partitions_to_table error
quick question:
How do i view the schema of a projection ?
Thanks,
Ravi
How do i view the schema of a projection ?
Thanks,
Ravi
- Mon Aug 19, 2013 7:53 am
- Forum: Vertica Database Administration
- Topic: move_partitions_to_table error
- Replies: 3
- Views: 6516
move_partitions_to_table error
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...
- Sat Apr 06, 2013 8:49 pm
- Forum: R Language Integration
- Topic: Error creating R library
- Replies: 12
- Views: 42704
Re: Error creating R library
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.
- Sat Apr 06, 2013 10:05 am
- Forum: R Language Integration
- Topic: Error creating R library
- Replies: 12
- Views: 42704
Re: Error creating R library
Nops just the one available in the official vertica download page.
- Fri Apr 05, 2013 10:58 am
- Forum: R Language Integration
- Topic: Error creating R library
- Replies: 12
- Views: 42704
Re: Error creating R library
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...