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

Regression?date_filed>1591459200000 does not works in latest version #510

Open
yangjiajun2014 opened this issue Jun 9, 2020 · 2 comments
Labels
bug Something isn't working SQL

Comments

@yangjiajun2014
Copy link

I use something like date_filed>1591459200000 AND date_filed<1591718400000 to filter data.It works in 1.7.0.0.But 1.8.0.0 says it is a invalid sql

The error looks like:
{
"error": {
"reason": "Invalid SQL query",
"details": "Operator [>] cannot work with [DATE, INTEGER]. Usage: Please use compatible types from each side.",
"type": "SemanticAnalysisException"
},
"status": 400
}

@yangjiajun2014
Copy link
Author

Change date_filed>1591459200000 to date_filed>'1591459200000',it works again.

@anirudha anirudha reopened this Jun 16, 2020
@dai-chen
Copy link
Member

Hi @yangjiajun2014 , this is due to our semantic check which doesn't allow comparison date and integer for now. May need to relax this in future. But I don't remember we change this semantic analyzer in recent release. Need to double check.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
bug Something isn't working SQL
Projects
None yet
Development

No branches or pull requests

3 participants