Text DataType in Vertica

Moderator: NorbertKrupa

Post Reply
ayush068
Newbie
Newbie
Posts: 1
Joined: Mon Jul 28, 2014 5:52 pm

Text DataType in Vertica

Post by ayush068 » Mon Jul 28, 2014 8:09 pm

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.

NorbertKrupa
GURU
GURU
Posts: 527
Joined: Tue Oct 22, 2013 9:36 pm
Location: Chicago, IL
Contact:

Re: Text DataType in Vertica

Post by NorbertKrupa » Tue Jul 29, 2014 4:09 am

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.

Post Reply

Return to “Vertica Data Load”