aqua studio上的HIve sql

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}$'