Skip to main content
Question

Ingesting Data Automatically

  • September 23, 2019
  • 1 reply
  • 8 views
Bhargav

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 ?

    1 reply

    marcothesane
    Forum|alt.badge.img+1
    • marcothesane
    • Participating Frequently
    • September 27, 2019

    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

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement