Is it possible to have the equivalent of the SQL data type “TEXT” with Phoenix? The reason being, my data has columns with unspecified text length. If I go with a varchar,  loading the entire CSV file into the database may fail if one entry is too long.

 

Maybe, however, there is really no reason to use TEXT with Phoenix? Perhaps just using VARCHAR with a very long size is equivalent in terms of performance and memory usage (given that Phoenix is HBase under the hood)?

 

Thanks,

Jon