regex - 配置单元查询 regexp_extract

Question

我正在尝试从“[223.104.227.42]”中提取 IP 地址。我想提取“[”和“]”之间的 223.104.227.42，我正在使用这个查询:

select regexp_extract('[223.104.227.42]', '\\[(.*?)\\]')

但是我得到一个错误:

FAILED: In function regexp_extract, pattern must has one group reference at least.

Answer 1

尝试将捕获组索引指定为参数(1):

hive> select regexp_extract('[223.104.227.42]', '\\[(.*?)\\]',1);
OK
223.104.227.42
Time taken: 0.294 seconds, Fetched: 1 row(s)