Re: Job aborted due to stage failure

2014-12-04 Thread yuemeng1
Hi,Lefty Currently, I have some other things to do, I'm going to edit wikidocs tomorrow thanks Yuemeng On 2014/12/5 9:59, Lefty Leverenz wrote: Yuemeng, you can find out how to edit wikidocs here: About This Wiki

Re: Enabling Tez sessions on HiveServer2

2014-12-04 Thread Gopal V
On 12/3/14, 3:34 PM, Pala M Muthaia wrote: I didn't know doAs needs to be turned off. But I don't think that is something to give up - users create tables, manage data, query etc, and we need the queries/jobs to run as the user who submitted them for various purposes including authorization, audi

Re: Job aborted due to stage failure

2014-12-04 Thread Lefty Leverenz
Yuemeng, you can find out how to edit wikidocs here: About This Wiki . -- Lefty On Wed, Dec 3, 2014 at 10:05 PM, Xuefu Zhang wrote: > Hi Yuemeng, > > I'm glad that Hive on Spark finally work

# of failed Map Tasks exceeded allowed limit

2014-12-04 Thread Jihyun Suh
I have a problem that inserting data from external table to managed table. I already have done just 'limit 10' with below hql but can't all data. I have the error just like '# of failed Map Tasks exceeded allowed limit' How should I do? --

Re: weird alter table commands running on hive metastore

2014-12-04 Thread Viral Bajaria
Some of the commands that are running (I am ignoring the REFERENCES part of it) ALTER TABLE `PARTITIONS` ADD CONSTRAINT `PARTITIONS_FK1` FOREIGN KEY (`SD_ID`) ALTER TABLE `COLUMNS_V2` ADD CONSTRAINT `COLUMNS_V2_FK1` FOREIGN KEY (`CD_ID`) ALTER TABLE `SDS` ADD CONSTRAINT `SDS_FK1` FOREIGN KEY (`CD_

weird alter table commands running on hive metastore

2014-12-04 Thread Viral Bajaria
Hi, I am seeing a bunch of "ALTER TABLE" commands running on my hive metastore (MySQL / MariaDB) and it happens whenever I run the Hive CLI. Why would running a Hive CLI issue ALTER TABLE commands ? Those ALTER TABLE commands lock the metastore and hence I find a lot of DEADLOCK issues which I h

Re: Issue with windowing function UDAF registeration

2014-12-04 Thread Jason Dere
Hi Wesley, Sorry for the late response on this .. is it true you saw this work on a different version (later) of Hive? Based on what I think should be the problem, this would still be an issue in later versions of Hive. Looks like the error may be occurring because the Hive is trying to look up

Re: hive transactions

2014-12-04 Thread Alan Gates
Can you post the log from your metastore at the same time as this log from your client? That should tell what problem the metastore is seeing to cause the lock request to fail. Note that you can't attach your log to mail sent to the list. So you can cut and paste any relevant errors or post

Using webhcat with streaming

2014-12-04 Thread Ch Wan
Hi all, I'm using hive0.13.1. I logged in as hcat and started the webhcat server. Now I can get the table info by the restful api. But I’m getting an error "{"error":"User: hcat is not allowed to impersonate wanchang"}" when attempting to submit a streaming via webhcat. Here is part of the configur