ERROR : Cannot parallelize an UPDATE statement that updates the distribution columns
来源:互联网 发布:青岛网络电视台回放 编辑:程序博客网 时间:2024/06/05 18:58
问题背景:
jdbc更新greenplum数据库
发生条件:
1:sql语句中包含了对自增长列(例如id)的更新
2:多条sql语句并发更新(单条更新是没问题的)
原因:
greenplum不能并行的更新自增长的列?
解决:
在我的业务里,自增的列是没必要更新的,所以在sql语句里把自增列去掉就好了。
阅读全文
0 0
- ERROR : Cannot parallelize an UPDATE statement that updates the distribution columns
- SQL Error:An aggregate may not appear in the set list of an UPDATE statement.
- 利用Mysql进行update时,出现You have an error in your SQL syntax check the manual that corresponds to your My
- Solution for error "Store update, insert, or delete statement affected an unexpected number of rows"
- ddns-update-style statement error
- My solution to:MySQL triggers cannot update the same row that the trigger is assigned to.
- 173.Which statement describes the effect on an index, when the indexed column for the rows is update
- An error occurred while installing mysql2 (0.4.4), and Bundler cannot continue. Make sure that `gem
- Cannot update object that was never inserted
- The remote server returned an error: (415) Cannot process the message because the content type 'text
- weblogic Error [Management:141191]The prepare phase of the configuration update failed with an excep
- description The server encountered an internal error () that prevented it from fulfilling this request.
- The server encountered an internal error () that prevented it from fulfilling this request
- The server encountered an internal error () that prevented it from fulfilling this request.
- The server encountered an internal error () that prevented it from fulfilling this request.
- You have an error in your SQL syntax; check the manual that corresponds
- The server encountered an internal error () that prevented it from fulfilling this request.
- The server encountered an internal error () that prevented it from fulfilling this request
- 两个SQL技巧——排序和条件判断
- MyBatis代码生成
- 常用正则整理
- SSH整合
- vue之django 和vue语法冲突处理
- ERROR : Cannot parallelize an UPDATE statement that updates the distribution columns
- 多个分割点分割字符串
- 开发大型 web 项目时如何按需加载?
- 【TensorFlow】【数字货币】【单词记忆】【微信运营】【DIY电脑】 | Chat · 预告
- 高可用、高性能? 接口设计的 16 个原则
- C语言运行报glibc detected malloc corruption错误
- 一道数据结构题,求k阶逆序数
- ORA-00904: "T1_DESC": 标识符无效
- 搭建nginx-logstash-kafka-elasticsearch服务