hadoop - Precision and Scale in Hive Decimal Type -


lets have column defined decimal(18,8).

by definition, field can have total of 18 digits, 8 of can right of decimal point.

my understanding have 18 digits left of decimal point long there no values right of decimal point e.g. values between -999999999999999999 , 999999999999999999.

but after loading data hive, seeing 18 whole digits no decimal digits not conform field's data type , being loaded null

what should expected behavior here?


Comments