Search found 23 matches
- 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
- 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)
- 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.
- 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
Thanks
- 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
- 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...
- 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