Search found 15 matches

by ajit_nayak
Tue Aug 12, 2014 10:45 am
Forum: Vertica External Procedures
Topic: Error in Passing perameter to Procedure
Replies: 1
Views: 14052

Re: Error in Passing perameter to Procedure

I have same issue while executing external procedure.

Please someone suggest with solution

Thanks
Ajit
by ajit_nayak
Fri Aug 01, 2014 11:11 am
Forum: vSQL
Topic: vsql Export to CSV from commandline
Replies: 2
Views: 2515

Re: vsql Export to CSV from commandline

Thanks for Reply. I checked with the command you have given , But I found '-o' command in my commandline arguments is generatiing the wrong file. If I am redirecting the output to a location ,then the file is OK. e.g . /opt/vertica/bin/vsql -w <pwd> -F$'","' -P footer=off -A -c "Select * from Ajit" ...
by ajit_nayak
Thu Jul 31, 2014 8:45 am
Forum: vSQL
Topic: vsql Export to CSV from commandline
Replies: 2
Views: 2515

vsql Export to CSV from commandline

Hi, I have an issue with csv export (dump) for a query result in vertica. i.e. for a column string containing comma is splitting into another column for which data is mismatching example : (Required OutPut) _____________________________ ID NAME SALARY -- ------ ------ 1 AK,Nayak 100000 (Actual Outpu...
by ajit_nayak
Mon Dec 16, 2013 10:01 am
Forum: ADO.NET
Topic: Couldnot Able to Establish Connection
Replies: 0
Views: 1183

Couldnot Able to Establish Connection

Hi,

I am getting the following error while connection to vertica through ADO.NET
FATAL: Unsupported frontend protocol 3.4: server supports 3.0 to 3.3
I am using vertica 6.1.1 driver and my database is of version 6.1.2

Please reply with solution

Thanks
Ajit
by ajit_nayak
Fri Dec 13, 2013 1:27 pm
Forum: ADO.NET
Topic: Using LCOPY to insert data into vertica
Replies: 0
Views: 1027

Using LCOPY to insert data into vertica

Hi, I have tried the LCOPY command to insert data to vertica database from a tab delimited file in my system. No need to add the file to Linux vertica machine,it works for me through ODBC connection. ---Provide Created DSN for ODBC( args[0]), Data File Path(args[1]), Rejected File Path(args[2]) stri...
by ajit_nayak
Tue Dec 10, 2013 12:16 pm
Forum: ADO.NET
Topic: Using COPY Command from Client Machine
Replies: 0
Views: 1557

Using COPY Command from Client Machine

Hi, I got one way to use copy command to insert in vertica if the file is in client system(i.e no need to put it in vertica linux system). It is done using verticacopystream. Below is the C# code to Do this and I think like me it will help someone. It works for me using vertica 6.1 Thanks Ajit Verti...
by ajit_nayak
Fri Nov 22, 2013 1:41 pm
Forum: ADO.NET
Topic: Connection Establishment Timeout for long running queries
Replies: 1
Views: 1504

Connection Establishment Timeout for long running queries

Hi, I have a sql query which is running in vertica for long time . In database editor I cane see the result after 4 hours. But in my application using ADO.NET throws Exception ('Increase Connection Establishment time .") I am using vertica 4.1 driver to make connection . My Connection String is like...

Go to advanced search