You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@iceberg.apache.org by GitBox <gi...@apache.org> on 2021/01/27 02:20:15 UTC

[GitHub] [iceberg] rdblue opened a new pull request #2160: Docs: Refactor Spark pages

rdblue opened a new pull request #2160:
URL: https://github.com/apache/iceberg/pull/2160


   This breaks the Spark page across several smaller pages. The Spark page is currently still available for existing permalinks. I intend to replace it with redirects in a later PR.


----------------------------------------------------------------
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:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org
For additional commands, e-mail: issues-help@iceberg.apache.org


[GitHub] [iceberg] rdblue merged pull request #2160: Docs: Refactor Spark pages

Posted by GitBox <gi...@apache.org>.
rdblue merged pull request #2160:
URL: https://github.com/apache/iceberg/pull/2160


   


----------------------------------------------------------------
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:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org
For additional commands, e-mail: issues-help@iceberg.apache.org


[GitHub] [iceberg] rdblue commented on a change in pull request #2160: Docs: Refactor Spark pages

Posted by GitBox <gi...@apache.org>.
rdblue commented on a change in pull request #2160:
URL: https://github.com/apache/iceberg/pull/2160#discussion_r566265465



##########
File path: site/docs/getting-started.md
##########
@@ -72,6 +73,14 @@ INSERT INTO local.db.table VALUES (1, 'a'), (2, 'b'), (3, 'c');
 INSERT INTO local.db.table SELECT id, data FROM source WHERE length(data) = 1;
 ```
 
+Iceberg also adds row-level SQL updates to Spark, [`MERGE INTO`](./spark.md#merge-into) and [`DELETE FROM`](./spark.md#delete-from):
+
+```sql
+MERGE INTO local.db.target t USING (SELECT * FROM updates) u ON t.id = u.id
+WHEN MATCHED THEN SET t.count = t.count + u.count

Review comment:
       Updated and deployed. Thanks for catching this!




----------------------------------------------------------------
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:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org
For additional commands, e-mail: issues-help@iceberg.apache.org


[GitHub] [iceberg] wjxiz1992 commented on a change in pull request #2160: Docs: Refactor Spark pages

Posted by GitBox <gi...@apache.org>.
wjxiz1992 commented on a change in pull request #2160:
URL: https://github.com/apache/iceberg/pull/2160#discussion_r566001446



##########
File path: site/docs/getting-started.md
##########
@@ -72,6 +73,14 @@ INSERT INTO local.db.table VALUES (1, 'a'), (2, 'b'), (3, 'c');
 INSERT INTO local.db.table SELECT id, data FROM source WHERE length(data) = 1;
 ```
 
+Iceberg also adds row-level SQL updates to Spark, [`MERGE INTO`](./spark.md#merge-into) and [`DELETE FROM`](./spark.md#delete-from):
+
+```sql
+MERGE INTO local.db.target t USING (SELECT * FROM updates) u ON t.id = u.id
+WHEN MATCHED THEN SET t.count = t.count + u.count

Review comment:
       according to https://github.com/apache/iceberg/issues/2175, can you update to "UPDATE SET"?




----------------------------------------------------------------
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:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org
For additional commands, e-mail: issues-help@iceberg.apache.org