[ 
https://issues.apache.org/jira/browse/CALCITE-2317?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17288393#comment-17288393
 ] 

Malte Bellmann commented on CALCITE-2317:
-----------------------------------------

I've now updated the pull request. Now the functions from theĀ  SqlOperatorTable 
of the connection are added to the "metadata" schema whenever it exists.

I thinks thats good enough. For my use case, I can now see the built-in 
functions and UDFs in the IntelliJ database view for example.

> getFunctions() showing empty
> ----------------------------
>
>                 Key: CALCITE-2317
>                 URL: https://issues.apache.org/jira/browse/CALCITE-2317
>             Project: Calcite
>          Issue Type: Bug
>            Reporter: Subbarao
>            Assignee: Malte Bellmann
>            Priority: Major
>              Labels: pull-request-available, pull-requests-available
>         Attachments: CalciteWithOracle.java
>
>          Time Spent: 0.5h
>  Remaining Estimate: 0h
>
> how to get all function names and procedure names in oracle database using 
> calcite connection and schema.
> schema.getFunctionNames() return result is:[ ]
> Then i am try to retrieving DatabaseMetadata.getFunction().Here also it will 
> be showing empty.
> Iam using calciResultSet ,AvaticaResultSet and ResultSet for getting 
> functions and procedures but will be showing empty.
> Is it possible get all function names and procedure names from any database.
> But normal jdbc connection using DatabseMetaData propertiesĀ  it retrive alll 
> function names and procedure names.Why it will not retrive in calcite



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to