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

Switch to Threaded View
Hive >> mail # user >> why i get Table not found 'dual'

Copy link to this message
Re: why i get Table not found 'dual'
Do you even have a table name 'dual' or not?

On Thu, Oct 18, 2012 at 2:24 PM, fellowtree <[EMAIL PROTECTED]> wrote:
> hi all:
>      some one said hive support sql like  select if(1=2,100,200) from dual;
> however i always get Table not found 'dual' . my hive is 0.9.0 and what is
> the reason?
> ________________________________
> fellowtree