how do you know that DECIMAL gives only 35 digits? 发自我的 iPhone
> 在 2015年2月22日，00:23，Owen O'Malley <[email protected]> 写道： > > Hive decimal supports 38 digits also. It is a natural size since it fits in > 127 bits. > > .. Owen > >> On Feb 21, 2015, at 07:35, Yang <[email protected]> wrote: >> >> If I were to transfer a table from existing oracle to hive, I'd find it >> impossible with NUMBER type columns. By default oracle NUMBER gives 38 >> bits, but hive's closest counterpart is the DECIMAL , which gives only 35 >> digits >> >> I'm curious how is the 35 digits determined when the DECIMAL type was >> introduced? Why not follow oracle convention? Right now what is my best >> strategy for copying a table with NUMBER column from oracle to hive? >> >> Thanks >> Yang
