HIVE 0.12 SUM() returning NULL for decimal values

I am trying to aggregate one column of decimal type, which is returning me null. If I cast this column to double it returns me some value. following are the steps to recreate this scenario. CREATE TABLE salestemp(sku int, sales decimal); LOAD DATA LOCAL INPATH '0

Re: Wrapping an analytical function

Hi Frans, I am also getting same error while using analytical functions with case expression FAILED: ParseException line 3:19 missing KW_END at 'over' near '' it is not allowing to use arithmetic operators with analytical function as well NoViableAltException(273@[129:7: ( ( ( KW_AS )? identifi

Re: Error while table creation

amp...@thinkbiganalytics.com> wrote: > If you upgrade Hive, you have to do a upgrade/migration on the metastore > database. There are scripts that come with hive distributions for this. If > you're starting from scratch, you could just drop the old database. > > > On Sun, Mar 10, 2013

Re: Error while table creation

TABLE IF NOT EXISTS my_table ( > > ... > ... > ... > ) > > > > On Sun, Mar 10, 2013 at 2:34 AM, Viral Bajaria wrote: > >> Is this is a new installation of Hive or did you upgrade ? How many >> tables do you already have ? >> >> >> On Sat, Mar

Error while table creation

while trying to create external table in oozie hive action, I am getting following error, hive version is 0.9.0 Caused by: javax.jdo.JDODataStoreException: Insert of object "org.apache.hadoop.hive.metastore.model.MColumnDescriptor@46c1dc0b" using statement "INSERT INTO `CDS` (`CD_ID`) VALUES (?)"