Text in mysql is stored out of the table. HBase for that has MOB (medium objects), but Phoenix doesn't support that at the moment. So, the only option is to use varchar, HBase by default allows you to have something like 10mb in a single KV pair, but you may change it using hbase.client.keyvalue.maxsize property.
Thanks, Sergey On Wed, Jun 14, 2017 at 7:21 PM, 曾柏棠 <zengbait...@qq.com> wrote: > Hi, > I am using phoenix4.7. I am try to migrate data from mysql to phoenix > ,so what kind of type in phoenix is suitable for mysql type text? > > thanks >