Mailing-List: contact hive-user-help@hadoop.apache.org; run by ezmlm
Precedence: bulk
Reply-To: hive-user@hadoop.apache.org
Received-SPF: pass (athena.apache.org: domain of rmurthy@facebook.com
 designates 69.63.179.25 as permitted sender)
From: Raghu Murthy <rmurthy@facebook.com>
To: "hive-user@hadoop.apache.org" <hive-user@hadoop.apache.org>
Date: Mon, 10 Aug 2009 09:21:32 -0700
Subject: Re: ADD FILE using JDBC
Thread-Topic: ADD FILE using JDBC
Thread-Index: AcoZmMqdsDSc1rMBQcGPFMT/gASm/QAPdSxF
Message-ID: <C6A5971C.285EF%rsm@facebook.com>
In-Reply-To: <794f042d0908100158s2cc7760ftf39eee53dedd300f@mail.gmail.com>
Accept-Language: en-US
Content-Language: en
acceptlanguage: en-US
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0

I mean, don't use the 'ADD' statement. Just directly specify the path in
your SELECT statement.

SELECT TRANSFORM(a,b) USING '/path/to/script' AS c,d
FROM table


On 8/10/09 1:58 AM, "Saurabh Nanda" <saurabhnanda@gmail.com> wrote:

>=20
>> As a work around, can you copy the file locally on the server and use th=
e
>> complete path (local to the server) in the query?
>=20
> The file is available locally to the machine running=A0 "./bin/hive --ser=
vice
> hiveserver" Do you want me to try using the full file path? However, the =
error
> message doesn't say "file not found". It says "cannot recognize input 'ad=
d'"
>=20
> Saurabh.