You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by "wanghongzhou2626 (via GitHub)" <gi...@apache.org> on 2023/03/02 17:17:45 UTC
[GitHub] [shardingsphere] wanghongzhou2626 opened a new issue, #24432: sharding order by npe
wanghongzhou2626 opened a new issue, #24432:
URL: https://github.com/apache/shardingsphere/issues/24432
Question
Using sharding to split tables across months using order by resulted in npe
version：5.2.1
<img width="475" alt="截屏2023-03-03 01 13 53" src="https://user-images.githubusercontent.com/38241680/222502779-e042f083-a5e4-4dd0-b975-d32dd168e7e8.png">
EachSimpleTableSegment does not contain the sub-table month I want, which leads to the failure of sorting according to order by after merging
please help me
--
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: notifications-unsubscribe@shardingsphere.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] wanghongzhou2626 commented on issue #24432: sharding order by npe
Posted by "wanghongzhou2626 (via GitHub)" <gi...@apache.org>.
wanghongzhou2626 commented on issue #24432:
URL: https://github.com/apache/shardingsphere/issues/24432#issuecomment-1455413127
<img width="843" alt="image" src="https://user-images.githubusercontent.com/38241680/223017091-a463ef19-e7eb-4d13-b7cc-552bd18b28a7.png">
I have found the cause of the problem
The above is the configuration of my sub-table
When starting a project to obtain metadata, first find out if there is a logical table for the month of 202201, and if so, add it to the table collection. So the npe that results in the subsequent query
If I turn on the configuration check-table-metadata-enabled:true, I don’t need to consider this issue. How does this consume performance? Or how should my goovc expression be written? For example, I started in 2022 but I don't know the end year.
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] wanghongzhou2626 commented on issue #24432: sharding order by npe
Posted by "wanghongzhou2626 (via GitHub)" <gi...@apache.org>.
wanghongzhou2626 commented on issue #24432:
URL: https://github.com/apache/shardingsphere/issues/24432#issuecomment-1457497597
Can I dynamically control the sub-table by month
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] FlyingZC commented on issue #24432: sharding order by npe
Posted by "FlyingZC (via GitHub)" <gi...@apache.org>.
FlyingZC commented on issue #24432:
URL: https://github.com/apache/shardingsphere/issues/24432#issuecomment-1454696991
Are you operating on a logical table, this place is to load the metadata of the table, and the metadata of each table of the sharded table should be the same.
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] FlyingZC commented on issue #24432: sharding order by npe
Posted by "FlyingZC (via GitHub)" <gi...@apache.org>.
FlyingZC commented on issue #24432:
URL: https://github.com/apache/shardingsphere/issues/24432#issuecomment-1457307546
Please provide your config,`check-table-metadata-enabled:true` will load all the will load the table structure of all actual tables for verification when starting ShardingSphere and updating the table structure,.You can configure the end time until 2050.
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] wanghongzhou2626 commented on issue #24432: sharding order by npe
Posted by "wanghongzhou2626 (via GitHub)" <gi...@apache.org>.
wanghongzhou2626 commented on issue #24432:
URL: https://github.com/apache/shardingsphere/issues/24432#issuecomment-1452904986
<img width="447" alt="image" src="https://user-images.githubusercontent.com/38241680/222623845-159825d4-1ab0-4131-acfe-5e1b75bfe585.png">
check-table-metadata-enabled: false
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] wanghongzhou2626 commented on issue #24432: sharding order by npe
Posted by "wanghongzhou2626 (via GitHub)" <gi...@apache.org>.
wanghongzhou2626 commented on issue #24432:
URL: https://github.com/apache/shardingsphere/issues/24432#issuecomment-1457394055
> 请提供您的配置，`check-table-metadata-enabled:true`将加载所有将加载所有实际表的表结构以在启动ShardingSphere 和更新表结构时进行验证，您可以配置结束时间到2050 年。
<img width="1091" alt="截屏2023-03-06 12 03 56" src="https://user-images.githubusercontent.com/38241680/223300665-5d5535f9-d0ef-4572-8a38-e554cbbdb2dd.png">
If the launch date of a certain project is 202203 and the end date is unknown, how should I configure it? Will the end date 2050 you mentioned consume performance?
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] RaigorJiang commented on issue #24432: sharding order by npe
Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang commented on issue #24432:
URL: https://github.com/apache/shardingsphere/issues/24432#issuecomment-1581912468
> Can I dynamically control the sub-table by month
DistSQL can help user to alter sharding table rules.
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] wanghongzhou2626 commented on issue #24432: sharding order by npe
Posted by "wanghongzhou2626 (via GitHub)" <gi...@apache.org>.
wanghongzhou2626 commented on issue #24432:
URL: https://github.com/apache/shardingsphere/issues/24432#issuecomment-1452975826
<img width="891" alt="截屏2023-03-03 12 57 59" src="https://user-images.githubusercontent.com/38241680/222635213-2a51345c-9fc8-4896-addb-5a5523eb7520.png">
check-table-metadata-enabled: false will not add logical tables when the project is started. For example, the current total number of tables is 600, and the method through the picture will reduce a few logical tables, which will lead to subsequent order by merge engine table lookup The table corresponding to the name generates npe
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] strongduanmu commented on issue #24432: sharding order by npe
Posted by "strongduanmu (via GitHub)" <gi...@apache.org>.
strongduanmu commented on issue #24432:
URL: https://github.com/apache/shardingsphere/issues/24432#issuecomment-1452753265
@wanghongzhou2626 Can you provide your sharding configuration and sql?
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] RaigorJiang closed issue #24432: sharding order by npe
Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang closed issue #24432: sharding order by npe
URL: https://github.com/apache/shardingsphere/issues/24432
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org