uot;+" ... "-" ... "*" ... "/"
> ... "||" ... "AND" ... "OR" ... "IS" ... "MEMBER" ... "SUBMULTISET" ...
> "MULTISET" ... "[" ... "OVERLAPS" ... "YEAR" ...
"=" ... ">" ... "<"
... "<=" ... ">=" ... "<>" ... "+" ... "-" ... "*" ... "/" ... "||" ... "AND"
... "OR" ... "IS" ... "MEMBER" ...
Kylin supports left join and inner join. The right join could be rewritten
into left join. Could you have a try?
2016-12-21 11:52 GMT+08:00 wang...@snqu.com :
> Hi
> when I excute the sql:
> (select t3.CATE1,count(*) from (select CATE1 ,CATE2 from
> kylinlabel.USER_TAG
Hi
when I excute the sql:
(select t3.CATE1,count(*) from (select CATE1 ,CATE2 from kylinlabel.USER_TAG
group by CATE1 ,CATE2) as t3 group by t3.CATE1) as t4
right join
(select cate1 from kylinlabel.USER_TAG group by cate1) as t5 on
(t4.cate1=t5.cate1)
I got the error:
Encountered "as"