Return-Path: X-Original-To: apmail-hive-user-archive@www.apache.org Delivered-To: apmail-hive-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id B62927BBB for ; Wed, 5 Oct 2011 00:46:40 +0000 (UTC) Received: (qmail 91469 invoked by uid 500); 5 Oct 2011 00:46:40 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 91439 invoked by uid 500); 5 Oct 2011 00:46:40 -0000 Mailing-List: contact user-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hive.apache.org Delivered-To: mailing list user@hive.apache.org Received: (qmail 91431 invoked by uid 99); 5 Oct 2011 00:46:40 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 05 Oct 2011 00:46:40 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (athena.apache.org: local policy) Received: from [209.85.216.169] (HELO mail-qy0-f169.google.com) (209.85.216.169) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 05 Oct 2011 00:46:32 +0000 Received: by qyl38 with SMTP id 38so4362260qyl.14 for ; Tue, 04 Oct 2011 17:46:10 -0700 (PDT) MIME-Version: 1.0 Received: by 10.229.176.40 with SMTP id bc40mr1448350qcb.240.1317775570455; Tue, 04 Oct 2011 17:46:10 -0700 (PDT) Received: by 10.229.220.139 with HTTP; Tue, 4 Oct 2011 17:46:10 -0700 (PDT) X-Originating-IP: [98.198.171.77] In-Reply-To: <4F6B25AFFFCAFE44B6259A412D5F9B10395A690A@ExchMBX104.netflix.com> References: <4F6B25AFFFCAFE44B6259A412D5F9B10395A690A@ExchMBX104.netflix.com> Date: Tue, 4 Oct 2011 19:46:10 -0500 Message-ID: Subject: Re: How does COLLECTION ITEMS work in Hive? From: Mark Kerzner To: user@hive.apache.org Content-Type: multipart/alternative; boundary=0016e6d369e1c54ce904ae8288b8 --0016e6d369e1c54ce904ae8288b8 Content-Type: text/plain; charset=ISO-8859-1 Thank you, I found very few examples, and this old Jira helped the best https://issues.apache.org/jira/browse/HIVE-15 On Tue, Oct 4, 2011 at 7:23 PM, Steven Wong wrote: > COLLECTION ITEMS refers to the ARRAY column type. For more info on arrays, > see:**** > > ** ** > > https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL**** > > https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF**** > > ** ** > > ** ** > > *From:* Mark Kerzner [mailto:mark.kerzner@shmsoft.com] > *Sent:* Tuesday, October 04, 2011 9:28 AM > *To:* Hive user > *Subject:* How does COLLECTION ITEMS work in Hive?**** > > ** ** > > Hi, expert, > > I see this clause in CREATE TABLE --**** > > ** ** > > COLLECTION ITEMS TERMINATED BY > > How does it work? Does Hive create a new row for each collection item, repeating the other elements? If not, how does it treat collection items? > > Thank you, > Mark**** > > ** ** > --0016e6d369e1c54ce904ae8288b8 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Thank you, I found very few examples, and this old Jira helped the best
=
https://issue= s.apache.org/jira/browse/HIVE-15

On T= ue, Oct 4, 2011 at 7:23 PM, Steven Wong <swong@netflix.com> wrote:

COLLECTION ITEMS refers to the= ARRAY column type. For more info on arrays, see:

=A0
https://cwiki.ap= ache.org/confluence/display/Hive/LanguageManual+DDL

https://cwiki.apache.org/confluence/display/Hive= /LanguageManual+UDF

=A0
=A0
From: Mark Kerzner [mailto:mark.kerzner@shmsoft.com]
Sent: Tuesday, = October 04, 2011 9:28 AM
To: Hive user
Subject: How does COLLECTION ITEMS work in H= ive?
=A0
Hi, expert,

I see this clause in CREATE TABLE --=A0
COLLECTION ITEMS TERMINATED BY 

How does it work? Does Hive crea=
te a new row for each collection item, repeating the other elements? If not=
, how does it treat collection items?


Thank you,
Mark
= =A0

--0016e6d369e1c54ce904ae8288b8--