Reputation: 46
I am new to Apache Phoenix,
is it possible to query an Hbase table using "regex" in Phoenix. My Apache Phoenix sits on top of Hbase (No MapReduce). For example, I need to query names that start with Er*
Paulo
Upvotes: 1
Views: 969
Reputation: 53
yes u can use Apache Phoenix for the regex matches as suggested above. In order to structure your queries kindly follow the grammar page of phoenix at http://phoenix.apache.org/language/index.html . Its a concise explanation of how to use phoenix. Kindly go through the hints to be used also on the same page as you can very well optimise ur queries using it.
Upvotes: 1
Reputation: 1126
Yes, you can do query for regular expression matches in Phoenix. Look into string functions on this page: http://phoenix.apache.org/language/functions.html
Upvotes: 2