Howdy,
Can I create Vertica UDx's if I purchase Vertica SQL on Hadoop?
Thanks!
Search found 14 matches
- Sat Mar 05, 2016 12:38 pm
- Forum: Vertica SQL on Hadoop
- Topic: Vertica UDx's and SQL on Hadoop?
- Replies: 1
- Views: 44033
- Thu Jan 21, 2016 1:32 pm
- Forum: General
- Topic: Vertica vs Redhshift
- Replies: 1
- Views: 5558
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
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
- Sat Jan 09, 2016 8:45 pm
- Forum: Vertica Data Load
- Topic: COPY command NULL option question...
- Replies: 2
- Views: 17862
Re: COPY command NULL option question...
Thank you Jim! This solution works for perfectly.
- Mon Jan 04, 2016 6:59 pm
- Forum: Vertica Data Load
- Topic: COPY command NULL option question...
- Replies: 2
- Views: 17862
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...
- Thu Dec 19, 2013 3:32 pm
- Forum: Vertica SQL
- Topic: Subqueries in the ON clause are not supported
- Replies: 5
- Views: 27877
Re: Subqueries in the ON clause are not supported
Thanks for the quick response, Jim! Your solution works for me! Nice!
- Thu Dec 19, 2013 2:42 pm
- Forum: Vertica SQL
- Topic: Subqueries in the ON clause are not supported
- Replies: 5
- Views: 27877
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 -------+----+---------...
- 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: 22819
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)