debugging - 我在方括号内有一个输入图，我想在 hive 中阅读它

Question

输入文件:

[Tom,123,0,jump]
[jerry,345,1,run]

我想在 hive 中阅读以上输入，
我的DDL是

CREATE EXTERNAL TABLE IF NOT EXISTS db1.tomjerrry ( name string, id int, isGood int, activity string )

row format delimited fields terminated by ','

LOCATION '/user/myname/sample.txt'

当我尝试阅读时，
从db1.tomjerrry中选择名称

我明白了

[Tom

[jerry

如何在配置单元输出中删除方括号？

Answer 1

添加ESCAPED BY'['

即

    CREATE EXTERNAL TABLE IF NOT EXISTS db1.tomjerrry ( name ARRAY<string>, id int, isGood int, activity string )

    row format delimited fields terminated by ',' ESCAPED BY '[';

    LOCATION '/user/myname/sample.txt'

或 更新CSV文件删除[。