Skip to content

BigQuery: fails with Joda LocalDateTime when using default method #5596

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Open
turb opened this issue Feb 4, 2025 · 0 comments
Open

BigQuery: fails with Joda LocalDateTime when using default method #5596

turb opened this issue Feb 4, 2025 · 0 comments

Comments

@turb
Copy link
Contributor

turb commented Feb 4, 2025

AFAIK BigQueryIO supports Joda, not java.time (which gives compile error Unsupported type: java.time.LocalDateTime @com.spotify.scio.bigquery.types.BigQueryTag)

However, if a BigQuery entity contains a property with type org.joda.time.LocalDateTime:

  • saveAsTypedBigQueryTable with method = Method.STORAGE_WRITE_API works
  • however the same with default method (Method.DEFAULT) fails with:
"errorResult": {
      "location": "query",
      "message": "Field theDateTime has incompatible types. Configured schema: datetime; Avro file: string.",
      "reason": "invalidQuery"
    }
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant