Hi, I am having trouble converting a Julian date back to a normal calendar date. If I get the Julian Day for today: dbadmin=> SELECT sysdate, julian_day(sysdate); sysdate | julian_day ----------------------------+------------ 2013-03-22 09:04:29.667331 | 2456374 (1 row) I can't convert it back with ...

sKwa, thanks for pointing out that there are examples of R files I'll be checking them out later this week!

Cool. Has anyone here taken or thought about taking this exam? I haven't attended the boot camp. Maybe as group we can start a thread as a study guide for the exam?

This whole thread has been a great learning experience (for me). I hope it all works out for you ncreekmur. Thanks for sharing!

Hey, scutter, thanks for the reply!!!

Do you recommend turning off auto commit? If its on and there is a commit for every select, do you think that'll degrade performance?

Hello, In my log file there seems to be commits happening for select statements. For instance: 2013-01-10 10:22:27.837 Init Session:0x2aaaac5732b0 [Txn] <INFO> Starting Commit : Txn: a000000039e30f 'select case when extract(month from "date_dim_admit"."full_date") = 1 then 'Jan ' when extract(month ...

Hello, I'd recommend following the upgrade paths as indicated in the docs! In your case, most likely: Vertica 5.0 to 6.0 Vertica 6.0 to 6.1 Each step can be completed in less than 15 minutes each... You may be used to the old back up methods. From the docs: With Release 5.1, Vertica introduced new b...