[
https://issues.apache.org/jira/browse/BEAM-11173?focusedWorklogId=516016&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-516016
]
ASF GitHub Bot logged work on BEAM-11173:
-----------------------------------------
Author: ASF GitHub Bot
Created on: 24/Nov/20 10:30
Start Date: 24/Nov/20 10:30
Worklog Time Spent: 10m
Work Description: piotr-szuberski commented on a change in pull request
#13319:
URL: https://github.com/apache/beam/pull/13319#discussion_r529421367
##########
File path:
website/www/site/content/en/documentation/dsls/sql/extensions/create-external-table.md
##########
@@ -204,6 +205,131 @@ TYPE bigquery
LOCATION 'testing-integration:apache.users'
```
+## Cloud Bigtable
+
+### Syntax
+
+```
+CREATE EXTERNAL TABLE [ IF NOT EXISTS ] tableName (
+ key VARCHAR NOT NULL,
+ family ROW<qualifier cells [, qualifier cells ]* >
+ [, family ROW< qualifier cells [, qualifier cells ]* > ]*
+)
+TYPE bigtable
+LOCATION
'googleapis.com/bigtable/projects/[PROJECT_ID]/instances/[INSTANCE_ID]/tables/[TABLE]'
+```
+
+* `key`: key of the Bigtable row
+* `family`: name of the column family
+* `qualifier`: the column qualifier
+* `cells`: Either of each value:
+ * `TYPE`
+ * `ARRAY<SIMPLE_TYPE>`
+* `LOCATION`:
+ * `PROJECT_ID`: ID of the Google Cloud Project.
+ * `INSTANCE_ID`: Bigtable instance ID.
+ * `TABLE`: Bigtable Table ID.
+* `TYPE`: `SIMPLE_TYPE` or `CELL_ROW`
+* `CELL_ROW`: `ROW<val SIMPLE_TYPE [, timestampMicros BIGINT [NOT NULL]] [,
labels ARRAY<VARCHAR> [NOT NULL]]`
+* `SIMPLE_TYPE`: on of the following:
+ * `BINARY`
+ * `VARCHAR`
+ * `BIGINT`
+ * `DOUBLE`
+ * `BOOLEAN`
Review comment:
BigQuery supports only those 5 types. But I agree that there is no
reason why not to support others as well. Should I do that in this PR or in the
next one?
----------------------------------------------------------------
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: 516016)
Time Spent: 3h 40m (was: 3.5h)
> Create Bigtable table provider
> ------------------------------
>
> Key: BEAM-11173
> URL: https://issues.apache.org/jira/browse/BEAM-11173
> Project: Beam
> Issue Type: New Feature
> Components: dsl-sql, io-java-gcp
> Reporter: Piotr Szuberski
> Assignee: Piotr Szuberski
> Priority: P2
> Time Spent: 3h 40m
> Remaining Estimate: 0h
>
> Add Bigtable table provider for BeamSQL.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
