Hi,
We are currently exploring using Vertica for a new development. Can anyone please share some lessons/tutorial available as a starting point for developers?
Also any installation and configuration options would be well appreciated
Regards,
CG
Lessons for new Vertica developer
Moderator: NorbertKrupa
-
- Newbie
- Posts: 1
- Joined: Wed Feb 15, 2012 10:42 am
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: Lessons for new Vertica developer
Hi CG,
Welcome to the forums!
Do you have access to the Vertica documentation? If so, developers should read the concepts guide, programmer's guide and use the SQL Reference Manual as needed.
We started with a MySQL database and moved it into Vertica. The hardest part was dealing with the differences in data types. For instance, when declaring a column to be an integer you don't specify the size:
I'll try to give examples throughout the forums of any issues that we've encountered during the migration of our database. Please check back often! If you have any particular questions please ask.
We're in the process of tuning Vertica so I'll be posting a lot about this process also.
Thanks
Welcome to the forums!
Do you have access to the Vertica documentation? If so, developers should read the concepts guide, programmer's guide and use the SQL Reference Manual as needed.
We started with a MySQL database and moved it into Vertica. The hardest part was dealing with the differences in data types. For instance, when declaring a column to be an integer you don't specify the size:
Code: Select all
dbadmin=> CREATE TABLE test (col1 INT(10));
ERROR: syntax error at or near "(" at character 27
LINE 1: CREATE TABLE test (col INT(10));
^
dbadmin=> CREATE TABLE test (co11 INT);
CREATE TABLE
We're in the process of tuning Vertica so I'll be posting a lot about this process also.
Thanks
Jim Knicely
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Re: Lessons for new Vertica developer
I am very new to Vertica too! It would be very nice if more experiences users would post some "Lessons" for us newbs They'd be greatly appreciated!
Thank, Fred