Return-Path: 
 <user-return-7343-apmail-hive-user-archive=hive.apache.org@hive.apache.org>
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 0319090D7
	for <apmail-hive-user-archive@www.apache.org>;
 Tue, 17 Jan 2012 02:51:53 +0000 (UTC)
Received: (qmail 87909 invoked by uid 500); 17 Jan 2012 02:51:51 -0000
Delivered-To: apmail-hive-user-archive@hive.apache.org
Received: (qmail 87559 invoked by uid 500); 17 Jan 2012 02:51:45 -0000
Mailing-List: contact user-help@hive.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-help@hive.apache.org>
List-Unsubscribe: <mailto:user-unsubscribe@hive.apache.org>
List-Post: <mailto:user@hive.apache.org>
List-Id: <user.hive.apache.org>
Reply-To: user@hive.apache.org
Delivered-To: mailing list user@hive.apache.org
Received: (qmail 87551 invoked by uid 99); 17 Jan 2012 02:51:43 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 17 Jan 2012 02:51:43 +0000
X-ASF-Spam-Status: No, hits=-0.1 required=5.0
	tests=HTML_MESSAGE,RCVD_IN_DNSWL_MED,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: local policy)
Received: from [122.98.14.32] (HELO kecgate02.infosys.com) (122.98.14.32)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 17 Jan 2012 02:51:36 +0000
X-TM-IMSS-Message-ID: <1d3edaf2000432b7@infosys.com>
Received: from blrkechub04.ad.infosys.com ([10.66.236.44]) by infosys.com
 ([122.98.14.32]) with ESMTP (TREND IMSS SMTP Service 7.1) id 1d3edaf2000432b7
 ; Tue, 17 Jan 2012 08:18:57 +0530
Received: from BLRKECHUB05.ad.infosys.com (10.66.236.45) by
 blrkechub04.ad.infosys.com (10.66.236.44) with Microsoft SMTP Server (TLS) id
 8.2.176.0; Tue, 17 Jan 2012 08:21:13 +0530
Received: from BLRKECMBX08.ad.infosys.com ([10.66.236.81]) by
 BLRKECHUB05.ad.infosys.com ([10.66.236.45]) with mapi; Tue, 17 Jan 2012
 08:21:13 +0530
From: Krishnan Krishnamoorthy <Krishnan_K@infosys.com>
To: "user@hive.apache.org" <user@hive.apache.org>
CC: "kkrishnan88@gmail.com" <kkrishnan88@gmail.com>
Date: Tue, 17 Jan 2012 08:21:12 +0530
Subject: FW: Hive_Datatypes_Complex
Thread-Topic: Hive_Datatypes_Complex
Thread-Index: AczUwprK1R2NMyrsQ66sSl17c80/XgAADy2w
Message-ID: 
 <A89BEF41E94FCA4CA9DF6418EFFA2604047772293B@BLRKECMBX08.ad.infosys.com>
Accept-Language: en-US
Content-Language: en-US
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
acceptlanguage: en-US
Content-Type: multipart/alternative;
	boundary="_000_A89BEF41E94FCA4CA9DF6418EFFA2604047772293BBLRKECMBX08ad_"
MIME-Version: 1.0

--_000_A89BEF41E94FCA4CA9DF6418EFFA2604047772293BBLRKECMBX08ad_
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable



Hi,

I've been trying to find out how to create data files for input into tabl=
es having the following descriptions :


*         CREATE TABLE complex_array (
col1 ARRAY<INT>);


*         CREATE TABLE complex_map (
col2 MAP<STRING, INT>);


*         CREATE TABLE complex_struct (
col3 STRUCT<a:STRING, b:INT, c:DOUBLE>);


I'd be really grateful if anyone could create sample data files (having a=
t least 2-3rows) for each of the tables so that I can load them into thes=
e tables.


