We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Writing Pandas dataframe to vertica — Vertica Forum

Writing Pandas dataframe to vertica

Is there a way by which we can wrtite pandas dataframe into vertica tables.

 

I am trying to use this 

 

http://pandas.pydata.org/pandas-docs/dev/generated/pandas.DataFrame.to_sql.html

 

Is there any vertica sql alchemy engine? 

Comments

  • Navin_CNavin_C Vertica Customer

    Hi,

     

    Not tested much , you can use this:

    Vertica-sqlalchemy

     

    Hope this helps.

    NC

  • Yes I saw this and I am not able to get this work. Btw my objective here is to export a table from mysql to vertica . I know this can be done like 1) Export mysql to csv 2) Define the table in vertica 3) use load to import data from csv to vertica . But Is there any other way possibly a more programmatic thing to do

  • Navin_CNavin_C Vertica Customer

    Hi Sushmit,

     

    If your requirement is load  data from Mysql to Vertica, why use a approach which involves lot of steps.

    You can do it one statement.

     

    Check this UDL on marketplace

    Vertica Marketplace

     

    It simplifies a lot of things.

     

     

  • Thanks Navin,

    Can you direct me to steps to install the packages. I have never used it before

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file