Loading Excel sheet into hp vertica

Hey,

 

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

Kind regards

Comments

Leave a Comment

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