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/12/28 02:51:41 UTC
[GitHub] [iceberg] Initial-neko opened a new issue #3814: In flinksql, there is a problem of partial updating of wide table fields
Initial-neko opened a new issue #3814:
URL: https://github.com/apache/iceberg/issues/3814
now:
```
+----+-------+-------+
| id | data1 | data2 |
+----+-------+-------+
| 1 | 2 | 3 |
| 2 | 3 | 4 |
+----+-------+-------+
```
insert INTO table（id,data1）values(1,3)
```
result：
+----+-------+-------+
| id | data1 | data2 |
+----+-------+-------+
| 1 | 3 | null |
| 2 | 3 | 4 |
+----+-------+-------+
```
However, if I want to keep other fields unchanged and just update the specified field, I need to read this row of data.
Can someone give me some advice，How can I read it gracefully? Thanks！
insert INTO table（id,data1）values(1,3)
result like that
```
+----+-------+-------+
| id | data1 | data2 |
+----+-------+-------+
| 1 | 3 | 3 |
| 2 | 3 | 4 |
+----+-------+-------+
```
At present, my idea is to build a read request somewhere, but I don't know where to build such a request
--
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.
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org
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] kbendick commented on issue #3814: In flinksql, there is a problem of partial updating of wide table fields
Posted by GitBox <gi...@apache.org>.
kbendick commented on issue #3814:
URL: https://github.com/apache/iceberg/issues/3814#issuecomment-1009299983
It seems that this has been solved. I'm going to close this issue. Please feel free to open a new issue if you have any more questions!
And thank you @ZhangChaoming for providing support!
--
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.
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org
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] kbendick closed issue #3814: In flinksql, there is a problem of partial updating of wide table fields
Posted by GitBox <gi...@apache.org>.
kbendick closed issue #3814:
URL: https://github.com/apache/iceberg/issues/3814
--
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.
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org
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] Initial-neko commented on issue #3814: In flinksql, there is a problem of partial updating of wide table fields
Posted by GitBox <gi...@apache.org>.
Initial-neko commented on issue #3814:
URL: https://github.com/apache/iceberg/issues/3814#issuecomment-1004557653
>
Thanks！It works
--
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.
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org
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] ZhangChaoming commented on issue #3814: In flinksql, there is a problem of partial updating of wide table fields
Posted by GitBox <gi...@apache.org>.
ZhangChaoming commented on issue #3814:
URL: https://github.com/apache/iceberg/issues/3814#issuecomment-1002952920
@Initial-neko IMO, set the column value of `data2` to `null` is within expectation. Perhaps you can try like this:
```sql
INSERT INTO t SELECT id, 3, data2 FROM t WHERE id = 1;
```
--
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.
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org
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