Re: Reducers Failing

2014-05-21 Thread Shengjun Xin
Are datanodes dead? On Thu, May 22, 2014 at 2:23 PM, Sreenath wrote: > Hi All, > > We are running a hadoop cluster and many of our hive queries are failing > in the reduce phase with the following error > > java.io.IOException: All datanodes *.*.*.*:50230 are bad. Aborting... > at > org.

Re: Connecting hive to SAP BO

2014-05-19 Thread Shengjun Xin
hive –auxpath /path-to-/csvserde.jar On Tue, May 20, 2014 at 12:59 PM, Chhaya Vishwakarma < chhaya.vishwaka...@lntinfotech.com> wrote: > > > Hi, > > I have connected SAP BO to Hive using a ODBC driver. I am able to see the > database and table in hive. but when i fetch data from hive it gives er

Re: Hive 0.13.0 Memory Leak

2014-05-18 Thread Shengjun Xin
We found a hive jdbc connection leak https://issues.apache.org/jira/browse/HIVE-6866, is it similar to your issue? On Thu, May 15, 2014 at 9:29 PM, Bryan Jeffrey wrote: > All, > > We are running Hadoop 2.2.0 and Hive 0.13.0. One typical application is > to load data (as text), and then convert

Re: issue about Job running in-process (local Hadoop)

2014-05-12 Thread Shengjun Xin
According to the log, you configured a local hadoop, you need to check you configuration On Mon, May 12, 2014 at 3:46 PM, ch huang wrote: > hi,maillist: >i try hive 0.12,but it always run job in local mode ,why? i install > hive on a seperate hox ,and install hadoop client on it ,and co

Re: java.lang.IncompatibleClassChangeError in hive

2014-05-05 Thread Shengjun Xin
Check the hive-env.sh and environment variables, whether the HADOOP_HOME is what you want? On Tue, May 6, 2014 at 11:33 AM, chandra kant < chandralakshmikan...@gmail.com> wrote: > > Hi, > When running bin/hive , i get the following error :- > Exception in thread "main" java.lang.IncompatibleClas

Re: Number of hive-server2 threads increments after jdbc connection

2014-05-04 Thread Shengjun Xin
Is it same with https://issues.apache.org/jira/browse/HIVE-6866 ? On Tue, Apr 29, 2014 at 8:26 PM, Dima Fadeyev wrote: > Hi, Chinna. Thanks for your reply. > > Yes, modifying code solves the problem. This is what my code looks like (a > piece of it): > > Connection con = > DriverManager.ge

Re: [ANNOUNCE] New Hive Committers - Prasanth J and Vaibhav Gumashta

2014-04-24 Thread Shengjun Xin
Congratulations ~~ On Fri, Apr 25, 2014 at 10:33 AM, Carl Steinbach wrote: > + Prasanth's correct email address > > > On Thu, Apr 24, 2014 at 7:31 PM, Xuefu Zhang wrote: > >> Congratulations to Prasanth and Vaibhav! >> >> --Xuefu >> >> >> On Thu, Apr 24, 2014 at 7:26 PM, Carl Steinbach wrote:

Re: create table question

2014-04-22 Thread Shengjun Xin
in the ql, you set relative path tmp/states, according to the error message, you need to set absolute path On Wed, Apr 23, 2014 at 11:23 AM, EdwardKing wrote: > I use hadoop 2.2.0 and hive 0.13.0, I want to create a table from an > existing file, states.hql is follows: > CREATE EXTERNAL TABLE

Re: question about hive sql

2014-04-21 Thread Shengjun Xin
You need to check the container log for the details On Tue, Apr 22, 2014 at 10:27 AM, EdwardKing wrote: > I use hive under hadoop 2.2.0, first I start hive > [hadoop@master sbin]$ hive > 14/04/21 19:06:32 INFO Configuration.deprecation: > mapred.input.dir.recursive is deprecated. Instead, use

Re: hive hbase integration

2014-04-17 Thread Shengjun Xin
For the first question, it's hive-hbase-handler, for the second question, you can refer to https://cwiki.apache.org/confluence/display/Hive/HBaseIntegration On Fri, Apr 18, 2014 at 1:05 AM, Shushant Arora wrote: > what is hive storage handlers? > What are the best practices for hive hbase integr

Re: Hive install under hadoop

2014-04-14 Thread Shengjun Xin
Do you install hadoop correctly? On Mon, Apr 14, 2014 at 4:22 PM, EdwardKing wrote: > I want to use hive in hadoop2.2.0, so I execute following steps: > > [hadoop@master /]$ tar -xzf hive-0.11.0.tar.gz > [hadoop@master /]$ export HIVE_HOME=/home/software/hive > [hadoop@master /]$ export PATH=

Re: pig,hive install over hadoop

2014-04-01 Thread Shengjun Xin
Install hive and pig completely and configure hive and pig to use the existing hadoop cluster On Tue, Apr 1, 2014 at 6:17 PM, Chinna Rao Lalam wrote: > Hi, > > You need to install hive completely because both are different > processes(Installing hive is very simple and it require few > configur