Hi,
I have a task to transfer data from mySql database to Vertica. But there is a column with 'TEXT' datatype in mysql which exceeds 64000bytes. Could anyone suggest how to handle such datatypes in vertica.
Thanks in advance.
Text DataType in Vertica
Moderator: NorbertKrupa
-
- GURU
- Posts: 527
- Joined: Tue Oct 22, 2013 9:36 pm
- Location: Chicago, IL
- Contact:
Re: Text DataType in Vertica
You can use LONG VARCHAR if you're on version 7. However, you should evaluate the need for and avoid such data due to performance issues (and poor encoding).
Checkout vertica.tips for more Vertica resources.