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 <teddyyyy...@gmail.com> 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
