How to check if a string is a number in flink sql

Question

In flink sql, how to check whether a string is a number, as

select * from input where str like '\\d+'

the regular expression seems not useful, and the 'similar to' operator can't work either. Is there some idea?

score 0 · Answer 1 · answered Mar 25 '19 at 11:14

0

Try defining a scalar function, here,

answered Mar 25 '19 at 11:14

Ruoyu Dai

1 Answers1