[
https://issues.apache.org/jira/browse/CALCITE-521?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17739137#comment-17739137
]
TJ Banghart edited comment on CALCITE-521 at 6/30/23 3:25 PM:
--------------------------------------------------------------
Came across this ticket when looking for a {{getFunctions()}} request. Glancing
at [requests.proto,
|https://github.com/apache/calcite-avatica/blob/17e2f484b37ed94ebdb5f486c5dafadc433cf611/core/src/main/protobuf/requests.proto]it
appears that we can mark {{{}getTables{}}}, {{{}getColumns{}}}, and
{{getTableTypes}} as complete. I'd like to start chipping away at the rest of
these.
For unit-tests,
[{{RemoteDriverMockTest}}|https://github.com/apache/calcite-avatica/blob/fc6ce0c6e9e70fe79b348a053523be66fc7f0f14/server/src/test/java/org/apache/calcite/avatica/RemoteDriverMockTest.java]
looks like a good starting place unless someone has a suggestion where to
being.
was (Author: tjbanghart):
Came across this ticket when looking for a {{getFunctions()}} request. Glancing
at [requests.proto,
|https://github.com/apache/calcite-avatica/blob/17e2f484b37ed94ebdb5f486c5dafadc433cf611/core/src/main/protobuf/requests.proto]it
appears that we can mark {{{}getTables{}}}, {{{}getColumns{}}}, and
{{getTableTypes}} as complete. I'd like to start chipping away at these.
For unit-tests,
[{{RemoteDriverMockTest}}|https://github.com/apache/calcite-avatica/blob/fc6ce0c6e9e70fe79b348a053523be66fc7f0f14/server/src/test/java/org/apache/calcite/avatica/RemoteDriverMockTest.java]
looks like a good starting place unless someone has a suggestion where to
being.
> Implement metadata requests in remote JDBC driver
> -------------------------------------------------
>
> Key: CALCITE-521
> URL: https://issues.apache.org/jira/browse/CALCITE-521
> Project: Calcite
> Issue Type: Bug
> Components: avatica
> Reporter: Julian Hyde
> Assignee: TJ Banghart
> Priority: Major
>
> The remote JDBC driver supports getCatalogs() and getSchemas(), via requests
> CatalogsRequest and SchemasRequest. We need to implement more methods:
> * getTables
> * getColumns
> * getTableTypes
> * getProcedures
> * getProcedureColumns
> * getColumnPrivileges
> * getTablePrivileges
> * getBestRowIdentifier
> * getVersionColumns
> * getPrimaryKeys
> * getImportedKeys
> * getExportedKeys
> * getCrossReference
> * getTypeInfo
> * getIndexInfo
> * getUDTs
> * getSuperTypes
> * getSuperTables
> * getAttributes
> * getClientInfoProperties
> * getFunctions
> * getFunctionColumns
> * getPseudoColumns
> Many of these will return empty sets when run against Calcite, because
> Calcite doesn't override the MetaImpl, and the default implementation returns
> empty. That's OK. This task is just to create the plumbing from client to
> server.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
