SQL: Introduce proper SQL DATE type #37340
Assignees
Labels
Comments
|
Pinging @elastic/es-search |
|
Created a new issue: #37692 to track the |
matriv
added a commit
to matriv/elasticsearch
that referenced
this issue
Jan 22, 2019
Support ANSI SQL's DATE type by introducing a runtime-only ES SQL date type. Closes: elastic#37340
matriv
added a commit
that referenced
this issue
Jan 24, 2019
* SQL: Introduce SQL DATE data type Support ANSI SQL's DATE type by introducing a runtime-only ES SQL date type. Closes: #37340
matriv
added a commit
that referenced
this issue
Jan 24, 2019
Support ANSI SQL's DATE type by introducing a runtime-only ES SQL date type. Closes: #37340
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
In the spirit of #36440, ES SQL should be able to support a proper, date-only data type. As ANSI SQL already defines one through
DATEonce #36440 complete, ES SQL could haveDataType.DATEadded to describe a DATE only type.Being a new date-time type, all date-related functionalities would need to take it into account:
a. grouping and histograms
The latter in particular should have the minimum interval of 1 day
b. date-time functions
As most work on the date component this is mainly a validation task
c. date-time math
Adding or extracting an interval. Worth looking into whether
DATE-DATEmakes sense or whether we should add a date function (e.g.DATE_DIFF).The text was updated successfully, but these errors were encountered: