[GitHub] [incubator-shardingsphere] ssxlulu edited a comment on issue #3572: Design for MySQL information_schema query

[GitBox <gi...@apache.org>]

ssxlulu edited a comment on issue #3572: Design for MySQL information_schema query
URL: https://github.com/apache/incubator-shardingsphere/issues/3572#issuecomment-557046944
 
 
   Here are my designs for the information_schema queries:
   1. Fake the responses of queries about information_schema. We can intercept such sqls and fake the responses.
   2. Use default datanode. Create the logic tables in the default datanode, and route these sqls to default datanode for querying.
   For example, following is the logic table t_order structure:
   
   t_order:
             |____demo_ds_0:
             |                      |_____t_order_0
             |                      |_____t_order_1
             |___demo_ds_1:
                                    |_____t_order_0
                                    |_____t_order_1
   
   We can create empty table with the same name as t_order in the default datanode like demo_ds_0.t_order for information_schema query.Also, this table can be used for getting metadata.
   

----------------------------------------------------------------
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


With regards,
Apache Git Services