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