[
https://issues.apache.org/jira/browse/BEAM-8427?focusedWorklogId=354851&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-354851
]
ASF GitHub Bot logged work on BEAM-8427:
----------------------------------------
Author: ASF GitHub Bot
Created on: 06/Dec/19 01:18
Start Date: 06/Dec/19 01:18
Worklog Time Spent: 10m
Work Description: TheNeuralBit commented on pull request #10273:
[BEAM-8427] Add MongoDB to SQL documentation
URL: https://github.com/apache/beam/pull/10273#discussion_r354627008
##########
File path:
website/src/documentation/dsls/sql/extensions/create-external-table.md
##########
@@ -308,6 +308,43 @@ Write Mode supports writing to a topic.
Only simple types are supported.
+## MongoDB
+
+### Syntax
+
+```
+CREATE EXTERNAL TABLE [ IF NOT EXISTS ] tableName (tableElement [,
tableElement ]*)
+TYPE mongodb
+LOCATION 'mongodb://[HOST]:[PORT]/[DATABASE]/[COLLECTION]'
+```
+* `LOCATION`: Location of the collection.
+ * `HOST`: Location of the MongoDB server. Can be localhost or an ip
address.
+ When authentication is required username and password can be specified
+ as follows: `username:password@localhost`.
+ * `PORT`: Port on which MongoDB server is listening.
+ * `DATABASE`: Database to connect to.
+ * `COLLECTION`: Collection within the database.
+
+### Read Mode
+
+Read Mode supports reading from a collection.
+
+### Write Mode
+
+Write Mode supports writing to a collection.
+
+### Schema
+
+Only simple types are supported. MongoDB documents are mapped to Beam SQL
types via `JsonToRow` transform.
Review comment:
Actually it looks like there's quite a lot of precedent within `website/src`
of using `{{site.release_latest}}` for this purpose (some other places use
`current` instead of a version number which I didn't realize was an option).
@11moon11 could you link to JsonToRow using that?
----------------------------------------------------------------
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: 354851)
Time Spent: 9h 10m (was: 9h)
> [SQL] Add support for MongoDB source
> ------------------------------------
>
> Key: BEAM-8427
> URL: https://issues.apache.org/jira/browse/BEAM-8427
> Project: Beam
> Issue Type: New Feature
> Components: dsl-sql
> Reporter: Kirill Kozlov
> Assignee: Kirill Kozlov
> Priority: Major
> Fix For: 2.18.0
>
> Time Spent: 9h 10m
> Remaining Estimate: 0h
>
> * Create a MongoDB table and table provider.
> * Implement buildIOReader
> * Support primitive types
> * Implement buildIOWrite
> * improve getTableStatistics
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
