You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@beam.apache.org by "Saman Vaisipour (Jira)" <ji...@apache.org> on 2019/12/18 19:02:00 UTC

[jira] [Comment Edited] (BEAM-8898) Enable WriteToBigQuery to perform range partitioning

    [ https://issues.apache.org/jira/browse/BEAM-8898?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16999435#comment-16999435 ] 

Saman Vaisipour edited comment on BEAM-8898 at 12/18/19 7:01 PM:
-----------------------------------------------------------------

Thanks Pablo, looking forward to using this feature in new BQ sink. FYI, the BigQuery team has announced the beta launch of integer range partitioning:

[https://cloud.google.com/bigquery/docs/creating-integer-range-partitions]


was (Author: samanvp):
Thanks Pablo, looking forward to using this feature in new BQ sink. FYI, 

The BigQuery team has announced the beta launch of integer range partitioning:

[https://cloud.google.com/bigquery/docs/creating-integer-range-partitions]

> Enable WriteToBigQuery to perform range partitioning
> ----------------------------------------------------
>
>                 Key: BEAM-8898
>                 URL: https://issues.apache.org/jira/browse/BEAM-8898
>             Project: Beam
>          Issue Type: New Feature
>          Components: io-py-gcp
>            Reporter: Saman Vaisipour
>            Priority: Minor
>          Time Spent: 1h 20m
>  Remaining Estimate: 0h
>
> BigQuery team recently [released 1.22.0|https://github.com/googleapis/google-cloud-python/releases/tag/bigquery-1.22.0] which includes the range partitioning feature (here is [an example|https://github.com/googleapis/google-cloud-python/blob/c4a69d44ccea9635b3d9d316b3f545f16538dafe/bigquery/samples/create_table_range_partitioned.py]). 
> WriteToBigQuery uses [`additional_bq_parameters`|https://github.com/apache/beam/blob/c1719476b74ec6f68fabea392087607adafc70ef/sdks/python/apache_beam/io/gcp/bigquery.py#L177] to create tables with date partitioning and clustering. It would be great if the same would be possible to create tables with range partitioning.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)