hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nitin Pawar <nitinpawar...@gmail.com>
Subject Re: No result display
Date Thu, 17 Oct 2013 04:50:52 GMT
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 <yankunhadoop@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
> yankunhadoop@gmail.com
>
>


-- 
Nitin Pawar

Mime
View raw message