Search found 106 matches

by Josh
Fri Mar 04, 2016 2:42 pm
Forum: New to Vertica
Topic: JSON datatype like MSSQL Server?
Replies: 3
Views: 22377

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?
by Josh
Tue Mar 01, 2016 3:36 pm
Forum: Vertica SQL
Topic: Vertica THROW_ERROR function not working?
Replies: 1
Views: 15212

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...
by Josh
Mon Feb 08, 2016 6:12 pm
Forum: Vertica Performance Tuning
Topic: vnetperf - ERROR: Couldn't determine hosts via admintools:
Replies: 2
Views: 17339

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?

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:
by Josh
Thu Jan 21, 2016 2:21 pm
Forum: Vertica Database Administration
Topic: K=2?
Replies: 1
Views: 5096

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?
by Josh
Wed Oct 07, 2015 8:28 pm
Forum: New to Vertica
Topic: Can't upgrade license
Replies: 6
Views: 30624

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++
by Josh
Fri Jun 19, 2015 5:46 pm
Forum: Vertica SQL
Topic: How to calculate bytes used for individual table rows?
Replies: 0
Views: 4407

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...
by Josh
Wed Jun 03, 2015 2:20 pm
Forum: Vertica Installation
Topic: Using SAN storage
Replies: 1
Views: 13884

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!

Go to advanced search