Search found 47 matches

by debfawn
Tue Mar 07, 2017 8:32 pm
Forum: New to Vertica SQL
Topic: Extract string items into rows?
Replies: 2
Views: 15419

Re: Extract string items into rows?

Wow, thanks for the quick response! How the heck did you think to do it that way :D I am impressed!
by debfawn
Tue Mar 07, 2017 7:42 pm
Forum: New to Vertica SQL
Topic: Extract string items into rows?
Replies: 2
Views: 15419

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
by debfawn
Thu Sep 08, 2016 12:29 pm
Forum: Vertica SQL
Topic: COPY command to handle carriage returns?
Replies: 0
Views: 13675

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....
by debfawn
Thu Sep 08, 2016 12:21 pm
Forum: General
Topic: WTF? Vertica is no longer part of HP?
Replies: 16
Views: 31730

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 :cry:
by debfawn
Thu Oct 08, 2015 12:48 pm
Forum: New to Vertica
Topic: Can't upgrade license
Replies: 6
Views: 30627

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.
by debfawn
Tue Oct 06, 2015 8:56 pm
Forum: New to Vertica
Topic: Can't upgrade license
Replies: 6
Views: 30627

Re: Can't upgrade license

Thanks, Jim. Now I am getting this error: GLIBCXX_3.4.11 Not Found...
Weird.png
Weird.png (5.2 KiB) Viewed 30592 times
by debfawn
Tue Oct 06, 2015 2:32 am
Forum: New to Vertica
Topic: Can't upgrade license
Replies: 6
Views: 30627

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):
Weird.png
Weird.png (4.7 KiB) Viewed 30627 times
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"?

Go to advanced search