[ 
https://issues.apache.org/jira/browse/BEAM-9411?focusedWorklogId=400319&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-400319
 ]

ASF GitHub Bot logged work on BEAM-9411:
----------------------------------------

                Author: ASF GitHub Bot
            Created on: 09/Mar/20 19:10
            Start Date: 09/Mar/20 19:10
    Worklog Time Spent: 10m 
      Work Description: apilloud commented on pull request #11003: [BEAM-9411] 
Enable BigQuery DIRECT_READ by default in SQL
URL: https://github.com/apache/beam/pull/11003#discussion_r389903110
 
 

 ##########
 File path: 
sdks/java/extensions/sql/datacatalog/src/test/java/org/apache/beam/sdk/extensions/sql/meta/provider/datacatalog/DataCatalogBigQueryIT.java
 ##########
 @@ -69,9 +73,18 @@
 
     @Test
     public void testRead() throws Exception {
-      bigQuery.insertRows(ID_NAME_SCHEMA, row(1, "name1"), row(2, "name2"), 
row(3, "name3"));
-
       TableReference bqTable = bigQuery.tableReference();
+
+      // Streaming inserts do not work with DIRECT_READ mode, there is a 
several hour lag.
+      PCollection<Row> data =
+          writePipeline.apply(Create.of(row(1, "name1"), row(2, "name2"), 
row(3, "name3")));
+      data.apply(
+          BigQueryIO.<Row>write()
+              .withSchema(BigQueryUtils.toTableSchema(ID_NAME_SCHEMA))
+              .withFormatFunction(BigQueryUtils.toTableRow())
 
 Review comment:
   Done
 
----------------------------------------------------------------
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:
[email protected]


Issue Time Tracking
-------------------

    Worklog Id:     (was: 400319)
    Time Spent: 3h 20m  (was: 3h 10m)

> Use BigQuery DIRECT_READ by default for SQL
> -------------------------------------------
>
>                 Key: BEAM-9411
>                 URL: https://issues.apache.org/jira/browse/BEAM-9411
>             Project: Beam
>          Issue Type: New Feature
>          Components: dsl-sql
>            Reporter: Andrew Pilloud
>            Assignee: Andrew Pilloud
>            Priority: Major
>          Time Spent: 3h 20m
>  Remaining Estimate: 0h
>
> The BigQuery DIRECT_READ mode is available globally as of January 17, we 
> should enable it by default!



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

Reply via email to