RLike and REGEXP showing all records in empty regex
Posted by anubhavtarar on Dec 20, 2016; 10:20am
URL: http://apache-carbondata-dev-mailing-list-archive.168.s1.nabble.com/RLike-and-REGEXP-showing-all-records-in-empty-regex-tp4736.html
When I'm trying to run RLIKE with empty regex, it is showing me all the records instead of no record.
select * from knolders where age RLIKE '';
It is behaving in a similar manner for REGEXP operator.
thats beacuse it is executing in spark sql this behaviour is different from hive can we write our own parser for it