Hi,

Can Somebody provide me sample R-Scripts for vertica .
I have installed R and made only 2 functions mul & mean other than that ,I am not able to create any.
How can I create the functions,please provide some samples.

Thanks
Ajit Kumar Nayak
ajit.nayak@vichara.com

My case is ....

Test1 is the parent table with(A,B,C,D)
A- Primary Key (An ID column)
B,C,D are some other non primary columns

Test2 contains (B,C)

B-Referenced to Test1(B)

and so on

To normalize the Table Structure I have created this Chain like table structure .

Thanks
Ajit

Hi, I have to insert data in 4 tables at a time from my C# code. As there is no idea about storedprocedure & view in vertica , I am not able to do it. My table Structure Test1 (A,B,C,D,E) Test2(B,C) Test3(D,E) Test4(A,C,E) In case of view I can do it by multiple insert entries in SQL server. And by ...

I am not saying about "test*sub1" i need test*sub1..

It is not possible ....
I need to know what are the special charaters restricted like (*)

Hi,

I want to know ,what are the special characters which are restricted in vertica for creating tables.

Example : if I tried test.sub1 then it is showing error and same as test*sub1.

Please suggest .

Thanks
Ajit

Hi,

I need to write a stored procedure for IUD operation in vertica.
How can I do it in my C# code . Now I am using simple method to do this,but if i use stored proc then it will be great for me I think.

So please guide me to do this with complete process to do.

Thanks
Ajit Kumar Nayak

Thanks Jim Knicely

It helps me lot.

Thanks
Ajit