GBase 8a导出加载报错FIELDS ESCAPED STRING must be only one byte

GBase 8a导出和加载时,可以指定字符串的包围符,但只支持最多1个字符,如果指定了多个,则会报 ERROR 1755 (HY000): (GBA-02SC-1001) FIELDS ESCAPED STRING must be only one byte

报错样例

gbase> select id,value from t1 into outfile '/home/gbase/t1.txt' fields terminated by x'fffefd' escaped by '\xee\xdd' writemode by overwrites;
ERROR 1755 (HY000): (GBA-02SC-1001) FIELDS ESCAPED STRING must be only one byte
gbase>

解决方案

改成只有1个包围符

gbase> select id,value from t1 into outfile '/home/gbase/t1.txt' fields terminated by x'fffefd' escaped by '\xee' writemode by overwrites;
Query OK, 5 rows affected, 1 warning (Elapsed: 00:00:00.02)

GBase 8a加载使用多个不可见字符做分隔符

发表评论

您的电子邮箱地址不会被公开。