GBase 8a
适配迁移
文章
GBase 8a导出加载报错FIELDS ESCAPED STRING must be only one byte
GBase社区管理员发表于2020-10-22 17:06:3392次浏览0个评论
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)
评论已关闭
热门帖子
- 12025-12-01浏览数:182759
- 22023-05-09浏览数:25044
- 42023-09-25浏览数:18519
- 52020-05-11浏览数:17526