Skip to content

Conversation

@lqiu96
Copy link
Member

@lqiu96 lqiu96 commented Dec 8, 2025

See b/447623336 for more information.

Helper method validateTimestamp() is able to validate timestamps in ISO8601 format with more than nanosecond precision with custom logic. Otherwise, default to using JDK's DateTimeFormatter to validate for ISO8601 strings.

@lqiu96 lqiu96 requested a review from jinseopkim0 December 8, 2025 19:35
@lqiu96 lqiu96 requested review from a team as code owners December 8, 2025 19:35
@product-auto-label product-auto-label bot added size: m Pull request size is medium. api: bigquery Issues related to the googleapis/java-bigquery API. labels Dec 8, 2025
@gemini-code-assist
Copy link
Contributor

Summary of Changes

Hello @lqiu96, I'm Gemini Code Assist1! I'm currently reviewing this pull request and will post my feedback shortly. In the meantime, here's a summary to help you and other reviewers quickly get up to speed!

This pull request addresses a limitation in timestamp handling within the google-cloud-bigquery library by enabling the QueryParameterValue class to correctly parse and validate ISO8601 timestamp strings with precision greater than nanoseconds, specifically up to picoseconds. This enhancement provides more flexibility for users dealing with high-precision time data by introducing a custom validation logic that complements the standard JDK DateTimeFormatter capabilities.

Highlights

  • Enhanced Timestamp Precision: The QueryParameterValue class now supports ISO8601 timestamp strings with precision up to picoseconds (12 fractional digits), extending beyond the previous nanosecond limit.
  • Custom Timestamp Validation: A new helper method, checkValidTimestamp(), has been introduced to validate ISO8601 timestamps that have more than nanosecond precision, using a combination of regex and DateTimeFormatter.
  • Clarified Precision for Long Timestamps: The timestamp(Long value) method's Javadoc has been updated to explicitly state that it only supports microsecond precision.
  • Updated Test Coverage: New test cases have been added to QueryParameterValueTest.java to verify the correct handling of timestamps with 10 and 12 fractional digits, as well as to ensure proper error handling for invalid or excessively precise timestamps.
Using Gemini Code Assist

The full guide for Gemini Code Assist can be found on our documentation page, here are some quick tips.

Invoking Gemini

You can request assistance from Gemini at any point by creating a comment using either /gemini <command> or @gemini-code-assist <command>. Below is a summary of the supported commands on the current page.

Feature Command Description
Code Review /gemini review Performs a code review for the current pull request in its current state.
Pull Request Summary /gemini summary Provides a summary of the current pull request in its current state.
Comment @gemini-code-assist Responds in comments when explicitly tagged, both in pull request comments and review comments.
Help /gemini help Displays a list of available commands.

Customization

To customize Gemini Code Assist for GitHub experience, repository maintainers can create a configuration file and/or provide a custom code review style guide (such as PEP-8 for Python) by creating and adding files to a .gemini/ folder in the base of the repository. Detailed instructions can be found here.

Limitations & Feedback

Gemini Code Assist may make mistakes. Please leave feedback on any instances where its feedback is incorrect or counter productive. You can react with 👍 and 👎 on @gemini-code-assist comments. If you're interested in giving your feedback about your experience with Gemini Code Assist for Github and other Google products, sign up here.

You can also get AI-powered code generation, chat, as well as code reviews directly in the IDE at no cost with the Gemini Code Assist IDE Extension.

Footnotes

  1. Review the Privacy Notices, Generative AI Prohibited Use Policy, Terms of Service, and learn how to configure Gemini Code Assist in GitHub here. Gemini can make mistakes, so double check it and use code with caution.

Copy link
Contributor

@gemini-code-assist gemini-code-assist bot left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Code Review

This pull request introduces support for high-precision ISO8601 timestamps (up to picoseconds) by adding a custom validator. The changes look good overall, with corresponding updates to Javadocs and tests.

My review includes a few suggestions to improve the implementation and tests:

  • Refactor the timestamp validation logic to provide more accurate error messages for timestamps exceeding picosecond precision and to remove some redundant code. This involves updating the regex pattern as well.
  • Clean up the test suite by removing commented-out test cases and making some invalid-timestamp tests more specific to avoid ambiguity.

@lqiu96
Copy link
Member Author

lqiu96 commented Dec 8, 2025

/gemini review

Copy link
Contributor

@gemini-code-assist gemini-code-assist bot left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Code Review

This pull request effectively adds support for high-precision ISO8601 timestamps, up to picoseconds, by introducing a custom validation method. The approach of using a regular expression to handle high-precision cases while leveraging the existing DateTimeFormatter for standard validation is well-designed. The accompanying changes, such as renaming constants to align with Java conventions and significantly enhancing the test suite with comprehensive valid and invalid timestamp cases, are excellent improvements. I have one suggestion to enhance the robustness of the string manipulation logic in the new validation method.

