I have a table of invoices with cost identifiers saved in a specific way, non always standard, like below: I would like to find invoices for a specific cost identifier. The structure of the cost is (4 or more digits)+(2 year digits) In Test case: 107621, the desired output would be ID: 2 and 3. SELECT * FROM INVOICES WHERE
Tag: regexp-like
Hive – find 2 characters anywhere in the string/row – RLIKE
How do I get the data for ONLY “_WA” data assigned to “USA_RBB_WA_BU”? However the column I look at has rows that contain _WA and _SA (USA_CA_SAWANT) I used, select…. …
regexp_like that mirrors contains near
I’m trying to speed up a query that uses Contains Near with one that uses regexp_like. The initial Contains Near query takes about 45 minutes to run. Clob Column holds large “documents” and is …
REGEXP_LIKE between number range
Can someone please finalize the code on the below. I only want to look for a 6 digit number range anywhere in the RMK field, between 100000 and 999999 The current code works but is bringing back anything with a number so I’m trying to narrow it down to 6 digits together. I’ve tried a few but no luck. Edit: