0.13 contains hwi.war?

2014-02-18 Thread Meng QingPing
Hi, I built 0.13, but no hwi.war in package/dist. mvn clean package -DskipTests -Pdist -Phadoop-2 How to generate hwi.war? Thanks. -- Thanks, Jack

Re: hiveserver2 crashes now and then

2014-02-18 Thread Brad Ruderman
Hi Shouvanik- Can you send the hive server 2 logs? Also might want to reach out to the Accenture Tech lab's Data and Platforms group for client support as they should have in-depth experience with Hive Configuration. Mike Wendt would be a good contact. Thanks, Brad On Tue, Feb 18, 2014 at 3:18 P

hiveserver2 crashes now and then

2014-02-18 Thread shouvanik.haldar
Hi, HiveServer2 is getting crashed every now and then, within an interval to 2 days or so. Is this related to memory leak or something? Developers are executing very complex queries which they suspect is causing the problem. Please help. Thanks, Shouvanik ___

Re: Issue with Hive and table with lots of column

2014-02-18 Thread David Gayou
Sorry i badly reported it. It's 8192M Thanks, David. Le 18 févr. 2014 18:37, "Stephen Sprague" a écrit : > oh. i just noticed the -Xmx value you reported. > > there's no M or G after that number?? I'd like to see -Xmx8192M or > -Xmx8G. That *is* very important. > > thanks, > Stephen. > > > On

Re: Issue with Hive and table with lots of column

2014-02-18 Thread Stephen Sprague
oh. i just noticed the -Xmx value you reported. there's no M or G after that number?? I'd like to see -Xmx8192M or -Xmx8G. That *is* very important. thanks, Stephen. On Tue, Feb 18, 2014 at 9:22 AM, Stephen Sprague wrote: > thanks. > > re #1. we need to find that Hiveserver2 process. For a

Re: Issue with Hive and table with lots of column

2014-02-18 Thread Stephen Sprague
thanks. re #1. we need to find that Hiveserver2 process. For all i know the one you reported is hiveserver1 (which works.) chances are they use the same -Xmx value but we really shouldn't make any assumptions. try wide format on the ps command (eg. ps -efw | grep -i Hiveserver2) re.#2. okay.

Re: hive13 release date

2014-02-18 Thread Alan Gates
Harish, who has volunteered to be release manager for 0.13 has stated he’d like to branch this week and then give a couple of weeks to stabilize the branch. So that would put the release somewhere in early March. Alan. On Feb 14, 2014, at 11:45 AM, Suhas Satish wrote: > Is there a ball park

Re: Issue with Hive and table with lots of column

2014-02-18 Thread David Gayou
1. I have no process with hiveserver2 ... "ps -ef | grep -i hive" return some pretty long command with a -Xmx8192 and that's the value set in hive-env.sh 2. The "select * from table limit 1" or even 100 is working correctly. David. On Tue, Feb 18, 2014 at 4:16 PM, Stephen Sprague wrote: >

Re: Write Access to Wiki to edit "HiveServer2 Clients" page

2014-02-18 Thread Tsuyoshi OZAWA
Thank you, Ashutosh. I could update Wiki :-) https://cwiki.apache.org/confluence/display/Hive/HiveServer2+Clients#HiveServer2Clients-ConnectionURLforRemoteorEmbeddedMode Thanks, - Tsuyoshi On Tue, Feb 18, 2014 at 7:54 AM, Ashutosh Chauhan wrote: > Hi Tsuyoshi, > I added you to Hive cwiki. Feel f

Re: Write Access to Wiki to edit "HiveServer2 Clients" page

2014-02-18 Thread Ashutosh Chauhan
Hi Tsuyoshi, I added you to Hive cwiki. Feel free to contribute. Thanks, Ashutosh On Mon, Feb 17, 2014 at 11:41 PM, Tsuyoshi OZAWA wrote: > Hi, > > I'd like to contribute update Hive's wiki. > Could you give me a permission to write it? > > As described in HIVE-4232, we need to set "auth=noSasl

Re: Hive Query :: Implementing case statement

2014-02-18 Thread Stephen Sprague
maybe consider something along these lines. nb. not tested. -- temp table holding new balances + key create table NEW_BALS as select * from ( select b.prev as NEW_BALANCE, a.key from TABLE_SQL a join TABLE_SQL_2 b on (a.key=b.key) where a.code='1'; UNION ALL select b.prev as N

Re: Issue with Hive and table with lots of column

2014-02-18 Thread Stephen Sprague
He lives on after all! and thanks for the continued feedback. We need the answers to these questions using HS2: 1. what is the output of "ps -ef | grep -i hiveserver2" on your system? in particular what is the value of -Xmx ? 2. does "select * from table limit 1" work? Thanks, Stephen.

Re: Issue with Hive and table with lots of column

2014-02-18 Thread David Gayou
I'm so sorry, i wrote an answer, and i forgot to sent it And i haven't been able to work on this for a few days. So far : I have a 15k columns table and 50k rows. I do not see any changes if i change the storage. *Hive 12.0* My test query is "select * from bigtable" If i use the hive c

Re: Hive Query :: Implementing case statement

2014-02-18 Thread Navis류승우
If key is unique, you might overwrite values by using hbase handler. 2014-02-18 22:05 GMT+09:00 yogesh dhari : > Yes, Hive does not provide update statement, I am just looking for the > work arround it, how to implement it > > > > > > On Tue, Feb 18, 2014 at 6:27 PM, Peter Marron < > peter.mar..

Re: Hive Query :: Implementing case statement

2014-02-18 Thread yogesh dhari
Yes, Hive does not provide update statement, I am just looking for the work arround it, how to implement it On Tue, Feb 18, 2014 at 6:27 PM, Peter Marron < peter.mar...@trilliumsoftware.com> wrote: > From https://cwiki.apache.org/confluence/display/Hive/Home > > > > "Hive is not designed for

RE: Hive Query :: Implementing case statement

2014-02-18 Thread Peter Marron
>From https://cwiki.apache.org/confluence/display/Hive/Home "Hive is not designed for OLTP workloads and does not offer real-time queries or row-level updates." As far as I am aware "UPDATE" isn't even in the Hive DML. Z Peter Marron Senior Developer Trillium Software, A Harte Hanks Company Th

Hive Query :: Implementing case statement

2014-02-18 Thread yogesh dhari
Hello All, I have a use case where a table say TABLE_SQL is geting updated like. 1st Update Command update TABLE_SQL a set BALANCE = b.prev from TABLE_SQL_2 b where a.key = b.key and a.code = "1" 2nd Update Command update TABLE_SQL a set BALANCE = b.prev from TABLE_SQL_3 b where a.key = b.ke