[ https://issues.apache.org/jira/browse/BEAM-8910?focusedWorklogId=436172&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-436172 ]
ASF GitHub Bot logged work on BEAM-8910: ---------------------------------------- Author: ASF GitHub Bot Created on: 21/May/20 19:52 Start Date: 21/May/20 19:52 Worklog Time Spent: 10m Work Description: pabloem commented on a change in pull request #11086: URL: https://github.com/apache/beam/pull/11086#discussion_r428877884 ########## File path: sdks/python/apache_beam/io/gcp/bigquery.py ########## @@ -610,7 +611,8 @@ def __init__( coder=None, use_standard_sql=False, flatten_results=True, - kms_key=None): + kms_key=None, + use_json_exports=False): Review comment: Restarting this discussion after some rebasing and preparing... I think I'd prefer to allow users to choose the export file format. This is what we do for writing to BQ in Java and Python. Allowing users to choose output type for specific column types would add overhead of (if avro and json_format_bytes: formatbytes; if avro and json_datetime_format: formatdatetime; if not avro and not json_format_bytes: formatbytes; ...). We can discourage users from using JSON (AVRO is already the default) - and eventually stop supporting it if that makes sense. Thoughts? ---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org Issue Time Tracking ------------------- Worklog Id: (was: 436172) Time Spent: 12.5h (was: 12h 20m) > Use AVRO instead of JSON in BigQuery bounded source. > ---------------------------------------------------- > > Key: BEAM-8910 > URL: https://issues.apache.org/jira/browse/BEAM-8910 > Project: Beam > Issue Type: Improvement > Components: sdk-py-core > Reporter: Kamil Wasilewski > Assignee: Pablo Estrada > Priority: P3 > Time Spent: 12.5h > Remaining Estimate: 0h > > The proposed BigQuery bounded source in Python SDK (see PR: > [https://github.com/apache/beam/pull/9772)] uses a BigQuery export job to > take a snapshot of the table and read from each produced JSON file. A > performance improvement can be gain by switching to AVRO instead. -- This message was sent by Atlassian Jira (v8.3.4#803005)