Thanks and Regards,
Krishnan K
Infosys Limited | Bangalore | India
Direct : +91 80 39137352 | Extn: 51693 | Mobile: +91 7411822886


**************** CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended sol=
ely 
for the use of the addressee(s). If you are not the intended recipient, p=
lease 
notify the sender by e-mail and delete the original message. Further, you=
 are not 
to copy, disclose, or distribute this e-mail or its contents to any other=
 person and 
any such actions are unlawful. This e-mail may contain viruses. Infosys h=
as taken 
every reasonable precaution to minimize this risk, but is not liable for =
any damage 
you may sustain as a result of any virus in this e-mail. You should carry=
 out your 
own virus checks before opening the e-mail or attachment. Infosys reserve=
s the 
right to monitor and review the content of all messages sent to or from t=
his e-mail 
address. Messages sent to or from this e-mail address may be stored on th=
e 
Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***

--_000_A89BEF41E94FCA4CA9DF6418EFFA2604047772293BBLRKECMBX08ad_
Content-Type: text/html;
	charset="utf-8"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-mi=
crosoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:wo=
rd" xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" xmlns=3D=
"http://www.w3.org/TR/REC-html40"><head><META HTTP-EQUIV=3D"Content-Type"=
 CONTENT=3D"text/html; charset=3Dus-ascii"><meta name=3DGenerator content=
