[jira] Commented: (HIVE-236) RLIKE/REGEXP should allow matching partial strings
[ https://issues.apache.org/jira/browse/HIVE-236?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12762334#action_12762334 ] Zheng Shao commented on HIVE-236: - Looks great! Will commit after testing. > RLIKE/REGEXP should allow matching partial strings > -- > > Key: HIVE-236 > URL: https://issues.apache.org/jira/browse/HIVE-236 > Project: Hadoop Hive > Issue Type: Bug > Components: Query Processor >Reporter: Zheng Shao >Assignee: Paul Yang > Attachments: HIVE-236.1.patch, HIVE-236.2.patch, HIVE-236.3.patch > > > The current behavior is that the regexp needs to match the whole string. > But from mysql: ( > http://dev.mysql.com/doc/refman/5.0/en/regexp.html#operator_regexp ) > mysql> SELECT 'fofo' REGEXP '^fo'; -> 1 > We need to make it work the same way as MySQL. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
[jira] Commented: (HIVE-236) RLIKE/REGEXP should allow matching partial strings
[ https://issues.apache.org/jira/browse/HIVE-236?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12762314#action_12762314 ] Zheng Shao commented on HIVE-236: - @HIVE-236.2.patch: The warning should not be outputted for every call - we had seen problems with too many repeated log messages that filled up the log file. Can you add a boolean variable "warned", so that we only warn once? Also, it may help if you put all the test cases in a single query. That helps to reduce the time of running tests. > RLIKE/REGEXP should allow matching partial strings > -- > > Key: HIVE-236 > URL: https://issues.apache.org/jira/browse/HIVE-236 > Project: Hadoop Hive > Issue Type: Bug > Components: Query Processor >Reporter: Zheng Shao >Assignee: Paul Yang > Attachments: HIVE-236.1.patch, HIVE-236.2.patch > > > The current behavior is that the regexp needs to match the whole string. > But from mysql: ( > http://dev.mysql.com/doc/refman/5.0/en/regexp.html#operator_regexp ) > mysql> SELECT 'fofo' REGEXP '^fo'; -> 1 > We need to make it work the same way as MySQL. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
[jira] Commented: (HIVE-236) RLIKE/REGEXP should allow matching partial strings
[ https://issues.apache.org/jira/browse/HIVE-236?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12761787#action_12761787 ] Paul Yang commented on HIVE-236: Not quite ready - need to update udf1.q > RLIKE/REGEXP should allow matching partial strings > -- > > Key: HIVE-236 > URL: https://issues.apache.org/jira/browse/HIVE-236 > Project: Hadoop Hive > Issue Type: Bug > Components: Query Processor >Reporter: Zheng Shao >Assignee: Paul Yang > Attachments: HIVE-236.1.patch > > > The current behavior is that the regexp needs to match the whole string. > But from mysql: ( > http://dev.mysql.com/doc/refman/5.0/en/regexp.html#operator_regexp ) > mysql> SELECT 'fofo' REGEXP '^fo'; -> 1 > We need to make it work the same way as MySQL. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
[jira] Commented: (HIVE-236) RLIKE/REGEXP should allow matching partial strings
[ https://issues.apache.org/jira/browse/HIVE-236?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12761635#action_12761635 ] Namit Jain commented on HIVE-236: - The changes look good - will commit if the tests pass > RLIKE/REGEXP should allow matching partial strings > -- > > Key: HIVE-236 > URL: https://issues.apache.org/jira/browse/HIVE-236 > Project: Hadoop Hive > Issue Type: Bug > Components: Query Processor >Reporter: Zheng Shao >Assignee: Paul Yang > Attachments: HIVE-236.1.patch > > > The current behavior is that the regexp needs to match the whole string. > But from mysql: ( > http://dev.mysql.com/doc/refman/5.0/en/regexp.html#operator_regexp ) > mysql> SELECT 'fofo' REGEXP '^fo'; -> 1 > We need to make it work the same way as MySQL. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.