[Task]: Use Timestamp logical type in Beam SQL

Open
#40,454 1 comment 0 reactions 0 assignees View on GitHub

Maintainers usually reply within 1 day

Nobody has claimed this yet.

Assessment

Difficulty
5/5
Estimated time
Over a week
Newbie friendliness
25/100
Issue type
Feature
Clarity
Mostly clear
Activity status
Active
Tech stack
java
Domain
databases

Research direction

Start by tracing how Beam SQL maps SQL TIMESTAMP to FieldType.DATETIME and how Calcite represents timestamp precision. The issue makes the change conditional on Beam SQL and Calcite preserving microsecond precision end-to-end; verify that prerequisite before considering an implementation. Done means SQL TIMESTAMP defaults to Timestamp.MICROS (or an equivalent type) without losing microsecond precision.

Written by the indexing model from the issue text.

Description

awaiting triage P2 task
What needs to happen?

Default SQL TIMESTAMP to Timestamp.MICROS (or equivalent) instead of FieldType.DATETIME once Beam SQL / Calcite can preserve microsecond precision end-to-end.

Issue Priority

Priority: 2 (default / most normal work should be filed as P2)

Issue Components
  • Component: Python SDK
  • Component: Java SDK
  • Component: Go SDK
  • Component: Typescript SDK
  • Component: IO connector
  • Component: Beam YAML
  • Component: Beam examples
  • Component: Beam playground
  • Component: Beam katas
  • Component: Website
  • Component: Infrastructure
  • Component: Spark Runner
  • Component: Flink Runner
  • Component: Prism Runner
  • Component: Twister2 Runner
  • Component: Hazelcast Jet Runner
  • Component: Google Cloud Dataflow Runner
Dominant language
Java
Stars
8.7k
Forks
4.8k
Avg merge
2d 9h
Merged PRs (30d)
368

Getting set up

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

More from apache/beam

All issues in apache/beam

Similar issues

More Java issues

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.