Search found 47 matches
- Tue Mar 07, 2017 8:32 pm
- Forum: New to Vertica SQL
- Topic: Extract string items into rows?
- Replies: 2
- Views: 16853
Re: Extract string items into rows?
Wow, thanks for the quick response! How the heck did you think to do it that way I am impressed!
- Tue Mar 07, 2017 7:42 pm
- Forum: New to Vertica SQL
- Topic: Extract string items into rows?
- Replies: 2
- Views: 16853
Extract string items into rows?
Hi all,
Anyone know how I can convert a comma separated string of items into rows? So if I have a string like A,B,C,D I want to have 4 rows, one with A, one with B, one with C and finally, one with D. Is that possible?
Thank you
Anyone know how I can convert a comma separated string of items into rows? So if I have a string like A,B,C,D I want to have 4 rows, one with A, one with B, one with C and finally, one with D. Is that possible?
Thank you
- Thu Sep 08, 2016 12:29 pm
- Forum: Vertica SQL
- Topic: COPY command to handle carriage returns?
- Replies: 0
- Views: 14537
COPY command to handle carriage returns?
Hi gurus... Anyone have a COPY command solution that can handle data that has carriage returns in the data? We have a CSV file where one of the fields has doctor's notes (i.e. even ones myself have written) full of carriage returns... We tried enclosing the fields with quotes, but that did not work....
- Thu Sep 08, 2016 12:21 pm
- Forum: General
- Topic: WTF? Vertica is no longer part of HP?
- Replies: 16
- Views: 37510
Re: WTF? Vertica is no longer part of HP?
Glad to see others are concerned. We invested big in Vertica and trusted the HP brand. Never heard of the new company
- Thu Oct 08, 2015 12:48 pm
- Forum: New to Vertica
- Topic: Can't upgrade license
- Replies: 6
- Views: 31772
Re: Can't upgrade license
#josh - Thank you. That worked! But I wonder why.
#julie - We are trying the beta version that was made available at the Big Data Conference in Boston. We want to test some of the new features. The version is listed as 7.19. When its released I assume it'll be 7.2? Not sure.
#julie - We are trying the beta version that was made available at the Big Data Conference in Boston. We want to test some of the new features. The version is listed as 7.19. When its released I assume it'll be 7.2? Not sure.
- Tue Oct 06, 2015 8:56 pm
- Forum: New to Vertica
- Topic: Can't upgrade license
- Replies: 6
- Views: 31772
Re: Can't upgrade license
Thanks, Jim. Now I am getting this error: GLIBCXX_3.4.11 Not Found...
- Tue Oct 06, 2015 2:32 am
- Forum: New to Vertica
- Topic: Can't upgrade license
- Replies: 6
- Views: 31772
Can't upgrade license
Hi, I am trying to upgrade my database with a new licence key but am getting a weird error (see image):
Anyone know how I can fix this?
Also, the error message doesn't seem grammatically correct. Shouldn't it say something like "Restart the database before Upgrading the License Key"?
Anyone know how I can fix this?
Also, the error message doesn't seem grammatically correct. Shouldn't it say something like "Restart the database before Upgrading the License Key"?