Mailing-List: contact user-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hive.apache.org
Received-SPF: pass (athena.apache.org: domain of kiteraddict@googlemail.com
 designates 209.85.161.48 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=googlemail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type:content-transfer-encoding;
        b=itqssYlienAkzzm+UBX3cjR+mHWjYqXXi90UHRV3naKWAawB38WRqbtz9loFYBUPQ9
         EW2VJbvOT0zBhtY0CyPj6oFk9bRYrCJ3uCuasfMUKp2IssNkic6G6kstjonVlA4IMAqZ
         iHApBb5FL2WIbhGMRmDd8OOgwOXJqPQ/GikUg=
MIME-Version: 1.0
In-Reply-To: <AANLkTinWAjnTMk0FO4nNnkZyTG+F_Qc7BtZG3hQxdJAL@mail.gmail.com>
References: <AANLkTinDOx-TRnPYPZjmyikD9wWUg09HE68V+kJO5S_n@mail.gmail.com>
	<AANLkTik12MNKrdTmbccu4NrJiuO311OkNTa6XAsU-+=Z@mail.gmail.com>
	<AANLkTinWAjnTMk0FO4nNnkZyTG+F_Qc7BtZG3hQxdJAL@mail.gmail.com>
Date: Mon, 3 Jan 2011 18:30:30 +0100
Message-ID: <AANLkTi=NwEiR1jzGjMPsA7nYaWDzwSp+CfMtYSf-N52+@mail.gmail.com>
Subject: Re: select count(1)
From: kiteraddict <kiteraddict@googlemail.com>
To: user@hive.apache.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

To specify things: I run the embedded mode with the url:
"jdbc:hive://". If I take "jdbc:hive://localhost:10000/default" with
the hiveserver mode, the error will not occur and everything's fine.
But I need multithreated access to my data.
Malte

2011/1/3 kiteraddict <kiteraddict@googlemail.com>:
> Hi Dilip,
> Unfortunately, not. No special characters. Tried a symlink as well...
> The Path seems ok, and the strange is: select count(1) from the cli
> woks.
> I get the same error in Eclipse and in Netbeans (OSX 10.6.4). However
> thank you for your tip!
> Malte
>
> 2011/1/3 Dilip Joseph <dilip.antony.joseph@gmail.com>:
>> Does the full path to your hadoop installation contain a '+' character? =
=A0I
>> ran into a similar problem where a bug in the DataNucleus libraries used=
 by
>> hive prevented it from constructing the full path to your hadoop
>> installation, if the path contained a '+'. =A0The solution was to remove=
 the
>> '+' from the path by renaming the Hadoop installation directory, or by
>> creating a symlink to it.
>> Dilip
>>
>> On Mon, Jan 3, 2011 at 4:37 AM, Malte Ehmke <kiteraddict@googlemail.com>
>> wrote:
>>>
>>> Hi there,
>>>
>>> I'am trying the jdbc example
>>>
>>> http://wiki.apache.org/hadoop/Hive/HiveClient#JDBC
>>>
>>> and getting that for the select count(1) query
>>>
>>> 11/01/03 12:34:35 INFO exec.MapRedTask: Generating plan file
>>> /tmp/hive-malte/hive_2011-01-03_12-34-35_503_9118509121830839307/plan45=
25595563698858213.xml
>>>
>>> 11/01/03 12:34:35 INFO exec.MapRedTask: Executing: null/bin/hadoop jar
>>> /Applications/java/hive-0.6.0/lib/hive-exec-0.6.0.jar [...]
>>>
>>> java.io.IOException: Cannot run program "null/bin/hadoop": error=3D2, N=
o
>>> such file or directory
>>>
>>> at java.lang.ProcessBuilder.start(ProcessBuilder.java:460)
>>>
>>> at java.lang.Runtime.exec(Runtime.java:593)
>>>
>>> at java.lang.Runtime.exec(Runtime.java:431)
>>>
>>> at java.lang.Runtime.exec(Runtime.java:369)
>>>
>>> at org.apache.hadoop.hive.ql.exec.MapRedTask.execute(MapRedTask.java:17=
6)
>>>
>>> at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:107)
>>>
>>> at
>>> org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java=
:55)
>>>
>>> at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:633)
>>>
>>> at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:506)
>>>
>>> at org.apache.hadoop.hive.ql.Driver.run(Driver.java:384)
>>>
>>> at
>>> org.apache.hadoop.hive.service.HiveServer$HiveServerHandler.execute(Hiv=
eServer.java:114)
>>>
>>> at
>>> org.apache.hadoop.hive.jdbc.HiveStatement.executeQuery(HiveStatement.ja=
va:195)
>>>
>>> at de.codiacs.hive.HiveServiceTest.main(HiveServiceTest.java:64)
>>>
>>> Caused by: java.io.IOException: error=3D2, No such file or directory
>>>
>>> at java.lang.UNIXProcess.forkAndExec(Native Method)
>>>
>>> at java.lang.UNIXProcess.<init>(UNIXProcess.java:53)
>>>
>>> at java.lang.ProcessImpl.start(ProcessImpl.java:91)
>>>
>>> at java.lang.ProcessBuilder.start(ProcessBuilder.java:453)
>>>
>>> ... 12 more
>>>
>>> 11/01/03 12:34:35 ERROR exec.MapRedTask: Exception: Cannot run program
>>> "null/bin/hadoop": error=3D2, No such file or directory
>>>
>>> FAILED: Execution Error, return code 1 from
>>> org.apache.hadoop.hive.ql.exec.MapRedTask
>>>
>>> 11/01/03 12:34:35 ERROR ql.Driver: FAILED: Execution Error, return code=
 1
>>> from org.apache.hadoop.hive.ql.exec.MapRedTask
>>>
>>> Exception in thread "main" java.sql.SQLException: Query returned non-ze=
ro
>>> code: 9, cause: FAILED: Execution Error, return code 1 from
>>> org.apache.hadoop.hive.ql.exec.MapRedTask
>>>
>>> at
>>> org.apache.hadoop.hive.jdbc.HiveStatement.executeQuery(HiveStatement.ja=
va:197)
>>>
>>> Creating and inserting works.
>>>
>>> Does anybody have a solution for that problem?
>>>
>>> Thanks
>>
>>
>> --
>> _________________________________________
>> Dilip Antony Joseph
>> http://csgrad.blogspot.com
>> http://www.marydilip.info
>>
>