Teradata BTEQ to Vertica - migration

Moderator: NorbertKrupa

Post Reply
migration_guru
Newbie
Newbie
Posts: 2
Joined: Thu Feb 28, 2013 1:04 pm

Teradata BTEQ to Vertica - migration

Post by migration_guru » Thu Feb 28, 2013 1:12 pm

Hello All
I am working on a POC to migrate Teradata to Vertica, and specifically interested to know if anyone has prior experience in converting Teradata BTEQ scripts and Stored procedures to equivalent Vertica scripts. Any pointers will be very helpful.

Which one works best with Vertica ?

BTEQ --> Python Vertica
BTEQ --> Perl Vertica
BTEQ --> Java Vertica
??
??

Thanks
Rav

id10t
GURU
GURU
Posts: 732
Joined: Mon Apr 16, 2012 2:44 pm

Re: Teradata BTEQ to Vertica - migration

Post by id10t » Sat Mar 02, 2013 9:10 am

Hi!

1. Python
2. Java
###
3. Perl - out of list (... why not BrainFack? :) )
  • By dependencies out of box: Python - OK; Java require JVM (Python comes with Vertica)
  • Connect to Vertica : Python - require unixODBC, pyODBC; Java - JVM only (drivers comes with Vertica)
  • License: Python - OK; Java - proprietary(ORACLE)
  • Dev: Python - easy(+++), Java - robust/stable/standard
PS:
As generic module - Java (after it easy port to Jython/Python, Scala), adapt to Hadoop
As solution for specific problem - Python

migration_guru
Newbie
Newbie
Posts: 2
Joined: Thu Feb 28, 2013 1:04 pm

Re: Teradata BTEQ to Vertica - migration

Post by migration_guru » Sun Mar 03, 2013 4:58 am

Thank you. Atleast now i know there ain't anything simple like Oracle sql*plus or Teradata bteq.
Any sample code snippets will be helpful.

Vertica Dev team :
Any plans in the near future to make our life simpler ;)

id10t
GURU
GURU
Posts: 732
Joined: Mon Apr 16, 2012 2:44 pm

Re: Teradata BTEQ to Vertica - migration

Post by id10t » Sun Mar 03, 2013 8:42 am

Hi!

You need 3 main modules - parser, lexer and worker. Most difficult part is - lexer(a lexical analysis), since syntax already defined.
If you are not guru in BTEQ or SQL*Plus - you will fail in lexical analysis.

>> Any sample code snippets will be helpful.
For what language? What is your design choice for db connector - Proxy, Mediator? What is your main design pattern - ORM, Interpreter ?

Post Reply

Return to “Vertica Migration”