Add it to the distributed cache
add jar derby.jar;
or
use environment variable HIVE_AUX_JARS_PATH
On Mon, Nov 28, 2011 at 1:29 PM, Ghousia <ghousia.ath...@gmail.com> wrote:
> Hi Chinna,
>
> I have the derby.jar in the lib folder, hive runs fine and we are able to
> execute the queries. Even then this error shows up in the logs, if the
> query execution is successful. If we closely see this db is for stats not
> for the actual metastore.
>
> -Ghousia.
>
> On Mon, Nov 28, 2011 at 11:49 AM, Chinna Rao Lalam
> <chinna...@huawei.com>wrote:
>
>> Hi,
>>
>>
>>
>> This class "org.apache.derby.jdbc.EmbeddedDriver" will present in the
>> derby.jar normally the hive distribution will come with this jar
>>
>> for example HIVE0.8 will contain derby-10.4.2.0.jar.
>>
>>
>>
>> Check derby.jar present in {HIVE_HOME}/lib or not
>>
>>
>>
>> And version details can u add to the mail..
>>
>>
>>
>> Hope it helps,
>>
>> Chinna Rao Lalam
>>
>>
>> ------------------------------
>> *From:* Ghousia [ghousia.ath...@gmail.com]
>> *Sent:* Monday, November 28, 2011 1:14 PM
>> *To:* user@hive.apache.org
>> *Subject:* ClassNotFoundException every time we run any hive query
>>
>> Hi,
>>
>> We always get this exception for any hive query we run.
>>
>> org.apache.hadoop.hive.ql.stats.jdbc.JDBCStatsPublisher: Error during
>> JDBC
>> > connection to jdbc:derby:;databaseName=TempStatsStore;create=true.
>> > java.lang.ClassNotFoundException: org.apache.derby.jdbc.EmbeddedDriver
>> > at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
>> > at java.security.AccessController.doPrivileged(Native Method)
>> > at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
>> > at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
>> > at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
>> > at java.lang.ClassLoader.loadClass(ClassLoader.java:247)
>> > at java.lang.Class.forName0(Native Method)
>> > at java.lang.Class.forName(Class.java:169)
>> > at
>> >
>> org.apache.hadoop.hive.ql.stats.jdbc.JDBCStatsPublisher.connect(JDBCStatsPublisher.java:55)
>> > at
>> >
>> org.apache.hadoop.hive.ql.exec.FileSinkOperator.publishStats(FileSinkOperator.java:781)
>> > at
>> >
>> org.apache.hadoop.hive.ql.exec.FileSinkOperator.closeOp(FileSinkOperator.java:649)
>> > at
>> org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:557)
>> > at
>> org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:566)
>> > at
>> org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:566)
>> > at
>> > org.apache.hadoop.hive.ql.exec.ExecReducer.close(ExecReducer.java:303)
>> > at
>> > org.apache.hadoop.mapred.ReduceTask.runOldReducer(ReduceTask.java:473)
>> > at org.apache.hadoop.mapred.ReduceTask.run(ReduceTask.java:411)
>> > at org.apache.hadoop.mapred.Child.main(Child.java:170)
>> >> org.apache.hadoop.hive.ql.exec.FileSinkOperator: StatsPublishing error:
>> > cannot connect to database
>>
>>
>> Many Thanks,
>> Ghousia.
>>
>
>
