ALTER TABLE T1 PARTITION(P1) CONCATENATE bug?

Has anyone seen anything like this? Google searches turned up nothing, so I thought I'd ask here, then file a JIRA if no-one thinks I'm doing it wrong. If I ALTER a particular table with three partitions once, it works. Second time it works, too, but reports it is moving a directory to the Trash t

Question re: Concurrency

I am looking at this page: https://cwiki.apache.org/confluence/display/Hive/Locking I have two questions. First, what is the shared/exclusive locking behaviour of "alter table T1 partition(P1) concatenate"? It seems likely it should be the same as for touch partition. And see this quote (emphasis

Re: Hive User Group Meeting, Oct. 15th, New York

Dear Hive users/developers, The meetup is just a couple of days away. Please RSVP if you plan to attend and haven't done so, as your name needs to be in the list in order to pass the building security. The RSVP will be closed by the end of today. Regards, Xuefu On Thu, Oct 2, 2014 at 10:36 AM, X

Re: Smoke Test after 1 days 7 hours 5 minutes 19 seconds 70 msec, Failed with Error: GC overhead limit exceeded

Arthur, just curious.. what tuning you did? It seems, your last failing map-only job (w/ 3 map tasks) either need to have more mappers or more heap allocated to each of them. --Suhas On Mon, Oct 13, 2014 at 3:12 AM, arthur.hk.c...@gmail.com < arthur.hk.c...@gmail.com> wrote: > Hi, > > I have ma

Re: Smoke Test after 1 days 7 hours 5 minutes 19 seconds 70 msec, Failed with Error: GC overhead limit exceeded

Hi, I have managed to resolve the issue by turning the SQL. Regards Arthur On 12 Oct, 2014, at 6:49 am, arthur.hk.c...@gmail.com wrote: > Hi, > > My Hive version is 0.13.1, I tried a smoke test, after 1 days 7 hours 5 > minutes 19 seconds 70 msec, the job failed with error: Error: GC overhea

Hive meta store error in hive thrift server 2

Hello, We are using hive thrift server 2 and we are firing queries with around 5 threads. Initially we run all our queries with expain prefixed so that we get to know any syntax errors in the beginning only. Sometimes this error suddenly comes on hive thrift server. After restarting and re

query using stats

Hi , I am trying to run query using stats with following flags as set,but it is always running map reduce job instead of getting direct result from metastore (Hive 0.13.0.2.1.2.1-471).can some please suggest me to run optimized query or a workaround it . Thanks in advance Set hive.stats.reliabl

Re: DDL wiki GRANT

Hmm.. looking at the syntax priv_level does not seem to be a keyword but rather actual name of a table or database.. so why it appears like a keyword Also priv_level is confusing and rather clear syntax would should look like below... Again answer to original question from Brett, yes GRANT syntax