Re: Re: kylin 1.6 supports SQL right join

2016-12-22 Thread Li Yang
uot;+" ... "-" ... "*" ... "/" > ... "||" ... "AND" ... "OR" ... "IS" ... "MEMBER" ... "SUBMULTISET" ... > "MULTISET" ... "[" ... "OVERLAPS" ... "YEAR" ...

Re: Re: kylin 1.6 supports SQL right join

2016-12-20 Thread wang...@snqu.com
"=" ... ">" ... "<" ... "<=" ... ">=" ... "<>" ... "+" ... "-" ... "*" ... "/" ... "||" ... "AND" ... "OR" ... "IS" ... "MEMBER" ...

Re: kylin 1.6 supports SQL right join

2016-12-20 Thread Billy Liu
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

kylin 1.6 supports SQL right join

2016-12-20 Thread wang...@snqu.com
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"