Extract rows from a table with regular expression hive sql
Please check the link for the result and table info. I need to query rows with value '343' in Col B with a regular expression . All columns are strings . Also please be kind enough to point any good learning materials in how to write good REGEX in Hive . Thank you
Solution
this will work:
select * from tablename where regexp_like(B,'(.*)(343)(.*)');
hive equivalent is :
select * from tablename where rlike(B,'(.*)(343)(.*)');
- Perl Regex fails to compile looking for \object
- Test if elements in a character string could be numeric
- How to remove all but emojis in a (Javascript) string?
- How to remove all characters from string apart from emoji
- How can I find all matches to a regular expression in Python?
- Zip code validation to exclude some formats
- How to allow specific words using javax.validation.constraints.Pattern?
- Create array of regex matches
- Handling complex parentheses structures to get the expected data
- Catching optional content just after a new line
- Regex to compare strings with Umlaut and non-Umlaut variations
- How can I check when there are only opening or closing quotes in PHP to make replacements?
- Regular Expression | Leap Years and More
- Regex date format validation on Java
- How can I replace every instance of a character from 3 groups of characters with just 3 different characters respectively?
- Regex to match 1 or less occurrence of string?
- Getting parts of a URL (Regex)
- Trim trailing spaces before newlines in a single multi-line string in JavaScript
- Only keep this String in Notepad++ (Regex)
- Redirect Youtube channel main page to videos section the proper way using regex
- Regular expression to validate repeating comma-separated groups without trailing comma
- Angular regex validator allows empty value, while the regex clause should demand at least one digit
- Parsing DeepDiff result
- Rewriting HTTP url to HTTPS using regular expression and javascript
- regex to match HTML <p ...> tag starting with a lowercase letter
- String.split() *not* on regular expression?
- How can I find the last occurance of a dot not preceding with a slash?
- How to extract table names and column names from sql query?
- How to use Rust regex on bytes (Vec<u8> or &[u8])?
- How to validate email by whitelist domain regex