Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive >> mail # user >> No result display

kun yan 2013-10-17, 02:48
Copy link to this message
Re: No result display
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 <[EMAIL PROTECTED]> 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
Nitin Pawar
kun yan 2013-10-17, 05:05
kun yan 2013-10-17, 05:10