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/

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,

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

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 james.p...@gmail.com 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

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

Re: Day of year

See this comment https://issues.apache.org/jira/browse/HIVE-3378?focusedCommentId=14501569page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-14501569 on HIVE-3378 (UDF to obtain the numeric day of an year from date or timestamp in HIVE): Marked the Jira as resolved

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

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: 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 sateesh.karutu...@gmail.commailto:sateesh.karutu...@gmail.com Reply-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 application ID [OPTIONS] general options are: -appOwner Application

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: Set variable in hive query

Hi It seems (see here https://github.com/apache/hive/blob/master/ql/src/java/org/apache/hadoop/hive/ql/Driver.java#L388) Hive substitutes the variables before parsing the query. So the query being parsed is actually: SELECT criticid AS criticid, sum(rating)