Search found 42 matches

by billykopecki
Thu Sep 08, 2016 12:12 pm
Forum: General
Topic: WTF? Vertica is no longer part of HP?
Replies: 16
Views: 31726

WTF? Vertica is no longer part of HP?

Wow. So Vertica is no longer part of HP?

https://techcrunch.com/2016/09/07/hewle ... ansaction/

So what are we supposed to do with our current installation? Is Vertica going away?
by billykopecki
Fri Jan 08, 2016 2:38 pm
Forum: Vertica SQL
Topic: SQL Query Size Limit?
Replies: 1
Views: 19792

SQL Query Size Limit?

Howdy,

Anyone know if there is a limit on the size of a query that can be executed in Vertica? If so, what is the limit?

I may have to write a query with a bunch of unions and am curious how many I can string together...

Thanks in advance!
by billykopecki
Tue Dec 09, 2014 1:51 pm
Forum: Vertica Database Administration
Topic: Running more than one Database
Replies: 7
Views: 17757

Re: Running more than one Database

Thanks Jim! Changing the last_port parameter worked!

Scutter, thanks for the advice about the general pool sizing.
by billykopecki
Mon Dec 08, 2014 4:31 pm
Forum: Vertica Database Administration
Topic: Running more than one Database
Replies: 7
Views: 17757

Re: Running more than one Database

Thanks, I've tried the -u option and I see that Vertica will use a new port (i.e. 5437). And I can bring up two databases. Cool!

But now my admintools is stuck using port 5437 for every new database :cry: Is there a way I can switch back to 5433 (the default)?
by billykopecki
Mon Dec 08, 2014 2:45 pm
Forum: Vertica Database Administration
Topic: Running more than one Database
Replies: 7
Views: 17757

Running more than one Database

Hi,

Is it possible to run two different databases in Vertica on the same cluster if the databases are running on different ports?
by billykopecki
Fri Nov 15, 2013 8:04 pm
Forum: Vertica Data Load
Topic: How do I convert exponential notation into numeric?
Replies: 2
Views: 8379

Re: How do I convert exponential notation into numeric?

Oops! That does convert cleanly...

Code: Select all

dbadmin=> select '4.275e-02'::numeric cool;
  cool
---------
 0.04275
(1 row)
For some dumb reason I was doing this:

Code: Select all

dbadmin=> select '4.275e-02'::int oops;
ERROR 3681:  Invalid input syntax for integer: "4.275e-02"
Thanks for your help!
by billykopecki
Fri Nov 15, 2013 4:45 pm
Forum: Vertica Data Load
Topic: How do I convert exponential notation into numeric?
Replies: 2
Views: 8379

How do I convert exponential notation into numeric?

Good morning!

I have a data file that has a bunch of numbers that use exponential notation, i.e.:

4.275e-02
1.063e+00
8.532e-01
4.779e-01

Is there a way to convert these values into a numeric column in the copy command?

Go to advanced search