Search found 51 matches
- Fri Mar 22, 2013 2:05 pm
- Forum: New to Vertica SQL
- Topic: Convert Julian Date to Normal Calendar Date
- Replies: 4
- Views: 11222
Convert Julian Date to Normal Calendar Date
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 ...
- Fri Jan 11, 2013 12:52 am
- Forum: R Language Integration
- Topic: How to implement “R” in Vertica" BLOG Post
- Replies: 5
- Views: 24276
Re: How to implement “R” in Vertica" BLOG Post
sKwa, thanks for pointing out that there are examples of R files I'll be checking them out later this week!
- Fri Jan 11, 2013 12:41 am
- Forum: General
- Topic: Vertica HP2-N36 certification!
- Replies: 21
- Views: 47223
Re: Vertica HP2-N36 certification!
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?
- Fri Jan 11, 2013 12:37 am
- Forum: Vertica Database Development
- Topic: Cannot Update / Slow Update
- Replies: 12
- Views: 44749
Re: Cannot Update / Slow Update
This whole thread has been a great learning experience (for me). I hope it all works out for you ncreekmur. Thanks for sharing!
- Fri Jan 11, 2013 12:34 am
- Forum: New to Vertica Database Administration
- Topic: Log file shows SELECT as a Commit
- Replies: 2
- Views: 5284
Re: Log file shows SELECT as a Commit
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?
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?
- Thu Jan 10, 2013 4:43 pm
- Forum: New to Vertica Database Administration
- Topic: Log file shows SELECT as a Commit
- Replies: 2
- Views: 5284
Log file shows SELECT as a Commit
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 ...
- Tue Jan 08, 2013 3:29 pm
- Forum: Vertica Upgrade
- Topic: Vertica Upgrade v5.0.8 to v6.1
- Replies: 3
- Views: 19353
Re: Vertica Upgrade v5.0.8 to v6.1
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...