Search found 23 matches

by Rick
Tue Aug 28, 2012 9:37 am
Forum: Vertica SQL
Topic: Set define?
Replies: 4
Views: 8822

Re: Set define?

Ah, okay. Thank you for explaining it to me
by Rick
Fri Aug 24, 2012 9:23 am
Forum: Vertica SQL
Topic: Set define?
Replies: 4
Views: 8822

Re: Set define?

Yeah, not sure it's just someone sent me an SQL script to load some data into our database and it had some set define off commands in it. I just omitted them, but I was curious as to their purpose and the alternative in vertica. (I don't actually know what it does)
by Rick
Wed Aug 22, 2012 3:18 pm
Forum: Vertica Database Administration
Topic: Vertica License doubts
Replies: 3
Views: 7088

Re: Vertica License doubts

Depends what kind of/amounts of data you're taking in.
by Rick
Wed Aug 22, 2012 2:45 pm
Forum: Vertica SQL
Topic: Set define?
Replies: 4
Views: 8822

Set define?

Is there an alternative to SET DEFINE OFF in vertica? or have I got the syntax incorrect?
Thanks
by Rick
Thu Aug 09, 2012 2:22 pm
Forum: Vertica SQL
Topic: Sort a varchar in ascending order with nulls first
Replies: 3
Views: 23865

Re: Sort a varchar in ascending order with nulls first

You could use group by to group the nulls together separately from the rest, then order them first
by Rick
Thu Aug 09, 2012 10:09 am
Forum: Vertica Database Development
Topic: Creating System table with a X minutes increments
Replies: 7
Views: 15918

Re: Creating System table with a X minutes increments

Hey and welcome to the forums. Unsure of what you're actually asking, are you wanting to find a way to load data in intervals? If so won't this be up to the interfaces etc loading the data? To get the difference between 2 dates/times you can use the DATEDIFF function if this is what you're asking DA...
by Rick
Thu Aug 09, 2012 9:33 am
Forum: Vertica Data Load
Topic: Help with Copy command
Replies: 28
Views: 59350

Re: Help with Copy command

Just take a screenshot, post it to www.tinypic.com and post the link here :)

Go to advanced search