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'
MiaoMiao 2012-10-18, 06:29
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