You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@hive.apache.org by ar...@o2.pl on 2011/01/12 00:18:02 UTC

DOUBLE type in HIVE

Hi again,
How can I load the data from an external file whose contents are DOUBLE type data, example: 
1.997459983825683594e+01
1.997089958190917969e+01
1.996719932556152344e+01
1.996349906921386719e+01
When I am doing INSERT to (foo DOUBLE) it truncates "e+01".
And that is the problem, becouse I need it. It cant be STRING type as well.

Best regards
Peter.