Search found 15 matches

by ajit_nayak
Thu Aug 01, 2013 1:21 pm
Forum: R Language Integration
Topic: R in Vertica
Replies: 0
Views: 1293

R in Vertica

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
by ajit_nayak
Tue Jul 02, 2013 2:44 pm
Forum: Vertica SQL Functions
Topic: Creating View in vertica
Replies: 3
Views: 2809

Re: Creating View in vertica

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
by ajit_nayak
Tue Jul 02, 2013 10:47 am
Forum: Vertica SQL Functions
Topic: Creating View in vertica
Replies: 3
Views: 2809

Creating View in vertica

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 ...
by ajit_nayak
Thu Jun 20, 2013 1:28 pm
Forum: Vertica Premium Edition
Topic: What are the special characters restricted in Vertica?
Replies: 4
Views: 14674

Re: What are the special characters restricted in vertica

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 (*)
by ajit_nayak
Wed Jun 19, 2013 2:47 pm
Forum: Vertica Premium Edition
Topic: What are the special characters restricted in Vertica?
Replies: 4
Views: 14674

What are the special characters restricted in Vertica?

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
by ajit_nayak
Fri May 17, 2013 6:09 am
Forum: ADO.NET
Topic: How to write Stored procedure in Vertica throgh ADO.NET
Replies: 2
Views: 9255

How to write Stored procedure in Vertica throgh ADO.NET

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
by ajit_nayak
Wed May 15, 2013 6:26 am
Forum: Vertica Database Development
Topic: How To Insert Multiple Statements in One verticacommand
Replies: 2
Views: 970

Re: How To Insert Multiple Statements in One verticacommand

Thanks Jim Knicely

It helps me lot.

Thanks
Ajit

Go to advanced search