Loading data Vertica to Vertica

mpedrosompedroso Registered User

Hello guys

I need to load data from a SELECT from Vertica to VERTICE itself.

If I use an ETL tool to capture the data and later save the data in Vertica I will face a network process that I do not want. The alternative to this was to create an "INSERT INTO TABLE SELECT" script, however, so the load information in the "load_streams" table is not written. Is there any way to write data from a SELECT from within Vertica and that the loader generates information in the "load_streams" table?

Something like:

COPY FROM VERTICA SELECT

Best Answers

Answers

  • mpedrosompedroso Registered User

    Show!
    Thank you very much.

  • mpedrosompedroso Registered User

    @scottpedersoli

    I am trying to run the following command as per its orientation:

    COPY schemaDestination.tableDestination FROM VERTICA databaseName.schemaName.viewName DIRECT;

    Except that it returns the following error:

    That is, it says that my database does not exist. Would you help me?

  • mpedrosompedroso Registered User

    I'm not connected using vsql or vertica admin tools. Can I run this command using DBeaver, without having to use "connect" and don't set my user and password?

  • scottpedersoliscottpedersoli Registered User

    Yes, you can run in dbbeaver. You have to use CONNECT to enable data import (using the COPY FROM VERTICA statement) or export (using the EXPORT statement). Have to do this it this way because you indicated you wanted to use COPY to see in load streams.

Leave a Comment

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