[jira] [Commented] (CALCITE-3748) Exception while executing table function
[ https://issues.apache.org/jira/browse/CALCITE-3748?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17020661#comment-17020661 ] Rui Wang commented on CALCITE-3748: --- closing this Jira as it is not a bug or new feature. Feel free to reopen if you find a bug. BTW. If you want ask how to use sqline, setup UDF, register table, etc. for your use cases. You could ask in dev@ than commenting in PRs or open bugs. Discussing users related questions in dev@ will benefit more people (and people also are very willing to answer how-to questions). > 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: >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)
[jira] [Commented] (CALCITE-3748) Exception while executing table function
[ https://issues.apache.org/jira/browse/CALCITE-3748?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17020654#comment-17020654 ] Rui Wang commented on CALCITE-3748: --- 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: >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)
[jira] [Commented] (CALCITE-3748) Exception while executing table function
[ https://issues.apache.org/jira/browse/CALCITE-3748?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17019385#comment-17019385 ] commented on CALCITE-3748: --- It is already in the TableFunctionTest.java. > Exception while executing table function > > > Key: CALCITE-3748 > URL: https://issues.apache.org/jira/browse/CALCITE-3748 > Project: Calcite > Issue Type: New Feature > 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: >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)
[jira] [Commented] (CALCITE-3748) Exception while executing table function
[ https://issues.apache.org/jira/browse/CALCITE-3748?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17019257#comment-17019257 ] Danny Chen commented on CALCITE-3748: - How did you register the function "multiplication" ? > Exception while executing table function > > > Key: CALCITE-3748 > URL: https://issues.apache.org/jira/browse/CALCITE-3748 > Project: Calcite > Issue Type: New Feature > 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: >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)