Re:

2015-02-24 Thread Srinivas Thunga
Hi, Can you place the query as well which you are trying? *Thanks & Regards,* *Srinivas T* On Wed, Feb 25, 2015 at 1:02 PM, Jadhav Shweta wrote: > Hi > > I am trying to run hive query > Its getting executed from beeline interface > but its throwing > >java.lang.OutOfMemoryError: Java h

[no subject]

2015-02-24 Thread Jadhav Shweta
Hi I am trying to run hive query Its getting executed from beeline interface but its throwing java.lang.OutOfMemoryError: Java heap space error when connecting using jdbc. I am using hive 0.13.0 version and hiveserver2. which parameters i need to configure for the same. thanks Shweta Jadhav =

Questions about Hive UDF cache under the hood

2015-02-24 Thread r7raul1...@163.com
Hi everyone, Consider the sql : SELECT thumbnail( product_ image ) FROM advert i sements WHERE product_name = ‘ Brownie’ ; The product_ image field is a reference to a multi-megabyte image object. The thumbnail method reads in this object,

Re: Re: How to query data by page in Hive?

2015-02-24 Thread r7raul1...@163.com
Thank you ~ r7raul1...@163.com From: Devopam Mittra Date: 2015-02-24 20:15 To: user@hive.apache.org Subject: Re: Re: How to query data by page in Hive? Apologies for the extended delay in providing response. I totally forgot about this one and got stuck in other things. Please find below a s

Re: 38 digits vs 35 digits for Decimal type?

2015-02-24 Thread Yang
sorry my bad the doc from hive says 38 bits, I misread that. didn't intend to send the last email and thought it has been in "draft " box only...

Querying Uniontype with Hive

2015-02-24 Thread Buntu Dev
Hi, This might've been asked previously but I couldn't find any examples of how to query uniontype in Hive. I have this field in the table: `location` uniontype,boolean> How do I go about querying: "select location.latitiude, location.latitude from ..." since I get this error: . Operator is on

Re: Re: How to query data by page in Hive?

2015-02-24 Thread Devopam Mittra
Apologies for the extended delay in providing response. I totally forgot about this one and got stuck in other things. Please find below a sample I created based on the inputs received. CREATE TABLE u_data( userid int, movieid int, rating int, unixtime string) ROW FORMAT DELIMITED FIELDS TERMINAT