Do you even have a table name 'dual' or not?
On Thu, Oct 18, 2012 at 2:24 PM, fellowtree <fellowt...@163.com> 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