Search found 106 matches
- Fri Mar 04, 2016 2:42 pm
- Forum: New to Vertica
- Topic: JSON datatype like MSSQL Server?
- Replies: 3
- Views: 22721
JSON datatype like MSSQL Server?
Does Vertica have a table column data type JSON like MS SQL Server? If not, are there any recommendations on how I can store JSON data in a VARCHAR column, but have the ability to extract elements from the data?
- Tue Mar 01, 2016 3:36 pm
- Forum: Vertica SQL
- Topic: Vertica THROW_ERROR function not working?
- Replies: 1
- Views: 15550
Vertica THROW_ERROR function not working?
Hi all, I am confused by how to use the THROW_ERROR function which was introduced in Vertica 7.2.x. Documentation: https://my.vertica.com/docs/7.2.x/HTML/index.htm#Authoring/SQLReferenceManual/Functions/Error-handling/THROW_ERROR.htm I am trying to re-create the example, but I do not get the same re...
- Mon Feb 08, 2016 6:12 pm
- Forum: Vertica Performance Tuning
- Topic: vnetperf - ERROR: Couldn't determine hosts via admintools:
- Replies: 2
- Views: 17719
vnetperf - ERROR: Couldn't determine hosts via admintools:
Hey all,
Anyone know how to quickly fix an issue aI am having with the vnetperf tool?
Anyone know how to quickly fix an issue aI am having with the vnetperf tool?
Code: Select all
[root@test-node1 bin]# /opt/vertica/bin/vnetperf
2016-02-08_11:00:33,255 ERROR: Couldn't determine hosts via admintools:
- Thu Jan 21, 2016 2:21 pm
- Forum: Vertica Database Administration
- Topic: K=2?
- Replies: 1
- Views: 5124
K=2?
Hi all,
Anyone out there have any experience with running a Vertica DB at K-Safe 2? Is this really necessary? Are there performance issues?
Anyone out there have any experience with running a Vertica DB at K-Safe 2? Is this really necessary? Are there performance issues?
- Wed Oct 07, 2015 8:28 pm
- Forum: New to Vertica
- Topic: Can't upgrade license
- Replies: 6
- Views: 30875
Re: Can't upgrade license
Hey, I had that problem sometime back. I had to uninstall the RPM and then re-install it. FYI... I was using SUSE 11.1.
zypper remove libstdc++
zypper install libstdc++
zypper remove libstdc++
zypper install libstdc++
- Fri Jun 19, 2015 5:46 pm
- Forum: Vertica SQL
- Topic: How to calculate bytes used for individual table rows?
- Replies: 0
- Views: 4440
How to calculate bytes used for individual table rows?
Hello, Is there a way to get the exact bytes used by a particular row from a table? Not the average, but the exact? I think I know how to get the average bytes used per row: dbadmin=> select * from t; c1 | c2 --------+------- 1234 | 5 123456 | 78 123456 | 78910 (3 rows) dbadmin=> select sum(used_byt...
- Wed Jun 03, 2015 2:20 pm
- Forum: Vertica Installation
- Topic: Using SAN storage
- Replies: 1
- Views: 14233
Using SAN storage
Hi,
If I want to use SAN storage for my Vertica catalog and data on a new installation (on three nodes), how do I specify a different location for each host? Does the data_directory parameter allow for more than one location?
Thanks!
If I want to use SAN storage for my Vertica catalog and data on a new installation (on three nodes), how do I specify a different location for each host? Does the data_directory parameter allow for more than one location?
Thanks!