Mailing-List: contact dev-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
Received-SPF: pass (nike.apache.org: domain of pandeesh@me.com designates
 17.172.220.238 as permitted sender)
References: 
 <OFFE406E91.C6E40C0E-ON65257B90.0032F07A-65257B90.003360D2@polarisft.com>
MIME-version: 1.0 (1.0)
In-reply-to: 
 <OFFE406E91.C6E40C0E-ON65257B90.0032F07A-65257B90.003360D2@polarisft.com>
Content-type: text/plain; charset=us-ascii
Content-transfer-encoding: quoted-printable
Message-id: <EFD81405-4AE8-427A-AA30-0CFA0C5D56EF@me.com>
Cc: "dev@hive.apache.org" <dev@hive.apache.org>,
 "user@hive.apache.org" <user@hive.apache.org>
From: pandeeswaran bhoopathy <pandeesh@me.com>
Subject: Re: Storing data into hive table having columns from multiple files
Date: Thu, 20 Jun 2013 20:40:21 +0530
To: "dev@hive.apache.org" <dev@hive.apache.org>

Do you mean the merge operation?

Sent from my iPad

On 20-Jun-2013, at 2:51 PM, varaprasad.bheri@polarisFT.com wrote:

> Hi All,
>=20
> I have a query on a scenario which is below:
>=20
> There are 2 files "file1", "file2". And a hive table "test" which is creat=
ed with 15 columns with "," delimiter.
> "file1" contains 25 columns and "file2" contains 15 columns having seperat=
or as ",":
>=20
> But, out of 25 columns, 10 columns of data from file1 are inserted to hive=
 table "test"
> and out of 15 columns, 5 columns of data from file2 are inserted to the sa=
me hive table "test"
> (lets forget about the remaining 15 columns from file1 and 10 columns from=
 file2)
>=20
> First, "file1" is processed and then "file2" is processed.
> When "file1" is processed, 10 columns gets inserted into "test" table for a=
 row.
> When "file2" is processed, 5 columns have to be inserted into "test" table=
 of the same row.
>=20
> Could you please help me on how to insert the 5 columns of file2 to the sa=
me row in "test" table?
> (which has 10 columns of data inserted from file1 for that row)
>=20
>=20
> Thanks & Regards,
> Varaprasada Reddy
>=20
>=20
> This e-Mail may contain proprietary and confidential information and is se=
nt for the intended recipient(s) only.  If by an addressing or transmission e=
rror this mail has been misdirected to you, you are requested to delete this=
 mail immediately. You are also hereby notified that any use, any form of re=
production, dissemination, copying, disclosure, modification, distribution a=
nd/or publication of this e-mail message, contents or its attachment other t=
han by its intended recipient/s is strictly prohibited.
>=20
> Visit us at http://www.polarisFT.com