Good question - Beam DECIMAL is arbitrary precision, so is probably a better fit for BIGNUMERIC.
On Thu, Mar 18, 2021 at 12:00 PM Vachan Shetty <vac...@google.com> wrote: > Hello, I am currently trying to add support for BigQuery's new BIGNUMERIC > datatype [1] in Beam's BigQueryIO. I am currently following the steps that > were used for adding the NUMERIC datatype [2]. AFAICT Beam's DECIMAL is > the most appropriate datatype to map to BIGNUMERIC in BQ. However, the > Beam DECIMAL datatype is already mapped to NUMERIC in BQ [2, 3]. Given > this, should I simply map all Beam DECIMAL to BQ BIGNUMERIC? Or should this > conversion be done based on other information? [1]: > https://cloud.google.com/bigquery/docs/reference/standard-sql/data-types#decimal_types > [2]: https://issues.apache.org/jira/browse/BEAM-4417 [3]: > https://github.com/apache/beam/blob/master/sdks/java/io/google-cloud-platform/src/main/java/org/apache/beam/sdk/io/gcp/bigquery/BigQueryUtils.java#L188 >
