[jira] [Comment Edited] (CALCITE-521) Implement metadata requests in remote JDBC driver

["TJ Banghart (Jira)" <ji...@apache.org>]

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