Re: varchar

Hi, I have a created a table with fields defined as varchar(length). Is it correct to insert data in to the table casting the fields as VARCHAR(length). I am getting this error. Error occurred executing hive query: OK FAILED: SemanticException Generate Map Join Task Error: Class cannot be created

varchar

Hi, I have a created a table with fields defined as varchar(length). Is it correct to insert data in to the table casting the fields as VARCHAR(length). I am getting this error. Error occurred executing hive query: OK FAILED: SemanticException Generate Map Join Task Error: Class cannot be created

Re: Reg: Controlling number of Precision digits

Thanks Bala. On Tue, Aug 26, 2014 at 11:31 AM, Bala Krishna Gangisetty < b...@altiscale.com> wrote: > I suppose your query is against HIVE, you can take advantage of round() > built-in UDF function. > > --Bala G. > > > On Tue, Aug 26, 2014 at 11:24 AM, upd r wrote:

Reg: Controlling number of Precision digits

Hi, Can someone please tell me if there is a way to alter the precision digits for a double/float data type to 2 or 3. Eg: 232879.7979879 to 232879.79 Thanks, UPD

Hive Query (Replace)

Hi Everyone, Is there a way to ignore a particular character in hive query. Example Table1 Field name: empName Value : xx! Is there a way to remove '!' cause this prevents some join operations with another table containing the exact same values other than this column with a '!' in its value