Return-Path: X-Original-To: apmail-drill-issues-archive@minotaur.apache.org Delivered-To: apmail-drill-issues-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 18AE2C790 for ; Wed, 7 Jan 2015 19:45:34 +0000 (UTC) Received: (qmail 75177 invoked by uid 500); 7 Jan 2015 19:45:35 -0000 Delivered-To: apmail-drill-issues-archive@drill.apache.org Received: (qmail 74990 invoked by uid 500); 7 Jan 2015 19:45:35 -0000 Mailing-List: contact issues-help@drill.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@drill.apache.org Delivered-To: mailing list issues@drill.apache.org Received: (qmail 74841 invoked by uid 99); 7 Jan 2015 19:45:34 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 07 Jan 2015 19:45:34 +0000 Date: Wed, 7 Jan 2015 19:45:34 +0000 (UTC) From: "Venkata krishnan Sowrirajan (JIRA)" To: issues@drill.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Updated] (DRILL-1757) Add support for wildcards within REPEATED_CONTAINS MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/DRILL-1757?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Venkata krishnan Sowrirajan updated DRILL-1757: ----------------------------------------------- Attachment: DRILL-1757.patch > Add support for wildcards within REPEATED_CONTAINS > -------------------------------------------------- > > Key: DRILL-1757 > URL: https://issues.apache.org/jira/browse/DRILL-1757 > Project: Apache Drill > Issue Type: New Feature > Components: Functions - Drill > Affects Versions: 0.6.0 > Environment: 0.7.0 on MacOSX, embedded mode > Reporter: Bob Rumsby > Assignee: Venkata krishnan Sowrirajan > Fix For: Future > > Attachments: DRILL-1757.patch > > > REPEATED_CONTAINS does not seem to support the % or * wildcard. If this is expected behavior (I assume not), it needs to be documented. > 0: jdbc:drill:zk=local> select name, repeated_contains(categories, 'Doctors') from dfs.yelp.`yelp_academic_dataset_business.json` limit 1; > +------------+------------+ > | name | EXPR$1 | > +------------+------------+ > | Eric Goldberg, MD | true | > +------------+------------+ > 1 row selected (0.087 seconds) > 0: jdbc:drill:zk=local> select name, repeated_contains(categories, 'Doc%') from dfs.yelp.`yelp_academic_dataset_business.json` limit 1; > +------------+------------+ > | name | EXPR$1 | > +------------+------------+ > | Eric Goldberg, MD | false | > +------------+------------+ > 1 row selected (0.093 seconds) > 0: jdbc:drill:zk=local> select name, repeated_contains(categories, 'Doc*') from dfs.yelp.`yelp_academic_dataset_business.json` limit 1; > +------------+------------+ > | name | EXPR$1 | > +------------+------------+ > | Eric Goldberg, MD | false | > +------------+------------+ > 1 row selected (0.09 seconds) -- This message was sent by Atlassian JIRA (v6.3.4#6332)