You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@iceberg.apache.org by "xianyouQ (via GitHub)" <gi...@apache.org> on 2023/05/04 02:43:25 UTC
[GitHub] [iceberg] xianyouQ opened a new issue, #7522: delete files with spark sql failed
xianyouQ opened a new issue, #7522:
URL: https://github.com/apache/iceberg/issues/7522
### Apache Iceberg version
0.13.1
### Query engine
Spark
### Please describe the bug 🐞
we have a very large day partition table written by a flink job using hive catalog, the daily incremental data is close to 15 TB, 40000+ files. we deleted the older data with spark sql like delete from table where dt = '20230415' and result is successful(using spark count sql and it says 0 rows). but after a few minutes we found the deleted data roll back and be queryable again throught spark sql.
we checked the manifest files and found two snapshots had the same sequence number, one was generated by spark job which the delete operation run, another is generated by the flink job, and the following manifest files generated basing on the second one. it seems that the hive lock didn't work.
any idea?
--
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.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
Re: [I] delete files with spark sql failed [iceberg]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] closed issue #7522: delete files with spark sql failed
URL: https://github.com/apache/iceberg/issues/7522
--
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
Re: [I] delete files with spark sql failed [iceberg]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #7522:
URL: https://github.com/apache/iceberg/issues/7522#issuecomment-1813498657
This issue has been closed because it has not received any activity in the last 14 days since being marked as 'stale'
--
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
Re: [I] delete files with spark sql failed [iceberg]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #7522:
URL: https://github.com/apache/iceberg/issues/7522#issuecomment-1788203108
This issue has been automatically marked as stale because it has been open for 180 days with no activity. It will be closed in next 14 days if no further activity occurs. To permanently prevent this issue from being considered stale, add the label 'not-stale', but commenting on the issue is preferred when possible.
--
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