Can you paste a sample line of your data on HDFS and which column you are trying to query?
Thanks Nanda Vijaydev On Mon, May 14, 2012 at 11:40 AM, Sukhendu Chakraborty < sukhendu.chakrabo...@gmail.com> wrote: > Are NaNs and/or Infinity supported in HIVE? If yes, I wanted to know > how are NaNs and Infinity values represented in HDFS files to be > interpreted correctly in Hive. > > When I do 'select 1/0 from tab', I get a text value, "Infinity". > However, when I enter "Infinity" v in my HDFS file represented by the > HIVE table (the column datatype of the table is int), and then do a > select, I get 'NULL' (and not Infinity). > > I am working with HIVE 0.7.1. > > Thanks, > -Sukhendu >
