4paradigm / 4paradigm/OpenMLDB

work with dates before 1900 or timestamp before 1970

Open
#3,501 2 comments 0 reactions 1 assignee Claimed by @aceforeverd View on GitHub
bug execute-engine
Dominant language
C++
Stars
1.7k
Forks
331
Avg merge
12d 12h
Merged PRs (30d)
1

Description

One approach: both type are string from storage, following a standard like [ISO 8601](https://en.wikipedia.org/wiki/ISO_8601). The SQL execute engine parse it into the date and timestamp type that supports it, which are the internal structure do not counts to user

Contributor guide

Open the contributing guide

Research direction

The issue describes storing dates before 1900 and timestamps before 1970 as ISO 8601 strings in storage, with the SQL engine parsing them into internal date/timestamp types. Research the storage layer and SQL execution engine code to understand current date/time handling. Look for existing date and timestamp type implementations and parsing logic. Determine what changes are needed to support the extended range and ensure consistent feature computation for machine learning.

Written by the indexing model from the issue text.

Assessment

Tech stack
sql
Domain
databases, machine-learning
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.