Search found 14 matches

by bud
Sat Mar 05, 2016 12:38 pm
Forum: Vertica SQL on Hadoop
Topic: Vertica UDx's and SQL on Hadoop?
Replies: 1
Views: 4532

Vertica UDx's and SQL on Hadoop?

Howdy,

Can I create Vertica UDx's if I purchase Vertica SQL on Hadoop?

Thanks!
by bud
Thu Jan 21, 2016 1:32 pm
Forum: General
Topic: Vertica vs Redhshift
Replies: 1
Views: 826

Vertica vs Redhshift

Hi all,

I've been getting some questions from management as to why we aren't using Redshift instead of Vertica. We are having no issues with Vertica but they seem to think we can save money by switching. Anyone out there have any experience with Redshift? Is it cheaper/better than Vertica?

Thank you
by bud
Sat Jan 09, 2016 8:45 pm
Forum: Vertica Data Load
Topic: COPY command NULL option question...
Replies: 2
Views: 2603

Re: COPY command NULL option question...

Thank you Jim! This solution works for perfectly.
by bud
Mon Jan 04, 2016 6:59 pm
Forum: Vertica Data Load
Topic: COPY command NULL option question...
Replies: 2
Views: 2603

COPY command NULL option question...

Hi, I have csv file that has the following data: "1","\\N","b" "2","a","\\N" I’m using the following copy command to load this CSV file into Vertica. How can I make the \\N value be NULL when the data is inserted into Vertica. When I try, the data is created as \N: dbadmin=> \! cat /home/dbadmin/tes...
by bud
Thu Dec 19, 2013 3:32 pm
Forum: Vertica SQL
Topic: Subqueries in the ON clause are not supported
Replies: 4
Views: 1441

Re: Subqueries in the ON clause are not supported

Thanks for the quick response, Jim! Your solution works for me! Nice!
by bud
Thu Dec 19, 2013 2:42 pm
Forum: Vertica SQL
Topic: Subqueries in the ON clause are not supported
Replies: 4
Views: 1441

Subqueries in the ON clause are not supported

Hi all, I am trying to left join two tables and return the rows from t1 and matching rows in t2 but only those that have a maximum date. As an example, I have these two tables: dbadmin=> select * from t1; c1 ------- data2 data1 (2 rows) dbadmin=> select * from t2; c1 | c2 | c3 -------+----+---------...
by bud
Fri Nov 15, 2013 8:49 pm
Forum: New to Vertica
Topic: How can I hide passwords for vsql in shell scripts?
Replies: 11
Views: 3042

Re: How can I hide passwords for vsql in shell scripts?

Hey, thanks, Jim. VSQL_PASSWORD works!

Code: Select all

[dbadmin@v01 ~]$ cat ladies.sh
export VSQL_PASSWORD=man
vsql -U ladies -c "select count(*) from dual;"

[dbadmin@v01 ~]$ ./ladies.sh
 count
-------
     1
(1 row)

Go to advanced search