The "not in" issue will be fixed very soon. We are waiting for the next
Calcite release v1.6.
Kylin not yet work well with TPC-DS for two main reasons.
- Kylin supports only star schema, while TPC-DS is snowflake.
- Kylin supports a limited set of SQL functions. E.g. substr() is only
supported since Kylin v1.2 (if I remember correctly).
The first reason will likely to stay in short term. The second reason the
community is working hard to resolve.
On Thu, Jan 14, 2016 at 2:42 PM, Adunuthula, Seshu <sadunuth...@ebay.com>
wrote:
> 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" <sadunuth...@ebay.com> 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" <luke...@gmail.com> 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, 1032195...@qq.com <1032195...@qq.com>
> >>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 <1032195...@qq.com>:
> >>>
> >>> > 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
> >>>
> >
>
>
