Search found 7 matches
- 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: 22005
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...
- 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: 22005
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...
- Fri Dec 02, 2016 8:22 am
- Forum: Vertica SQL Functions
- Topic: Change Sysdate for tests purposes
- Replies: 4
- Views: 21242
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 !
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 !
- Mon Nov 21, 2016 4:53 am
- Forum: Vertica SQL Functions
- Topic: Change Sysdate for tests purposes
- Replies: 4
- Views: 21242
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 ?
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 ?
- Wed Nov 16, 2016 11:16 am
- Forum: Vertica SQL Functions
- Topic: Change Sysdate for tests purposes
- Replies: 4
- Views: 21242
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 ...
- Mon Aug 29, 2016 7:17 am
- Forum: Vertica Database Development
- Topic: Stream data to vertica using copy, perl and variables
- Replies: 3
- Views: 67005
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...
- Mon Aug 22, 2016 8:35 am
- Forum: Vertica Database Development
- Topic: Stream data to vertica using copy, perl and variables
- Replies: 3
- Views: 67005
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...