1) there is no data loaded in table 2) there is no data matching to your where clause condition 3) there is mismatch in where condition
what you can do is run select * from data limit 10; this will show you if you got any data in the table. Other way to do the same is hdfs -ls on table directory. Once you are sure there is data in the table, please share your create table ddl On Thu, Oct 17, 2013 at 8:18 AM, kun yan <yankunhad...@gmail.com> wrote: > Hi all > By hive query to display， only field that does not show any results may be > what causes it? > the sql like follow > select * from data where year=2013; > hive version is 0.10 > > -- > > In the Hadoop world, I am just a novice, explore the entire Hadoop > ecosystem, I hope one day I can contribute their own code > > YanBit > yankunhad...@gmail.com > > -- Nitin Pawar
