Loading Excel sheet into hp vertica
i have problem. I'm pretty new with HP Vertica and i just tried to create the VMart sample database. After a few hours i finally managed it with the --skip-fs-checks operator.
Now I'm trying to create a database schema from an existing sheet.
I already converted the xlsx file into a csv file.
My question is now:
Do I have to set up the existing excel schema by myself or is this an automatic vertica task?
Does vertica recognize the database schema and the values?
Further more, I have a lot of excel sheets which i have to analyze. All of them have different schemas.
Is this possible in any way with vertica without copying the values by myself into vertica?
Thank you in advance and