[
https://issues.apache.org/jira/browse/CALCITE-3748?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17020654#comment-17020654
]
Rui Wang edited comment on CALCITE-3748 at 1/21/20 11:41 PM:
-------------------------------------------------------------
The test can find the table function because it's registered already in
https://github.com/apache/calcite/blob/master/core/src/test/java/org/apache/calcite/test/TableFunctionTest.java#L61
Your exception is from sqline so seems like you will have to register a table
function somehow when sqline starts and CalciteConnection is created. Basically
you will need to specify a model file and provide the function name like what
is done in tests (e.g. jdbc:calcite:model=target/test-classes/model.json). Also
you will need to make sure your function implementation is in class-path.
was (Author: amaliujia):
The test can find the table function because it's registered already in
https://github.com/apache/calcite/blob/master/core/src/test/java/org/apache/calcite/test/TableFunctionTest.java#L61
Your exception is from sqline so seems like you will have to register a table
function somehow when sqline starts and CalciteConnection is created.
> Exception while executing table function
> ----------------------------------------
>
> Key: CALCITE-3748
> URL: https://issues.apache.org/jira/browse/CALCITE-3748
> Project: Calcite
> Issue Type: Bug
> Components: core
> Affects Versions: 1.21.0
> Environment: we are using windows7 os and we are using command prompt
> and running this queries through sqlline
> Reporter: ssss
> Priority: Major
> Labels: beginner
> Fix For: 1.21.0
>
> Attachments: WhatsApp Image 2020-01-20 at 11.11.47 AM.jpeg
>
>
> I have referred the table function test and i have run the query
> select * from table(s.multiplication(5,6,5));
> But i am getting the exception as "no match found for function signature
> multiplication ((numeric),(numeric),(numeric))".Is there any different
> calcite connection to run this query.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
