CODEWITHSUNDEEP
hive
Srikanth
Srikanth

Reputation: 15

hive 0.11 decimal precision error

I am trying to create a hive table with decimal precision column. For some reason, I could able to create column of datatype decimal but not with precision.Eg: b decimal is OK, but for b decimal(3,3). I keep getting error

mismatched input '(' excepting ) near 'decimal' in create table statement.

Hive> create table testbd.test1_decimal (b decimal (3,3));

Upvotes: 0

Views: 953

Answers (1)

Remus Rusanu
Remus Rusanu

Reputation: 294307

Hive 0.11 does not support precision and scale for decimal. HIVE-3976 added support for decimal scale and precision, and is available in Hive 0.13.

Upvotes: 1

Related Questions