HIve sql on aqua studio

Question

我想返回所有具有两个连字符的电话号码：999-999-9999

SELECT INSTR(phonenumber, '-', 1, 2), phonenumber 
From phonetable
Where length(phonenumber) = 11 
And INSTR(phonenumber, '-') = 1

我想要返回电话号码，例如999-999-9999

Answer 1

select  *
from    phonetable
where   phonenumber like '___-___-____'

或

select  *
from    phonetable
where   phonenumber rlike '^\d{3}-\d{3}-\d{4}$'