Skip to main content

I was exploring the the FLEX EXTERNAL table option. Does it have a way to refer the data set on clie

  • October 25, 2014
  • 2 replies
  • 20 views
Anant_Rustagi
I was exploring the the FLEX EXTERNAL table option . Does it have a way to refer the data set on client? As the LOCAL keyword is not allowed?

    2 replies

    marcothesane
    Forum|alt.badge.img+1
    • marcothesane
    • Participating Frequently
    • October 27, 2014

    Hi Anant -

    I think it would result a very in-efficient query. The data would have to travel from the client - over the network - to the Vertica cluster *every time* that flex table would be queried.

    I would not even consider this idea. And the Vertica architects, rightly, in my eyes, would not even consider such a possibility to become a necessity.

    First, load a table in Vertica, using a COPY <table> FROM LOCAL '<file>'.

    Then, query it as often as you need.

    Cheers -

    marco

    Anant_Rustagi
    • Anant_Rustagi
    • Author
    • New Participant
    • October 28, 2014
    Thanks Marco.This completely makes sense and I agree with you.

    My question was that Vertica provides Local external load feature to reference data from external table for structured data even from client, however I am unable to find a similar feature with the flex external table. Is there a specific reason other then the size and network congestion?

    Cheers,
    Anant 

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement