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
