Skip to content
This repository has been archived by the owner on Aug 2, 2022. It is now read-only.

group by 1 isn't working in new engine #867

Closed
rupal-bq opened this issue Nov 30, 2020 · 0 comments
Closed

group by 1 isn't working in new engine #867

rupal-bq opened this issue Nov 30, 2020 · 0 comments

Comments

@rupal-bq
Copy link
Contributor

Query:

 SELECT DATE_ADD(`calcs`.`date2`, INTERVAL 1 MONTH) AS `TEMP(Test)(2799254343)(0)` FROM `calcs` GROUP BY 1 

Error:

{
    "error": {
        "type": "IllegalStateException",
        "reason": "Unsupported type DATETIME to construct expression value from object for field: DATE_ADD(calcs.date2, Interval(value=1, unit=MONTH)), value: 1972-08-12.",
        "details": "Unsupported type DATETIME to construct expression value from object for field: DATE_ADD(calcs.date2, Interval(value=1, unit=MONTH)), value: 1972-08-12."
    },
    "status": 503
}

Was able to get a successful response after removing group by 1 from the query.

rupal-bq pushed a commit to rupal-bq/sql that referenced this issue Dec 8, 2020
penghuo pushed a commit that referenced this issue Dec 8, 2020
* add date & time

* add datetime

* try comparison test

* add manual IT

* add integration test for issue #867

Co-authored-by: Rupal Mahajan <>
@penghuo penghuo closed this as completed Dec 8, 2020
joshuali925 pushed a commit that referenced this issue Dec 9, 2020
* add date & time

* add datetime

* try comparison test

* add manual IT

* add integration test for issue #867

Co-authored-by: Rupal Mahajan <>
penghuo pushed a commit that referenced this issue Dec 15, 2020
* add date & time

* add datetime

* try comparison test

* add manual IT

* add integration test for issue #867

Co-authored-by: Rupal Mahajan <>
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants