Re: Hive 1.2.0 Unable to start metastore

Thanks for sharing the issue. Currently I am using two different environment params to run my sessions: One for Hive and one for Spark (wout conflicting Jars being present at the same time), and this seemed to solve my issues. Although I have seen some issues, specially once I need to restart my me

Re: Hive 1.2.0 Unable to start metastore

Sounds like you ran into this: https://issues.apache.org/jira/browse/HIVE-9198 On Mon, Jun 8, 2015 at 1:06 PM, James Pirz wrote: > Thanks ! > There was a similar problem: Conflicting Jars, but between Hive and Spark. > My eventual goal is running Spark with Hive's tables, and having Spark's > li

Re: Hive 1.2.0 Unable to start metastore

Thanks ! There was a similar problem: Conflicting Jars, but between Hive and Spark. My eventual goal is running Spark with Hive's tables, and having Spark's libraries on my path as well, there were conflicting Jar files. I removed Spark libraries from my PATH and Hive's services (remote metastore)

Re: Hive 1.2.0 Unable to start metastore

It sounds like you are running into a jar conflict between the hive packaged derby and hadoop distro packaged derby. Look for derby jars on your system to confirm. In the mean time try adding this to your hive-env.sh or hadoop-env.sh file: export HADOOP_USER_CLASSPATH_FIRST=true On Mon, Jun 8, 2

Hive 1.2.0 Unable to start metastore

I am trying to run Hive 1.2.0 on Hadoop 2.6.0 (on a cluster, running CentOS). I am able to start Hive CLI and run queries. But once I try to start Hive's metastore (I trying to use the builtin derby) using: hive --service metastore I keep getting Class Not Found Exceptions for "org.apache.derby.j

Re: HBase and Hive integration

Hi there. I go through a complete example in this pair of blog posts [0], [1]. Basically, create the table with the storage handler, without EXTERNAL and it's lifecycle will be managed by hive. [0]: http://www.n10k.com/blog/hbase-via-hive-pt1/ [1]: http://www.n10k.com/blog/hbase-via-hive-pt2/ On

Re: Set variable in hive query

Hi It seems (see here ) Hive substitutes the variables before parsing the query. So the query being parsed is actually: SELECT criticid AS criticid, sum(rating)

Hive custom authorization managers

Hi, We need to implement the following custom authorization check: "When a resource/file is accessed, a REST service lookup needs to be done (by passing the resource id & the user name). This REST service will provide a return value saying whether the user has permission to access the resource o

Hiveserver2 jdbc - class not found error hook

My auxilary paths set in the hive-site.xml are not working when I connect via hiveserver2 jdbc. I have a postexec hook which is not recognized by hiveserver2. Hive cli works fine. Hive 0.13.0.2

Re: hive tez error

Sorry, to make it more clear. The applicationId is the placeholder of your applicationId of your hive session. You can look for it in the RM web UI Best Regard, Jeff Zhang From: Sateesh Karuturi mailto:sateesh.karutu...@gmail.com>> Reply-To: "user@hive.apache.org

Re: hive tez error

couldn't find any error On Mon, Jun 8, 2015 at 1:24 PM, r7raul1...@163.com wrote: > hive -hiveconf hive.root.logger=DEBUG,consoleTo See some debug log > > -- > r7raul1...@163.com > > > *From:* Sateesh Karuturi > *Date:* 2015-06-08 16:15 > *To:* user > *Subject:

Re: hive tez error

hive -hiveconf hive.root.logger=DEBUG,consoleTo See some debug log r7raul1...@163.com From: Sateesh Karuturi Date: 2015-06-08 16:15 To: user Subject: hive tez error getting FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.tez.TezTask error... when iam trying to

Re: hive tez error

when i try to check getting this hadoop@localhost:~$ yarn logs -applicationId options parsing failed: Missing argument for option: applicationId Retrieve logs for completed YARN applications. usage: yarn logs -applicationId [OPTIONS] general options are: -appOwnerAppOwner (assumed to be cur

Re: hive tez error

Could you check the yarn app logs ? By invoking command : "yarn logs -applicationId" Best Regard, Jeff Zhang From: Sateesh Karuturi mailto:sateesh.karutu...@gmail.com>> Reply-To: "user@hive.apache.org" mailto:user@hive.apache.org>> Date: Monday, June 8, 2015 at 3

hive tez error

getting FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.tez.TezTask error... when iam trying to perform insert operation on hive(set hive.execution.engine=tez). whenever hive.execution.engine value is set to mr its works fine please help me out

Re: Day of year

See this comment on HIVE-3378 (UDF to obtain the numeric day of an year from date or timestamp in HIVE): Marked the Jira as resolved be