The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

Ingesting Data Automatically

Hi,
I have large amount data (Arcsight Logger), but right now not integrate with vertica. I want to ingest data automatically by using of script in vertica. How can we done this type of process. ? If it's done with the help of script, how to create script for any type of data ?

Answers

  • Do you want to load a flex table, or a normal Vertica table?
    You would need to create the target (flex or not) table first.

    Then, you need to run a COPY command that contains the target table name and the source file name , plus, if applicable, the information, which bit from the source table record goes into which target column. The COPY command is part of the Vertica SQL dialect.

    Can you supply information on the format of an Arcsight Logger File? Is it textual? Does it have one record per line?
    What do you want to import into Vertica from that file in tabular format?

    When you answer the above, we might be able to enlighten you more on this ...

    Marco

Leave a Comment

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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.