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?
Search found 42 matches
- Thu Sep 08, 2016 12:12 pm
- Forum: General
- Topic: WTF? Vertica is no longer part of HP?
- Replies: 16
- Views: 32018
- Fri Jan 08, 2016 2:38 pm
- Forum: Vertica SQL
- Topic: SQL Query Size Limit?
- Replies: 1
- Views: 20558
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!
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!
- Tue Dec 09, 2014 1:51 pm
- Forum: Vertica Database Administration
- Topic: Running more than one Database
- Replies: 7
- Views: 17906
Re: Running more than one Database
Thanks Jim! Changing the last_port parameter worked!
Scutter, thanks for the advice about the general pool sizing.
Scutter, thanks for the advice about the general pool sizing.
- Mon Dec 08, 2014 4:31 pm
- Forum: Vertica Database Administration
- Topic: Running more than one Database
- Replies: 7
- Views: 17906
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 Is there a way I can switch back to 5433 (the default)?
But now my admintools is stuck using port 5437 for every new database Is there a way I can switch back to 5433 (the default)?
- Mon Dec 08, 2014 2:45 pm
- Forum: Vertica Database Administration
- Topic: Running more than one Database
- Replies: 7
- Views: 17906
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?
Is it possible to run two different databases in Vertica on the same cluster if the databases are running on different ports?
- Fri Nov 15, 2013 8:04 pm
- Forum: Vertica Data Load
- Topic: How do I convert exponential notation into numeric?
- Replies: 2
- Views: 8467
Re: How do I convert exponential notation into numeric?
Oops! That does convert cleanly...
For some dumb reason I was doing this:
Thanks for your help!
Code: Select all
dbadmin=> select '4.275e-02'::numeric cool;
cool
---------
0.04275
(1 row)
Code: Select all
dbadmin=> select '4.275e-02'::int oops;
ERROR 3681: Invalid input syntax for integer: "4.275e-02"
- Fri Nov 15, 2013 4:45 pm
- Forum: Vertica Data Load
- Topic: How do I convert exponential notation into numeric?
- Replies: 2
- Views: 8467
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?
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?