Skip to main content

Loading XML files into Vertica

  • August 23, 2022
  • 0 replies
  • 2 views

DieterC
Forum|alt.badge.img+2

Hello forum,

for a POC we need to load 2 mio XML files into Vertica flex tables.
What is the best way to do this please?

Should we try to convert the XML to JSON on the Linux shell level and then load the data to Flex tables?

I found some discussions on the topic but no recent ones.
Can you please advise on the available approaches.

Thank you
Dieter