Re: hiveserver2 oom

2016-09-21 Thread Sanjeev Verma
lowered 1073741824 to half of it but still getting the same issue. On Wed, Sep 21, 2016 at 6:44 PM, Sanjeev Verma wrote: > its 1073741824 now but I cant see anything running on client side, the job > which kicked up by the query got completed but HS2 is crashing > > On Wed, Sep 21, 2016 at 6:40

Re: hiveserver2 oom

2016-09-21 Thread Sanjeev Verma
its 1073741824 now but I cant see anything running on client side, the job which kicked up by the query got completed but HS2 is crashing On Wed, Sep 21, 2016 at 6:40 PM, Prasanth Jayachandran < pjayachand...@hortonworks.com> wrote: > FetchOperator will run client side. What is the value for > hi

Re: hiveserver2 oom

2016-09-21 Thread Prasanth Jayachandran
FetchOperator will run client side. What is the value for hive.fetch.task.conversion.threshold? Thanks Prasanth > On Sep 21, 2016, at 6:37 PM, Sanjeev Verma wrote: > > I am getting hiveserver2 memory even after increasing the heap size from 8G > to 24G, in clue why it still going to OOM with e

hiveserver2 oom

2016-09-21 Thread Sanjeev Verma
I am getting hiveserver2 memory even after increasing the heap size from 8G to 24G, in clue why it still going to OOM with enough heapsize "HiveServer2-HttpHandler-Pool: Thread-58026" prio=5 tid=58026 RUNNABLE at java.lang.OutOfMemoryError.(OutOfMemoryError.java:48) at org.apache.hadoop.

RE: Extracting data from ELB log date format

2016-09-21 Thread Markovitz, Dudu
select to_date(ts),year(ts),month(ts),day(ts),hour(ts),minute(ts),second(ts) from (select from_unixtime (unix_timestamp ('2016-09-15T23:45:22.943762Z',"-MM-dd'T'HH:mm:ss")) as ts) as t; OK 2016-09-15 2016 915 23 45 22 Dudu From: Manish Rangari [mailto:linuxtricksfordev...@gmail.co

Re: Need help with query

2016-09-21 Thread Igor Kravzov
I run MSCK REPAIR TABLE mytable; and got Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask On Mon, Sep 12, 2016 at 6:56 PM, Lefty Leverenz wrote: > Here's a list of the wikidocs about dynamic partitions >

Write access to Hive wiki please

2016-09-21 Thread Ian Cook
Hello, Could I please have write access to the Hive wiki so that I can help with fixes? My Confluence username is *icook*. Thanks, Ian Cook Cloudera

Re: Extracting data from ELB log date format

2016-09-21 Thread Haas, Nichole
in Hive CL: set today = cast(concat(substr(cast(current_date() as string),1,4),substr(cast(current_date() as string),6,2),substr(cast(current_date() as string),9,2)) as int) From: Manish Rangari Reply-To: "user@hive.apache.org" Date: Wednesday, September 21, 2016 at 6:23 AM To: "user@hive.apa

Extracting data from ELB log date format

2016-09-21 Thread Manish Rangari
Guys, I am trying to extract date, time, month, minute etc from below timestamp format but did not find any function for this. Can anyone help me to extract the details? 2016-09-15T23:45:22.943762Z 2016-09-15T23:45:22.948829Z --Manish