@lqiu96
Copy link
Member Author

lqiu96 commented Dec 8, 2025

/gemini review

Copy link
Contributor

@gemini-code-assist gemini-code-assist bot left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Code Review

This pull request introduces support for ISO8601 timestamps with precision greater than nanoseconds (up to picoseconds). The implementation correctly uses a regular expression to identify and truncate high-precision timestamps before validating them with the standard DateTimeFormatter. The changes are well-tested with new unit tests covering various precision levels and invalid formats. My review includes one suggestion to improve test code maintainability by reducing duplication.

@lqiu96 lqiu96 merged commit 5a51a51 into main Dec 8, 2025
24 checks passed
@lqiu96 lqiu96 deleted the custom-timestamp-validator branch December 8, 2025 22:07
diegomarquezp pushed a commit that referenced this pull request Dec 15, 2025
…e than nanosecond precision (#4017)

* chore: Use custom timestamp validator for ISO8601 timestamps with more than nanosecond precision

* chore: Rename helper method to validateTimestamp

* chore: Address GCA comments

* chore: Address last GCA comment

* chore: Update to use assert helper method
diegomarquezp added a commit that referenced this pull request Dec 15, 2025
* chore: sync with last release from main branch

* feat: Introduce DataFormatOptions to configure the output of BigQuery data types (#4010)

* feat: Create DataFormatOptions in BigQuery

* feat: Add Builder class for DataFormatOptions

* fix: Update existing references of useInt64Timestamp to use DataFormatOption's variant

* chore: Fix lint issues

* chore: Address PR feedback

* chore: Add tests for useInt64Timestamp behavior

* chore: Address failing tests and GCA

* chore: Remove unused fromPb method

* feat: Add timestamp_precision to Field (#4014)

* feat: Add timestamp_precision to Field

* Apply suggestion from @gemini-code-assist[bot]

Co-authored-by: gemini-code-assist[bot] <176961590+gemini-code-assist[bot]@users.noreply.github.com>

* chore: Address GCA PR feedback

* chore: Fix typo

* chore: Remove default value

* chore: Address PR feedback

---------

Co-authored-by: gemini-code-assist[bot] <176961590+gemini-code-assist[bot]@users.noreply.github.com>

* chore: Use custom timestamp validator for ISO8601 timestamps with more than nanosecond precision (#4017)

* chore: Use custom timestamp validator for ISO8601 timestamps with more than nanosecond precision

* chore: Rename helper method to validateTimestamp

* chore: Address GCA comments

* chore: Address last GCA comment

* chore: Update to use assert helper method

* test: Clean up resources created in ITs (#4024)

* chore: Cleanup initialized resources

* chore: Delete created dataset

* chore: Use try-with to close stream

* chore: Cleanup Intellij test warnings (#4026)

* chore: Cleanup initialized resources

* chore: Use try-with to close stream

* chore: Cleanup Intellij test warnings

* chore: Allow for floating point inaccuracies

* chore: Add otel delete operation

* deps: update actions/upload-artifact action to v6 (#4027)

Co-authored-by: Blake Li <blakeli@google.com>

* chore: Use assertThrows in tests (#4028)

* chore: Cleanup initialized resources

* chore: Use try-with to close stream

* chore: Cleanup Intellij test warnings

* chore: Allow for floating point inaccuracies

* chore: Add otel delete operation

* chore: Clean up rest of the IT test file

* chore: Add GCA feedback

* chore: Update renovate.json (#4031)

deps update from bigquerystorage was incorrectly marked as chore(deps). This would cause the upgrade not show up in the release notes and also not trigger release please.

This is because the pattern /^com.google.cloud:google-cloud-bigquery is configured in renovate.json, which matches both bigquery and bigquerystorage. However, I believe the original intention is only for bigquery update in samples, not for bigquerystorage update.

Fixing the pattern so that the String must ends with bigquery

* chore(main): release 2.57.2-SNAPSHOT (#4032)

Co-authored-by: release-please[bot] <55107282+release-please[bot]@users.noreply.github.com>

* chore: fix unresolved conflicts

---------

Co-authored-by: Lawrence Qiu <lawrenceqiu@google.com>
Co-authored-by: gemini-code-assist[bot] <176961590+gemini-code-assist[bot]@users.noreply.github.com>
Co-authored-by: Mend Renovate <bot@renovateapp.com>
Co-authored-by: Blake Li <blakeli@google.com>
Co-authored-by: release-please[bot] <55107282+release-please[bot]@users.noreply.github.com>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

api: bigquery Issues related to the googleapis/java-bigquery API. size: m Pull request size is medium.

Projects

None yet

Development

Successfully merging this pull request may close these issues.

2 participants