Re: Access to Hive Confluence Wiki

Done. Welcome to the Hive wiki team, Shannon! -- Lefty On Tue, Aug 4, 2015 at 1:25 AM, Shannon Ladymon wrote: > Hi! > > I'd like to request write access to the Hive wiki. I'd like to work on > documentation. > > My Confluence user name is sladymon. > > Thanks! > > -Shannon >

Access to Hive Confluence Wiki

Hi! I'd like to request write access to the Hive wiki. I'd like to work on documentation. My Confluence user name is sladymon. Thanks! -Shannon

Re: Error communicating with metastore

Thanks Alan. Yes I've run metastore scripts for oracle instance. Infact I've removed my previous metastore and created a fresh one by running the schema creation script for 1.2.1. I've looked into the new schema and able to see the table TXNS. I've also removed the hdfs location "/user/hive/wareho

RE: start hiveserver2 failed need help

For the sake of the hive user community could you post how you resolve it :) Thanks, Gary Clark From: Garry Chen [mailto:g...@cornell.edu] Sent: Monday, August 03, 2015 4:24 PM To: user@hive.apache.org Subject: RE: start hiveserver2 failed need help I found the problem and case solved. Garry F

RE: start hiveserver2 failed need help

I found the problem and case solved. Garry From: Garry Chen [mailto:g...@cornell.edu] Sent: Monday, August 03, 2015 5:01 PM To: user@hive.apache.org Subject: start hiveserver2 failed need help Hi all, When I try to start hiveserer2 failed with following error. It was running but

start hiveserver2 failed need help

Hi all, When I try to start hiveserer2 failed with following error. It was running but after the server reboot hiveeserver2 will not start. Please help. Thank you very much. Garry 2015-08-03 16:57:07,677 WARN [main]: server.HiveServer2 (HiveServer2.java:startHiveServer2(330))

RE: External sorted tables

Thanks, so only optimization for sorted data is on buckets, so without buckets there isn't really a reason to tell hive the data is sorted. Thanks for letting me know On Aug 3, 2015 11:11 AM, "Ryan Harris" wrote: > Sort-Merge-Bucket (SMB) joins and MAPJOINs are related, but separate... > > > > >

RE: External sorted tables

Sort-Merge-Bucket (SMB) joins and MAPJOINs are related, but separate... https://cwiki.apache.org/confluence/display/Hive/LanguageManual+JoinOptimization I think you should still be able to get map-side joins (if the join table is small enough) Nothing here that says sorting is required: htt

RE: External sorted tables

Mostly wanted to tell hive it's sorted so it could use more efficient joins like a map side join. No other reason On Aug 3, 2015 10:47 AM, "Ryan Harris" wrote: > Unless you are using bucketing and sampling, there is no benefit (that I > can think of) to informing hive that the data **is** in fac

RE: External sorted tables

Unless you are using bucketing and sampling, there is no benefit (that I can think of) to informing hive that the data *is* in fact sorted... If there is something specific you are trying to accomplish by specifying the sort order of that column, perhaps you can elaborate on that. Otherwise, le

Re: External sorted tables

Based off the ddl it is required to have buckets, I was wondering if there was a way to get around it? Thinking as a hack I could try bucket=1, but if there is a better way would love to know On Aug 2, 2015 6:18 PM, "Takahiko Saito" wrote: > Hi, > > Is it possible that 'create table sorted by' m

Re: Error communicating with metastore

Did you run the hive metastore upgrade scripts for your oracle instance? This error message usually means the transaction related tables have not been created in your database. Somewhere in your distribution there should be a set of upgrade scripts. Look for scripts of the form: scripts/me

Re: Obtain user identity in UDF

Is there a similar example where the query information is being retrieved. So I want to find out which table or the database the query is being run for by the user. Thanks Adeel On Mon, Jul 27, 2015 at 3:26 PM, Adeel Qureshi wrote: > Right :) Thanks. Problem solved. > > On Mon, Jul 27, 2015 at

Re: Error communicating with metastore

Thanks Sharath for your reply. I'm specifying these parameters already. I've followed the documentation at https://cwiki.apache.org/confluence/display/Hive/Hive+Transactions But it still throws me this error On Mon, Aug 3, 2015 at 8:45 PM, Sharath Punreddy wrote: > Here is another one: > > http

Re: Error communicating with metastore

Check out: http://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.1.1/bk_dataintegration/content/ch_using-hive-transactions.html You need to specify the following properties as well: - hive.txn.driver - hive.compactor.initiator.on - hive.compactor.worker.threads On Mon, Aug 3,

Error communicating with metastore

Hi All, Earlier I was using hive 0.13.0 and now trying to migrate to latest version to utilize the transaction support introduced from hive 0.14.0. I downloaded hive 1.2.1, created a metastore in oracle database and provided all the required configuration parameters in conf/hive-site.xml to enabl