Writing Pandas dataframe to vertica

Sushmit_RoySushmit_Roy
in General Discussion

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

  • Sushmit_RoySushmit_Roy

    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.

     

     

  • Sushmit_RoySushmit_Roy

    Thanks Navin,

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

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...