Re: hive cli problem

get into hadoop home ex: /etc/hadoop/ then share/hadoop/yarn/lib where you can find jline jar Thanks & Regards Amithsha On Tue, Mar 10, 2015 at 11:50 AM, Xu, Cheng A wrote: > Hi, > > Can you use linux command *locate* to find jline jar file? It should be > added into the class path of H

hive 1.1.0 Error while Metastore starting

Hi all, I have Configured Hive 1.1.0 in Hadoop 2.4.1 successfully.Have started the metastore by [ hive --service metastore -p 7099 ] and got the log as 2015-03-10 11:32:42,649 ERROR [main]: DataNucleus.Datastore (Log4JLogger.java:error(115)) - An exception was thrown while adding/validating clas

RE: hive cli problem

Hi, Can you use linux command *locate* to find jline jar file? It should be added into the class path of HIVE. Another way is by running “export HADOOP_USER_CLASSPATH_FIRST=true” instead of removing it. Yours, Ferdinand Xu From: Srinivas Thunga [mailto:srinivas.thu...@gmail.com] Sent: Tuesday,

Re: hive cli problem

Hi, I am also getting the same problem in Hive 1.1.0 As said by you, jline jar is not there in Hadoop. How to find where this jar located and will be removed. Mine is Inside hadoop i am having folders like client, client-0.20 and cloudera, lib *Thanks & Regards,* *Srinivas T* On Mon, Mar 9

Re: [ANNOUNCE] Apache Hive 1.1.0 Released

Agreed! This is an exciting release! :) nice work team! On Monday, March 9, 2015, Xuefu Zhang wrote: > Great job, guys! This is a much major release with significant new features > and improvement. Thanks to everyone who contributed to make this happen. > > Thanks, > Xuefu > > > On Sun, Mar 8, 2

Re: Hive job name

We use the hive.job.name property to set meaningful job names. Look into using that before submitting queries. Thanks, Viral On Mon, Mar 9, 2015 at 2:47 PM, Alex Bohr wrote: > Since going from Hive 0.11 to 0.13 the Job Names, in the JobTracker UI, > for my Hive queries in the job tracker chang

Configuring Hive metastore service to use SAP ASE as container for metastore

Hi, As you may be aware hive metastore stores hive metadata in a relational database. The recommendation is to have this database in a remote container. Currently this database can be created "remotely" on MySQL and PostgresSQL plus Oracle and I believe MSSQL. I have now adapted the relevan

Hive job name

Since going from Hive 0.11 to 0.13 the Job Names, in the JobTracker UI, for my Hive queries in the job tracker changed. It used to be the first 200 characters or so of the Hive query, now it's just "hive-exec-0.13.1-cdh5.3.1.jar." Seeing the beginning of the query in the job Name was super helpfu

Re: [ANNOUNCE] Apache Hive 1.1.0 Released

Great job, guys! This is a much major release with significant new features and improvement. Thanks to everyone who contributed to make this happen. Thanks, Xuefu On Sun, Mar 8, 2015 at 10:40 PM, Brock Noland wrote: > The Apache Hive team is proud to announce the the release of Apache > Hive v

Re: sorting in hive -- general

Thank you... On Mon, Mar 9, 2015 at 2:23 AM, r7raul1...@163.com wrote: > read this article > http://www.philippeadjiman.com/blog/2009/12/20/hadoop-tutorial-series-issue-2-getting-started-with-customized-partitioning/ > > > then read > https://cwiki.apache.org/confluence/display/Hive/LanguageManu

Re: hive cli problem

Hi Garry Try removing jline-0.9.94.jar from hadoop. The exact path is this $HADOOP_PREFIX/share/hadoop/yarn/lib/jline-0.9.94.jar See here for discussion https://issues.apache.org/jira/browse/HIVE-8609?focusedCommentId=14215543&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpane

hive cli problem

Hi All, New to hive and run into problem when try to lunch hive cli as follow. Please help. hadoop> hive Logging initialized using configuration in jar:file:/u01/app/hive-1.1.0/lib/hive-common-1.1.0.jar!/hive-log4j.properties SLF4J: Class path contains multiple SLF4J bindings. S

RE: Parallel queries/dags running in same AM?

>>(1)- For every TEZ AM it is possible to launch just a single query/DAG at a >>time. So within a given AM several DAGs can be executed only in sequential >>order (a.k.a. a session), not in parallel. To execute DAGs in parallel we >>always need several AMs. Correct. Today a single AM will accep

Re: Fwd: Row exception in Hive while using join

Hi Krish, It seems the data corresponding to that particular row pertaining to key 12 is corrupt.Can u try reloading the data and then selecting? Let me know if it works. Regards Swagatika On Mar 5, 2015 4:45 PM, "krish" wrote: > > I got the following exception while executing join on Hive Quer

Parallel queries/dags running in same AM?

Hi all, I've been using Tez on hive, and I had a chance to hear a conversation that mismatches with my present knowledge, can anyone confirm the following statement? (1)- For every TEZ AM it is possible to launch just a single query/DAG at a time. So within a given AM several DAGs can be executed o

RE: configuring Hive metastore to use Oracle DB ignored

OK I managed to sort this out. My problem was basic mistake. I copied $HIVE_HOME/conf/hive-core.xml from the template file. I then added the properties of the new metastore including URL, DriverName, UserName, Password at "top" of the file not realising that the hive-core.xml makes referenc

configuring Hive metastore to use Oracle DB ignored

Hi all, I am trying to use an Oracle DB as the metastore for Hive. I have create all the users and connections, added Oracle jar file ojdbc6.jar to /usr/lib/hive/lib. I have also renamed the derby jar file derby-10.10.1.1.jar to derby-10.10.1.1.jar_ori so it does not use the embedded Derby

Re: sorting in hive -- general

read this article http://www.philippeadjiman.com/blog/2009/12/20/hadoop-tutorial-series-issue-2-getting-started-with-customized-partitioning/ then read https://cwiki.apache.org/confluence/display/Hive/LanguageManual+SortBy r7raul1...@163.com From: max scalf Date: 2015-03-08 07:02 To: HD