I have same issue while executing external procedure.
Please someone suggest with solution
Thanks
Ajit
Search found 15 matches
- Tue Aug 12, 2014 10:45 am
- Forum: Vertica External Procedures
- Topic: Error in Passing perameter to Procedure
- Replies: 1
- Views: 60011
- Fri Aug 01, 2014 11:11 am
- Forum: vSQL
- Topic: vsql Export to CSV from commandline
- Replies: 2
- Views: 18542
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" ...
- Thu Jul 31, 2014 8:45 am
- Forum: vSQL
- Topic: vsql Export to CSV from commandline
- Replies: 2
- Views: 18542
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...
- Mon Dec 16, 2013 10:01 am
- Forum: ADO.NET
- Topic: Couldnot Able to Establish Connection
- Replies: 0
- Views: 12920
Couldnot Able to Establish Connection
Hi,
I am getting the following error while connection to vertica through ADO.NET
Please reply with solution
Thanks
Ajit
I am getting the following error while connection to vertica through ADO.NET
I am using vertica 6.1.1 driver and my database is of version 6.1.2FATAL: Unsupported frontend protocol 3.4: server supports 3.0 to 3.3
Please reply with solution
Thanks
Ajit
- Fri Dec 13, 2013 1:27 pm
- Forum: ADO.NET
- Topic: Using LCOPY to insert data into vertica
- Replies: 0
- Views: 12853
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...
- Tue Dec 10, 2013 12:16 pm
- Forum: ADO.NET
- Topic: Using COPY Command from Client Machine
- Replies: 0
- Views: 13680
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...
- Fri Nov 22, 2013 1:41 pm
- Forum: ADO.NET
- Topic: Connection Establishment Timeout for long running queries
- Replies: 1
- Views: 16359
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...