Implement information_schema.schemata #8917

Activity

1. Tangruilin commented on Jan 22, 2024

   

   Tangruilin

   on Jan 22, 2024

   Contributor

   More actions

   I am interested on this problem.
   Maybe you can assign it to me
2. alamb

   assigned

   Tangruilin

   on Jan 22, 2024
3. alamb commented on Jan 22, 2024

   

   alamb

   on Jan 22, 2024

   ContributorAuthor

   More actions

   Thanks @Tangruilin !

   cc @JanKaul who made the original request in Discord
4. JanKaul commented on Jan 22, 2024

   

   JanKaul

   on Jan 22, 2024

   Contributor

   More actions

   Thanks @Tangruilin !

   Let me know if I can assist you somehow.
5. Tangruilin commented on Jan 23, 2024

   

   Tangruilin

   on Jan 23, 2024

   Contributor

   More actions

   Thanks @Tangruilin !

   Let me know if I can assist you somehow.

   I have read about some of the code.
   But I am a little confused how to start. Could you tell me where the metadata like information_schema.table add in the code, and I will look at that part
6. JanKaul commented on Jan 23, 2024

   

   JanKaul

   on Jan 23, 2024

   Contributor

   More actions

   I think the following steps could work:

   1. Create a InformationSchemaSchemataBuilder (similar to the TablesBuilder) that has all the columns of the information_schema.schemata table.
   2. Create a make_schemata function (similar to make_tables) that obtains the schemas from the catalog list. This can be used to populate the previously created builder.
   3. Create a InformationSchemaSchemata (similar to InformationSchemaTables) that uses the make_schemata method to implement the PartitionStream trait.

   Maybe it helps

   👍React with 👍1Reacted by Reilly.tang
7. alamb

   closed this as completedin #8993on Jan 28, 2024
8. alamb

   added a commit that references this issue on Jan 28, 2024

   [task #8917] Implement information_schema.schemata (#8993)

   ...

   a668abf