Return-Path: Delivered-To: apmail-hadoop-hive-user-archive@minotaur.apache.org Received: (qmail 87093 invoked from network); 10 Aug 2009 07:38:15 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 10 Aug 2009 07:38:15 -0000 Received: (qmail 12488 invoked by uid 500); 10 Aug 2009 07:38:21 -0000 Delivered-To: apmail-hadoop-hive-user-archive@hadoop.apache.org Received: (qmail 12445 invoked by uid 500); 10 Aug 2009 07:38:21 -0000 Mailing-List: contact hive-user-help@hadoop.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: hive-user@hadoop.apache.org Delivered-To: mailing list hive-user@hadoop.apache.org Received: (qmail 12436 invoked by uid 99); 10 Aug 2009 07:38:21 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 10 Aug 2009 07:38:21 +0000 X-ASF-Spam-Status: No, hits=-4.0 required=10.0 tests=RCVD_IN_DNSWL_MED,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of rmurthy@facebook.com designates 69.63.179.25 as permitted sender) Received: from [69.63.179.25] (HELO mailout-snc1.facebook.com) (69.63.179.25) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 10 Aug 2009 07:38:13 +0000 Received: from mail.thefacebook.com (intlb01.snat.snc1.facebook.com [10.128.203.15] (may be forged)) by pp-master.snc1.tfbnw.net (8.14.1/8.14.1) with ESMTP id n7A7bhTs023564 (version=TLSv1/SSLv3 cipher=RC4-MD5 bits=128 verify=NOT) for ; Mon, 10 Aug 2009 00:37:43 -0700 Received: from SC-MBXC1.TheFacebook.com ([192.168.18.100]) by sc-hub01.TheFacebook.com ([192.168.18.104]) with mapi; Mon, 10 Aug 2009 00:37:51 -0700 From: Raghu Murthy To: "hive-user@hadoop.apache.org" Date: Mon, 10 Aug 2009 00:37:47 -0700 Subject: Re: ADD FILE using JDBC Thread-Topic: ADD FILE using JDBC Thread-Index: AcoZeT86isyGjO+IQeyDpGQC/kR2ngAFDVQj Message-ID: In-Reply-To: <794f042d0908092212q56228ee9m9ed40e3d50d211eb@mail.gmail.com> Accept-Language: en-US Content-Language: en X-MS-Has-Attach: X-MS-TNEF-Correlator: acceptlanguage: en-US Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-Proofpoint-Virus-Version: vendor=fsecure engine=1.12.8161:2.4.5,1.2.40,4.0.166 definitions=2009-08-10_02:2009-07-24,2009-08-10,2009-08-09 signatures=0 X-Proofpoint-Spam-Details: rule=notspam policy=default score=0 spamscore=0 ipscore=0 phishscore=0 bulkscore=0 adultscore=0 classifier=spam adjust=0 reason=mlx engine=5.0.0-0907200000 definitions=main-0908100006 X-Virus-Checked: Checked by ClamAV on apache.org As a work around, can you copy the file locally on the server and use the complete path (local to the server) in the query? On 8/9/09 10:12 PM, "Saurabh Nanda" wrote: > Is the "add file" command not supported in the JDBC API? I need to use it= for > subsequent custom map/reduce scripts in various queries. The file is avai= lable > locally to the Hive server. >=20 > 09/08/10 10:40:00 INFO service.HiveServer: Running the query: add file > parse_logs.pl; > 09/08/10 10:40:00 INFO ql.Driver: Starting command: add file parse_logs.p= l; > 09/08/10 10:40:00 INFO parse.ParseDriver: Parsing command: add file > parse_logs.pl; > FAILED: Parse Error: line 1:0 cannot recognize input 'add' >=20 > 09/08/10 10:40:01 ERROR ql.Driver: FAILED: Parse Error: line 1:0 cannot > recognize input 'add' >=20 > org.apache.hadoop.hive.ql.parse.ParseException: line 1:0 cannot recognize > input 'add' >=20 > =A0=A0=A0=A0=A0=A0=A0 at=20 > org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:357) > =A0=A0=A0=A0=A0=A0=A0 at org.apache.hadoop.hive.ql.Driver.run(Driver.java= :190) > =A0=A0=A0=A0=A0=A0=A0 at=20 > org.apache.hadoop.hive.service.HiveServer$HiveServerHandler.execute(HiveS= erver > .java:107) > =A0=A0=A0=A0=A0=A0=A0 at=20 > org.apache.hadoop.hive.service.ThriftHive$Processor$execute.process(Thrif= tHive > .java:261) > =A0=A0=A0=A0=A0=A0=A0 at=20 > org.apache.hadoop.hive.service.ThriftHive$Processor.process(ThriftHive.ja= va:24 > 9) > =A0=A0=A0=A0=A0=A0=A0 at=20 > com.facebook.thrift.server.TThreadPoolServer$WorkerProcess.run(Unknown So= urce) > =A0=A0=A0=A0=A0=A0=A0 at=20 > java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor= .java > :886) > =A0=A0=A0=A0=A0=A0=A0 at=20 >=20 java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:= 908> ) > =A0=A0=A0=A0=A0=A0=A0 at java.lang.Thread.run(Thread.java:619) >=20 > Saurabh.