kylin-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Billy Liu <billy...@apache.org>
Subject Re: tableau extract month in where
Date Tue, 17 Jan 2017 12:34:40 GMT
One workaround is to define a new column with "EXTRACT(MONTH  FROM
"TEST_ORDERFACT"."DADD")"  by Hive view.

2017-01-17 20:22 GMT+08:00 Тарасов Павел <p.tarasov@cian.ru>:

> Hi,
>
> I’ve problem with tableau & kylin connect. When creating filter on month
> in tableau it generate query with filter
>
> WHERE (({fn EXTRACT(MONTH  FROM "TEST_ORDERFACT"."DADD")} - 1) / 3 + 1 = 2)
>
> and kylin fails on such queries. Is there way to solve this problem?
>
> Best regards,
> Pavel Tarasov

Mime
View raw message