For e.g. Query 15 in TPC-DS
select ca_zip, sum(cs_sales_price)
from catalog_sales
join customer
on catalog_sales.cs_bill_customer_sk = customer.c_customer_sk
join customer_address
on customer.c_current_addr_sk = customer_address.ca_address_sk
join date_dim
on catalog_sales.cs_sold_date_sk = date_dim.d_date_sk
where (substr(ca_zip,1,5) in ('85669', '86197','88274','83405','86475',
'85392', '85460', '80348', '81792')
or ca_state in ('CA','WA','GA')
or cs_sales_price > 500)
and d_qoy = 2 and d_year = 2001
group by ca_zip
order by ca_zip
limit 100;
Will not execute in Kylin.
On 1/13/16, 10:39 PM, "Adunuthula, Seshu" <[email protected]> wrote:
>Kylin today supports a very limited subset of SQL. In fact of the 100
>TPC-DS queries we were able to execute only 10 queries. So a lot of SQL
>generated by Tableau will not be usable by Kylin.
>
>
>On 1/8/16, 6:50 AM, "Luke Han" <[email protected]> wrote:
>
>>All SQL coming from Tableau are generated by Tableau.
>>Kylin's ODBC driver just a driver like other drivers which will be called
>>by Tableau when user drag & drop or make any other other actions.
>>
>>Please log JIRA when you facing any issue or such problem, we will look
>>into it and try to bring some test cases for further investment.
>>
>>Thanks.
>>
>>
>>Best Regards!
>>---------------------
>>
>>Luke Han
>>
>>On Fri, Jan 8, 2016 at 1:08 PM, [email protected] <[email protected]>
>>wrote:
>>
>>> Dong,
>>> OKļ¼thanks.
>>>
>>>
>>>
>>>
>>> hua wang
>>>
>>> From: Dong Li
>>> Date: 2016-01-08 11:36
>>> To: dev
>>> Subject: Re: A question about the sql generated by Tableau through
>>>Kylin
>>> ODBC
>>> Hello Hua,
>>>
>>> I'm sure we have no such logic in Kylin ODBC. In ODBC driver, we just
>>>pass
>>> user sql to Kylin rest server.
>>> To be more reasonable, maybe it should be tableau to decide whether to
>>>use
>>> IN or NOT IN?
>>>
>>> Thanks,
>>> Dong Li
>>>
>>> 2016-01-08 11:25 GMT+08:00 huawang <[email protected]>:
>>>
>>> > As "not in" filter is still a bug in Kylin's recent version, like
>>>1.2,
>>> > while sometimes the sql generated by Tableau contains "not in". I
>>>have
>>> > inquried the engineer of Tableau, they said that the sql is mainly
>>> decided
>>> > by Kylin ODBC.
>>> > I want to known in which case will the sql contains "not in"?
>>> > thanks.
>>>
>>>
>>>
>>>
>>> --
>>> Thanks,
>>> Dong
>>>
>
