feat: add Connection interface #1374
Merged
Conversation
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
google-cla
bot
added
the
cla: yes
product-auto-label
bot
added
the
api: bigquery
This comment was marked as outdated.
This comment was marked as outdated.
This comment was marked as outdated.
This comment was marked as outdated.
This comment was marked as outdated.
This comment was marked as outdated.
Neenu1995
added
the
kokoro:force-run
yoshi-kokoro
removed
the
kokoro:force-run
stephaniewang526
changed the title
shollyman
reviewed
Aug 6, 2021
google-cloud-bigquery/src/main/java/com/google/cloud/bigquery/BigQueryDryRunResult.java
Outdated
Show resolved
Hide resolved
google-cloud-bigquery/src/main/java/com/google/cloud/bigquery/BigQueryImpl.java
Outdated
Show resolved
Hide resolved
google-cloud-bigquery/src/main/java/com/google/cloud/bigquery/BigQueryResultSet.java
Outdated
Show resolved
Hide resolved
google-cloud-bigquery/src/main/java/com/google/cloud/bigquery/BigQuerySQLException.java
Show resolved
Hide resolved
google-cloud-bigquery/src/main/java/com/google/cloud/bigquery/Connection.java
Show resolved
Hide resolved
google-cloud-bigquery/src/main/java/com/google/cloud/bigquery/Connection.java
Outdated
Show resolved
Hide resolved
google-cloud-bigquery/src/main/java/com/google/cloud/bigquery/ConnectionSettings.java
Show resolved
Hide resolved
google-cloud-bigquery/src/main/java/com/google/cloud/bigquery/QueryResultRowFormat.java
Outdated
Show resolved
Hide resolved
stephaniewang526
added
the
kokoro:force-run
yoshi-kokoro
removed
the
kokoro:force-run
stephaniewang526
force-pushed
the
query-interface
branch
from
eb824b4
to
8935c10
Compare
stephaniewang526
force-pushed
the
query-interface
branch
from
54f0826
to
3595799
Compare
stephaniewang526
force-pushed
the
query-interface
branch
2 times, most recently
from
e2dc6b9
to
4584ef2
Compare
stephaniewang526
added
kokoro:force-run
yoshi-kokoro
removed
the
kokoro:force-run
google-cloud-bigquery/src/test/java/com/google/cloud/bigquery/it/ITBigQueryTest.java
Outdated
Show resolved
Hide resolved
google-cloud-bigquery/src/test/java/com/google/cloud/bigquery/it/ITBigQueryTest.java
Show resolved
Hide resolved
google-cla
bot
added
cla: no
stephaniewang526
added
the
owlbot:run
gcf-owl-bot
bot
removed
the
owlbot:run
google-cla
bot
added
cla: no
stephaniewang526
added
kokoro:force-run
yoshi-kokoro
removed
the
kokoro:run
google-cla
bot
added
cla: no
stephaniewang526
added
the
owlbot:run
gcf-owl-bot
bot
removed
the
owlbot:run
google-cla
bot
added
cla: yes
stephaniewang526
added a commit
to stephaniewang526/java-bigquery
that referenced
this pull request
May 6, 2022
…erystorage Java client Relates to googleapis#1374
gcf-merge-on-green bot
pushed a commit
that referenced
this pull request
May 10, 2022
🤖 I have created a release *beep* *boop* --- ## [2.11.0](v2.10.10...v2.11.0) (2022-05-10) ### Features * add Connection interface ([#1374](#1374)) ([3804275](3804275)) * next release from main branch is 2.10.9 ([#1996](#1996)) ([f716427](f716427)) ### Bug Fixes * add native image configuration for Arrow ([#2018](#2018)) ([06cbe69](06cbe69)) * fix for flaky connection close issue ([#2034](#2034)) ([db3daac](db3daac)) ### Documentation * **sample:** remove unused dependency and add setup instructions ([#2010](#2010)) ([e2e9113](e2e9113)) ### Dependencies * update dependency com.google.apis:google-api-services-bigquery to v2-rev20220422-1.32.1 ([#2017](#2017)) ([b9fa786](b9fa786)) * update dependency com.google.apis:google-api-services-bigquery to v2-rev20220429-1.32.1 ([#2020](#2020)) ([78789a5](78789a5)) --- This PR was generated with [Release Please](https://github.com/googleapis/release-please). See [documentation](https://github.com/googleapis/release-please#release-please).
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Add this suggestion to a batch that can be applied as a single commit.
This suggestion is invalid because no changes were made to the code.
Suggestions cannot be applied while the pull request is closed.
Suggestions cannot be applied while viewing a subset of changes.
Only one suggestion per line can be applied in a batch.
Add this suggestion to a batch that can be applied as a single commit.
Applying suggestions on deleted lines is not supported.
You must change the existing code in this line in order to create a valid suggestion.
Outdated suggestions cannot be applied.
This suggestion has been applied or marked resolved.
Suggestions cannot be applied from pending reviews.
Suggestions cannot be applied on multi-line comments.
Suggestions cannot be applied while the pull request is queued to merge.
Suggestion cannot be applied right now. Please check back later.
Background: go/bq-sql-client-java
This PR provides a completely new Connection interface which defines separate APIs for different types of queries. This allows us to provide an industry standard way for database applications to build against the Java client library. We provide 3 new JDBC-esque API methods:
[In-scope for this PR] executeSelect - Only supports read only SELECT queries.
[In-scope for this PR] dryRun - returns som query processing statistics including schema and query parameters.
[Not in this PR] executeUpdate - Only supports DML and DDL.
[Not in this PR] execute - Any SQL - scripts, DML, DDL, SELECT etc statements.
We also integrate with the BigQueryStorage client library and use the high throughput Read API when applicable to parse query results using Arrow format. Arrow has shown better performance over Avro as the row serialization format in this experiment.