title: oracle NUMBER to hive
body: <p>oracle DB is storing values as NUMBER, which from my understanding is max precision and scale.  However hive documentation states that if you set DECIMAL with no precision or scale you will get DECIMAL(10,0) <a href="https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Types#LanguageManualTypes-decimal" rel="nofollow noreferrer">doc</a>.  What would the correct HIVE datatype be to accommodate ORACLE NUMBER. </p>