=3D"Microsoft Word 14 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
=09{font-family:Wingdings;
=09panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
=09{font-family:Wingdings;
=09panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
=09{font-family:Calibri;
=09panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
=09{font-family:TheSansMonoCd-W5Regular;
=09panose-1:0 0 0 0 0 0 0 0 0 0;}
@font-face
=09{font-family:"\@TheSansMonoCd-W5Regular";
=09panose-1:0 0 0 0 0 0 0 0 0 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
=09{margin:0in;
=09margin-bottom:.0001pt;
=09font-size:11.0pt;
=09font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
=09{mso-style-priority:99;
=09color:blue;
=09text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
=09{mso-style-priority:99;
=09color:purple;
=09text-decoration:underline;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
=09{mso-style-priority:34;
=09margin-top:0in;
=09margin-right:0in;
=09margin-bottom:0in;
=09margin-left:.5in;
=09margin-bottom:.0001pt;
=09font-size:11.0pt;
=09font-family:"Calibri","sans-serif";}
span.EmailStyle18
=09{mso-style-type:personal;
=09font-family:"Calibri","sans-serif";
=09color:windowtext;}
span.EmailStyle19
=09{mso-style-type:personal-reply;
=09font-family:"Calibri","sans-serif";
=09color:#1F497D;}
.MsoChpDefault
=09{mso-style-type:export-only;
=09font-size:10.0pt;}
@page WordSection1
=09{size:8.5in 11.0in;
=09margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
=09{page:WordSection1;}
/* List Definitions */
@list l0
=09{mso-list-id:335233855;
=09mso-list-type:hybrid;
=09mso-list-template-ids:-1291575102 67698689 67698691 67698693 67698689 =
67698691 67698693 67698689 67698691 67698693;}
@list l0:level1
=09{mso-level-number-format:bullet;
=09mso-level-text:\F0B7;
=09mso-level-tab-stop:none;
=09mso-level-number-position:left;
=09text-indent:-.25in;
=09font-family:Symbol;}
@list l0:level2
=09{mso-level-number-format:bullet;
=09mso-level-text:o;
=09mso-level-tab-stop:none;
=09mso-level-number-position:left;
=09text-indent:-.25in;
=09font-family:"Courier New";}
@list l0:level3
=09{mso-level-number-format:bullet;
=09mso-level-text:\F0A7;
=09mso-level-tab-stop:none;
=09mso-level-number-position:left;
=09text-indent:-.25in;
=09font-family:Wingdings;}
@list l0:level4
=09{mso-level-number-format:bullet;
=09mso-level-text:\F0B7;
=09mso-level-tab-stop:none;
=09mso-level-number-position:left;
=09text-indent:-.25in;
=09font-family:Symbol;}
@list l0:level5
=09{mso-level-number-format:bullet;
=09mso-level-text:o;
=09mso-level-tab-stop:none;
=09mso-level-number-position:left;
=09text-indent:-.25in;
=09font-family:"Courier New";}
@list l0:level6
=09{mso-level-number-format:bullet;
=09mso-level-text:\F0A7;
=09mso-level-tab-stop:none;
=09mso-level-number-position:left;
=09text-indent:-.25in;
=09font-family:Wingdings;}
@list l0:level7
=09{mso-level-number-format:bullet;
=09mso-level-text:\F0B7;
=09mso-level-tab-stop:none;
=09mso-level-number-position:left;
=09text-indent:-.25in;
=09font-family:Symbol;}
@list l0:level8
=09{mso-level-number-format:bullet;
=09mso-level-text:o;
=09mso-level-tab-stop:none;
=09mso-level-number-position:left;
=09text-indent:-.25in;
=09font-family:"Courier New";}
@list l0:level9
=09{mso-level-number-format:bullet;
=09mso-level-text:\F0A7;
=09mso-level-tab-stop:none;
=09mso-level-number-position:left;
=09text-indent:-.25in;
=09font-family:Wingdings;}
ol
=09{margin-bottom:0in;}
ul
=09{margin-bottom:0in;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]--></head><body lang=3DEN-US link=3Dblue v=
link=3Dpurple><div class=3DWordSection1><p class=3DMsoNormal><o:p>&nbsp;<=
/o:p></p><p class=3DMsoNormal><o:p>&nbsp;</o:p></p><p class=3DMsoNormal>H=
i,<o:p></o:p></p><p class=3DMsoNormal><o:p>&nbsp;</o:p></p><p class=3DMso=
Normal>I&#8217;ve been trying to find out how to create data files for <i=
>input</i> into tables having the following descriptions :<o:p></o:p></p>=
<p class=3DMsoNormal style=3D'text-autospace:none'><span style=3D'font-si=
ze:8.0pt;font-family:TheSansMonoCd-W5Regular'><o:p>&nbsp;</o:p></span></p=
><p class=3DMsoListParagraph style=3D'text-indent:-.25in;mso-list:l0 leve=
l1 lfo2;text-autospace:none'><![if !supportLists]><span style=3D'font-fam=
ily:Symbol'><span style=3D'mso-list:Ignore'>&middot;<span style=3D'font:7=
.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
</span></span></span><![endif]>CREATE TABLE complex_array (<o:p></o:p></p=
><p class=3DMsoNormal style=3D'text-indent:.5in;text-autospace:none'>col1=
 ARRAY&lt;INT&gt;);<o:p></o:p></p><p class=3DMsoNormal style=3D'text-auto=
space:none'><o:p>&nbsp;</o:p></p><p class=3DMsoListParagraph style=3D'tex=
t-indent:-.25in;mso-list:l0 level1 lfo2;text-autospace:none'><![if !suppo=
rtLists]><span style=3D'font-family:Symbol'><span style=3D'mso-list:Ignor=
e'>&middot;<span style=3D'font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></span></span><![endif]>CREATE TAB=
LE complex_map (<o:p></o:p></p><p class=3DMsoNormal style=3D'text-indent:=
.5in;text-autospace:none'>col2 MAP&lt;STRING, INT&gt;);<o:p></o:p></p><p =
class=3DMsoNormal style=3D'text-autospace:none'><o:p>&nbsp;</o:p></p><p c=
lass=3DMsoListParagraph style=3D'text-indent:-.25in;mso-list:l0 level1 lf=
o2;text-autospace:none'><![if !supportLists]><span style=3D'font-family:S=
ymbol'><span style=3D'mso-list:Ignore'>&middot;<span style=3D'font:7.0pt =
"Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </spa=
n></span></span><![endif]>CREATE TABLE complex_struct (<o:p></o:p></p><p =
class=3DMsoNormal style=3D'text-indent:.5in;text-autospace:none'>col3 STR=
UCT&lt;a:STRING, b:INT, c:DOUBLE&gt;);<o:p></o:p></p><p class=3DMsoNormal=
 style=3D'text-indent:.5in;text-autospace:none'><o:p>&nbsp;</o:p></p><p c=
lass=3DMsoNormal style=3D'text-autospace:none'><o:p>&nbsp;</o:p></p><p cl=
ass=3DMsoNormal style=3D'text-autospace:none'>I&#8217;d be really gratefu=
l if anyone could create sample data files (having at least 2-3rows) for =
each of the tables so that I can load them into these tables.<o:p></o:p><=
/p><p class=3DMsoNormal style=3D'text-autospace:none'><span style=3D'font=
-size:8.0pt;font-family:TheSansMonoCd-W5Regular'><o:p>&nbsp;</o:p></span>=
</p><p class=3DMsoNormal><o:p>&nbsp;</o:p></p><p class=3DMsoNormal><b><sp=
an style=3D'color:#76923C'>Thanks and Regards,<o:p></o:p></span></b></p><=
p class=3DMsoNormal><span style=3D'color:#1F497D'>Krishnan K</span><span =
style=3D'color:#404040'><o:p></o:p></span></p><p class=3DMsoNormal><span =
lang=3DEN-NZ style=3D'color:#5F5F5F'>Infosys Limited</span><span lang=3DE=
N-NZ style=3D'color:#76923C'> </span><b><span lang=3DEN-NZ style=3D'color=
:#E36C0A'>|</span></b><span lang=3DEN-NZ style=3D'color:#1F497D'> </span>=
<span lang=3DEN-NZ style=3D'color:#595959'>Bangalore</span><b><span lang=
=3DEN-NZ style=3D'color:#E36C0A'> </span></b><b><span lang=3DEN-NZ style=
=3D'color:#FF9900'>|</span></b><span lang=3DEN-NZ style=3D'color:#5F5F5F'=
> India&nbsp;&nbsp;<o:p></o:p></span></p><p class=3DMsoNormal><span lang=
=3DEN-NZ style=3D'color:#5F5F5F'>Direct&nbsp;: +91 80 39137352 </span><b>=
<span lang=3DEN-NZ style=3D'color:#FF9900'>| </span></b><span lang=3DEN-N=
Z style=3D'color:#5F5F5F'>Extn: 51693 </span><b><span lang=3DEN-NZ style=
=3D'color:#FF9900'>|</span></b><span lang=3DEN-NZ style=3D'color:#5F5F5F'=
> Mobile: +91 7411822886</span><span style=3D'color:#632423'><o:p></o:p><=
/span></p><p class=3DMsoNormal><o:p>&nbsp;</o:p></p></div></body></html>
<table><tr><td bgcolor=3D#ffffff><font color=3D#000000><pre>*************=
*** CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended sol=
ely 
for the use of the addressee(s). If you are not the intended recipient, p=
lease 
notify the sender by e-mail and delete the original message. Further, you=
 are not 
to copy, disclose, or distribute this e-mail or its contents to any other=
 person and 
any such actions are unlawful. This e-mail may contain viruses. Infosys h=
as taken 
every reasonable precaution to minimize this risk, but is not liable for =
any damage 
you may sustain as a result of any virus in this e-mail. You should carry=
 out your 
own virus checks before opening the e-mail or attachment. Infosys reserve=
s the 
right to monitor and review the content of all messages sent to or from t=
his e-mail 
address. Messages sent to or from this e-mail address may be stored on th=
e 
Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***</pre></font></td>=
</tr></table>

--_000_A89BEF41E94FCA4CA9DF6418EFFA2604047772293BBLRKECMBX08ad_--