wuyue92tree opened a new issue #18733:
URL: https://github.com/apache/superset/issues/18733
When make a query from kylin4, I got error like blow.
```
Error: From line 2, column 24 to line 2, column 30: Expression
'VIRTUAL_TABLE.VDATE' is not being grouped while executing SQL: "SELECT
"DOMAIN" AS "DOMAIN", CAST(FLOOR(CAST("VDATE" AS TIMESTAMP) TO DAY) AS DATE) AS
"VDATE", count(*) AS "count" FROM (Select VDATE, DOMAIN from STG.S_HAPROXY_LOG)
AS virtual_table WHERE "VDATE" < '2022-02-15 00:00:00.000000' GROUP BY
"DOMAIN", CAST(FLOOR(CAST("VDATE" AS TIMESTAMP) TO DAY) AS DATE) ORDER BY
"count" DESC LIMIT 10000"
```
- superset version: 1.3.2
- kylin version: 4.0.1
- spark version: 2.4.7
#### How to reproduce the bug
```
# sql generate by superset
SELECT "DOMAIN" AS "DOMAIN",
CAST(FLOOR(CAST("VDATE" AS TIMESTAMP) TO DAY) AS DATE) AS "VDATE",
count(*) AS "count"
FROM
(Select VDATE,
DOMAIN
from STG.S_HAPROXY_LOG) AS virtual_table
WHERE "VDATE" < '2022-02-15 00:00:00.000000'
GROUP BY "DOMAIN",
CAST(FLOOR(CAST("VDATE" AS TIMESTAMP) TO DAY) AS DATE)
ORDER BY "count" DESC
LIMIT 10000;
```
### THINKING
kylin4 use spark as engine only，but spark not support `FLOOR` function like
hive
spark sql
hsql
So, any suggestion to fix this? ☺
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
