RE: Is there any monitoring tool available for hiveserver2

That will be great! Thanks in advance. Thanks, Shouvanik From: Biswajit Nayak [mailto:biswajit.na...@inmobi.com] Sent: Thursday, February 20, 2014 8:37 PM To: user@hive.apache.org Subject: RE: Is there any monitoring tool available for hiveserver2 I could share the script that does it. I w

RE: Is there any monitoring tool available for hiveserver2

I could share the script that does it. I will be able to do it by 12:30 . Stuck in a meeting till that time. Regards Biswa On 21 Feb 2014 10:02, wrote: > Hi Biswajit, > > > > Could you give an idea of how to do it, please? > > > > > > > > > > > > > > Thanks, > > Shouvanik > > > > *From:* Biswaj

Query regarding Hive Parallel Orderby

Hi, Hive 12 has added the functionality of parallel order by. I have a few queries regarding the working of it. >From the source code I have figured out that to do a parallel orderby , a partition table needs to created which is provided as an input to TotalOrderPartitioner. To create the partiti

RE: Is there any monitoring tool available for hiveserver2

Hi Biswajit, Could you give an idea of how to do it, please? Thanks, Shouvanik From: Biswajit Nayak [mailto:biswajit.na...@inmobi.com] Sent: Thursday, February 20, 2014 8:30 PM To: user@hive.apache.org Subject: Re: Is there any monitoring tool available for hiveserver2 I have built up a c

Re: Is there any monitoring tool available for hiveserver2

I have built up a customized script for alerting and monitoring. Could not find any default way to do it. Thanks Biswajit On 21 Feb 2014 05:17, wrote: > Hi, > > > > It might happen that hiveserver2 memory gets exhausted. Similarly there > would be many other things to monitor for hiveserver2.

Is there any monitoring tool available for hiveserver2

Hi, It might happen that hiveserver2 memory gets exhausted. Similarly there would be many other things to monitor for hiveserver2. Is there any monitoring tool available in the market? I am using EMR, for FYI. Thanks, Shouvanik This message is for the

Mailing list/Forum

Good Afternoon, I would like to be taken off the forum and mailing list please. Thank you Rod Rod Asher & Associates 800-722-1030 / 206-315-6678 www.asher.com

Re: Output Avro result as JSON

One method could be to either create a custom table off of a query with a JSON serde (for instance, I've used https://github.com/rcongiu/Hive-JSON-Serde). Something like: CREATE EXTERNAL TABLE my_tmp_table ROW FORMAT SERDE 'org.openx.data.jsonserde.JsonSerDe' STORED AS TEXTFILE LOCATION '

Output Avro result as JSON

When I run a query in the hive shell for an Avro field it displays it as json. How can I accomplish then when saving to a file?

Sort by Avro field

Is it possible to sort by a field within an Avro struct? Am I doing something wrong? hive> describe logs; OK requestheader struct from deserializer year int month int day int hive> select * from logs where year = 2014 order by requestheader.timestamp; FAILED: ParseException line 1:68 mismatched

Re: Reg:Hive query with mapreduce

try this http://ysmart.cse.ohio-state.edu/online.html On Thu, Feb 20, 2014 at 5:55 PM, Ranjini Rathinam wrote: > Hi, > > How to implement the Hive query such as > > select * from table comp; > > select empId from comp where sal>12000; > > in mapreduce. > > Need to use this query in mapreduce co

Reg:Hive query with mapreduce

Hi, How to implement the Hive query such as select * from table comp; select empId from comp where sal>12000; in mapreduce. Need to use this query in mapreduce code. How to implement the above query in the code using mapreduce , JAVA. Please provide the sample code. Thanks in advance for th

Tuning Hive queries that uses underlying HBase Table

I am querying Hive table ( mapped to HBase Table ) . What are the techniques to tune the Hive query and to avoid HBase scans. Query uses multiple SPLIT and SUBSTR functions and WHERE condition something like select col1, col2, ...,count(*) from hiveTable where split( col1)[0] > timestamp1 an