[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[jira] [Created] (FLINK-9864) Make timestamp extraction more flexible in SQL Client

Timo Walther created FLINK-9864:

             Summary: Make timestamp extraction more flexible in SQL Client
                 Key: FLINK-9864
                 URL: https://issues.apache.org/jira/browse/FLINK-9864
             Project: Flink
          Issue Type: New Feature
          Components: Table API & SQL
            Reporter: Timo Walther
            Assignee: Timo Walther

Currently, a timestamp must be in the top-level of a possibly nested row and must have a certain format. We should think about making this more flexible to cover most of the use cases.

A first solution could be to allow a DOT operator syntax: {{myfield.nested.timestamp}}
Other cases might be:
- The time could also be split into several field
- Or needs to be parsed using a [date format syntax|https://ci.apache.org/projects/flink/flink-docs-master/dev/table/sql.html#date-format-specifier].

This message was sent by Atlassian JIRA