CAST(CAST(col AS DOUBLE) AS BIGINT) Zheng
On Thu, Sep 10, 2009 at 10:10 PM, Mayuran Yogarajah < [email protected]> wrote: > Zheng Shao wrote: > >> You need to run "add jar" before running the SELECT command. >> >> Don't copy it to $hadoop_dir/lib - That will make upgrading Hive much >> harder. >> >> Zheng >> > Ahh that worked! Thanks so much! > > I'm seeing output like this, I'm guessing its because I've had to make all > the columns STRING. > 7.1096627E7 > > Is there some way to have Hive convert this to a number automatically ? > > thanks > -- Yours, Zheng
