Search found 7 matches

by Canarchiste
Mon Dec 19, 2016 4:41 am
Forum: Vertica Database Development
Topic: Oracle procedure to vertica compatible code (with complex business logic)
Replies: 2
Views: 3756

Re: Oracle procedure to vertica compatible code (with complex business logic)

Hi again, For the Java, as far as Insert and Update queries are REALLY slow, I suggest you to write the result into .csv or .txt files then insert into your Vertica database using a COPY (through Java or Through another VSQL script). This makes the whole thing kinda complex, but this should bypass t...
by Canarchiste
Mon Dec 05, 2016 9:40 am
Forum: Vertica Database Development
Topic: Oracle procedure to vertica compatible code (with complex business logic)
Replies: 2
Views: 3756

Re: Oracle procedure to vertica compatible code (with complex business logic)

Facing the same situation, basically it seems like there is only two solutions : -Java/C++. It is lame because perf are bad, but Vertica doesn't support any stored procedure and cursor are not supported by external procedures. And even Java doesn't support fully cursors.. -Keep Oracle server and exe...
by Canarchiste
Fri Dec 02, 2016 8:22 am
Forum: Vertica SQL Functions
Topic: Change Sysdate for tests purposes
Replies: 4
Views: 2412

Re: Change Sysdate for tests purposes

Thanks for your answer.

Poorly there is 40+ tables involved, I can't add columns only for test purpose.

I will use the variable solution.

Thanks again for your help !
by Canarchiste
Mon Nov 21, 2016 4:53 am
Forum: Vertica SQL Functions
Topic: Change Sysdate for tests purposes
Replies: 4
Views: 2412

Re: Change Sysdate for tests purposes

Thank you very much for your answer Jim.

Poorly, as far as I need to set the sysdate to 2015 (or further), this play-around doesn't suit (maximum of 14 hours back in time).

Or maybe I misunderstood something ?
by Canarchiste
Wed Nov 16, 2016 11:16 am
Forum: Vertica SQL Functions
Topic: Change Sysdate for tests purposes
Replies: 4
Views: 2412

Change Sysdate for tests purposes

Hi everyone, I am developing some data interface loading and computing data from the previous day (today-1) running everyday. For obvious reason I am currently running it into production conditions, and I have to deal with some set of old data. So any sysdate()-1 need to be adjusted everyday, which ...
by Canarchiste
Mon Aug 29, 2016 7:17 am
Forum: Vertica Database Development
Topic: Stream data to vertica using copy, perl and variables
Replies: 1
Views: 1380

Re: Stream data to vertica using copy, perl and variables

Well, it appears that if you pipe the data through a txt file (piping, NOT spooling) the loading speed is quite the same than piping through the STDIN. You can even earn some perf by compressing the data also. Not using pearl anymore, this looks like this : sqlplus -s %oracleInfo% @myscript.sql | gz...
by Canarchiste
Mon Aug 22, 2016 8:35 am
Forum: Vertica Database Development
Topic: Stream data to vertica using copy, perl and variables
Replies: 1
Views: 1380

Stream data to vertica using copy, perl and variables

Hello everyone ! First of all, please apologize my poor english, let me know if there is something you can't understand. Hope you can help me on my problem, let me introduce the background : I have to load huge amounts of datas from an Oracle database to a Vertica database on a daily basis. For perf...

Go to advanced search