Mailing-List: contact issues-help@drill.incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@drill.incubator.apache.org
Date: Mon, 29 Sep 2014 01:45:34 +0000 (UTC)
From: "Neeraja (JIRA)" <jira@apache.org>
To: issues@drill.incubator.apache.org
Message-ID: <JIRA.12744579.1411955097000.142983.1411955134193@Atlassian.JIRA>
In-Reply-To: <JIRA.12744579.1411955097000@Atlassian.JIRA>
References: <JIRA.12744579.1411955097000@Atlassian.JIRA>
 <JIRA.12744579.1411955097599@arcas>
Subject: [jira] [Updated] (DRILL-1461) Repeated_Count function fails on
 array of strings
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable


     [ https://issues.apache.org/jira/browse/DRILL-1461?page=3Dcom.atlassia=
n.jira.plugin.system.issuetabpanels:all-tabpanel ]

Neeraja updated DRILL-1461:
---------------------------
    Summary: Repeated_Count function fails on array of strings  (was: Repea=
ted_Count function fails on array strings)

> Repeated_Count function fails on array of strings
> -------------------------------------------------
>
>                 Key: DRILL-1461
>                 URL: https://issues.apache.org/jira/browse/DRILL-1461
>             Project: Apache Drill
>          Issue Type: Bug
>    Affects Versions: 0.5.0
>            Reporter: Neeraja
>            Priority: Critical
>
> Repeated_count function fails on an array of strings.
> Here are the queries/error and the sample JSON records..
> ----------
> 0: jdbc:drill:zk=3Dlocal> select b.categories
> . . . . . . . . . . . >  from dfs.`/users/nrentachintala/Downloads/yelp_d=
ataset_challenge_academic_dataset/yelp_academic_dataset_business.json` b li=
mit 3;
> +------------+
> | categories |
> +------------+
> | ["Doctors","Health & Medical"] |
> | ["Restaurants"] |
> | ["American (Traditional)","Restaurants"] |
> +------------+
> 0: jdbc:drill:zk=3Dlocal> select b.name, repeated_count(b.categories) fro=
m dfs.`/users/nrentachintala/Downloads/yelp_dataset_challenge_academic_data=
set/yelp_academic_dataset_business.json` b;
> Query failed: Screen received stop request sent. Line 36, Column 12: "buf=
fer" is neither a method, a field, nor a member class of "org.apache.drill.=
exec.expr.holders.RepeatedVarCharHolder" [03bf83e0-d927-4087-8b32-28afdfcca=
13d]
> ----------
> {"business_id": "vcNAWiLM4dR7D2nwwJ7nCA", "full_address": "4840 E Indian =
School Rd\nSte 101\nPhoenix, AZ 85018", "hours": {"Tuesday": {"close": "17:=
00", "open": "08:00"}, "Friday": {"close": "17:00", "open": "08:00"}, "Mond=
ay": {"close": "17:00", "open": "08:00"}, "Wednesday": {"close": "17:00", "=
open": "08:00"}, "Thursday": {"close": "17:00", "open": "08:00"}}, "open": =
true, "categories": ["Doctors", "Health & Medical"], "city": "Phoenix", "re=
view_count": 7, "name": "Eric Goldberg, MD", "neighborhoods": [], "longitud=
e": -111.98375799999999, "state": "AZ", "stars": 3.5, "latitude": 33.499313=
000000001, "attributes": {"By Appointment Only": true}, "type": "business"}
> {"business_id": "JwUE5GmEO-sH1FuwJgKBlQ", "full_address": "6162 US Highwa=
y 51\nDe Forest, WI 53532", "hours": {}, "open": true, "categories": ["Rest=
aurants"], "city": "De Forest", "review_count": 26, "name": "Pine Cone Rest=
aurant", "neighborhoods": [], "longitude": -89.335843999999994, "state": "W=
I", "stars": 4.0, "latitude": 43.238892999999997, "attributes": {"Take-out"=
: true, "Good For": {"dessert": false, "latenight": false, "lunch": true, "=
dinner": false, "breakfast": false, "brunch": false}, "Caters": false, "Noi=
se Level": "average", "Takes Reservations": false, "Delivery": false, "Ambi=
ence": {"romantic": false, "intimate": false, "touristy": false, "hipster":=
 false, "divey": false, "classy": false, "trendy": false, "upscale": false,=
 "casual": false}, "Parking": {"garage": false, "street": false, "validated=
": false, "lot": true, "valet": false}, "Has TV": true, "Outdoor Seating": =
false, "Attire": "casual", "Alcohol": "none", "Waiter Service": true, "Acce=
pts Credit Cards": true, "Good for Kids": true, "Good For Groups": true, "P=
rice Range": 1}, "type": "business"}
> {"business_id": "uGykseHzyS5xAMWoN6YUqA", "full_address": "505 W North St=
\nDe Forest, WI 53532", "hours": {"Monday": {"close": "22:00", "open": "06:=
00"}, "Tuesday": {"close": "22:00", "open": "06:00"}, "Friday": {"close": "=
22:00", "open": "06:00"}, "Wednesday": {"close": "22:00", "open": "06:00"},=
 "Thursday": {"close": "22:00", "open": "06:00"}, "Sunday": {"close": "21:0=
0", "open": "06:00"}, "Saturday": {"close": "22:00", "open": "06:00"}}, "op=
en": true, "categories": ["American (Traditional)", "Restaurants"], "city":=
 "De Forest", "review_count": 16, "name": "Deforest Family Restaurant", "ne=
ighborhoods": [], "longitude": -89.353437, "state": "WI", "stars": 4.0, "la=
titude": 43.252267000000003, "attributes": {"Take-out": true, "Good For": {=
"dessert": false, "latenight": false, "lunch": false, "dinner": false, "bre=
akfast": false, "brunch": true}, "Caters": false, "Noise Level": "quiet", "=
Takes Reservations": false, "Delivery": false, "Parking": {"garage": false,=
 "street": false, "validated": false, "lot": true, "valet": false}, "Has TV=
": true, "Outdoor Seating": false, "Attire": "casual", "Ambience": {"romant=
ic": false, "intimate": false, "touristy": false, "hipster": false, "divey"=
: false, "classy": false, "trendy": false, "upscale": false, "casual": true=
}, "Waiter Service": true, "Accepts Credit Cards": true, "Good for Kids": t=
rue, "Good For Groups": true, "Price Range": 1}, "type": "business"}


--
This message was sent by Atlassian JIRA
(v6.3.4#6332)