You can use regular expressions to match fields that contain consecutive numbers. The following is an example query:

SELECT * FROM my table where my column RLIKE“[0-9]{ 5，}”；

In this query, we use the RLIKE operator to match fields containing at least 5 consecutive numbers. You can modify the query as needed to meet your needs. Please note that this only applies to Hive 0. 13 and later. If you are using an earlier version of Hive, you need to check its documentation to determine how to use regular expressions for matching.