Styjun

A pyramid from a square

Why was hardware diversification an asset for the IBM PC ecosystem?

Is Trump personally blocking people on Twitter?

Is anyone advocating the promotion of homosexuality in UK schools?

Matchmaker, Matchmaker, make me a match

Who has taken "my" Managed package namespace? Can we find out?

Can I call 112 to check a police officer's identity in the Czech Republic?

Is Arc Length always irrational between two rational points?

Can fluent English speakers distinguish “steel”, “still” and “steal”?

Is there a word for a message that is intended to be intercepted by an adversary?

Was I subtly told to resign?

Are randomly-generated passwords starting with "a" less secure?

Why didn't Thanos kill all the Dwarves on Nidavellir?

Is lack of functional requirements agile?

What are the bumps on the Vega rocket

CentOS 7 -> find: missing Argument for "-exec"

If the railway suggests a 5-min connection window for changing trains in the Netherlands, does that mean it's definitely doable?

Why does my script create an extra character?

Why are they 'nude photos'?

Why does my String turn into Integers instead of letters after I add characters with +?

Single word for "refusing to move to next activity unless present one is completed."

How to say "to make my heart sing"

<schwitz>, <zwinker> etc. Does German always use 2nd Person Singular Imperative verbs for emoticons? If so, why?

Is purchasing foreign currency before going abroad a losing proposition?

How to add a UDF with variable number parameter in calcite?

How do I limit the number of rows returned by an Oracle query after ordering?how to avoid calcite doing aggregations in memoryHow to use calcite cassandra adapters in applicationHow to add a udf who's parameter is a table nameHow to parse nested SQL statement using calcite?How to serialize and deserialize RelNode in Calcite?How to take advantage of calcite-serverHow to find the primary key constraint for a table in CalciteApache Calcite - How to Integrate CSV and MySQL

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

I'm using Apache Calcite to validate SQL. I add tables and UDFs dynamically.
The problem is when I add a UDF with variable number parameter, the validator can not find this function.

Version of Calcite is 1.18.0

And this is my code.

TestfuncFunction.java

public class TestfuncFunction 
 public String testfunc(String... arg0) 
 return null;
 

Add UDF

Function schemafunction = ScalarFunctionImpl.create(TestfuncFunction.class),"testfunc");
SchemaPlus schemaPlus = Frameworks.createRootSchema(true);
schemaPlus.add("testfunc", schemafunction);

SQL

select testfunc(field1, field2) from test_table

testfunc is a ScalarFunction with variable number parameter,field1 and field2 are columns of test_table. So this is a legal SQL. But I got this CalciteContextException when validating:

No match found for function signature testfunc(<CHARACTER>, <CHARACTER>)

I tryed to change my sql into one parameter like this:

select testfunc(field1) from test_table

and got this exception

java.lang.AssertionError: No assign rules for OTHER defined
 at org.apache.calcite.sql.type.SqlTypeAssignmentRules.canCastFrom(SqlTypeAssignmentRules.java:386)
 at org.apache.calcite.sql.type.SqlTypeUtil.canCastFrom(SqlTypeUtil.java:864)
 at org.apache.calcite.sql.SqlUtil.lambda$filterRoutinesByParameterType$4(SqlUtil.java:554)
 ...

It seems that calcite transform java array type into SqlTypeName.OTHER.
I have tryed to override method "createJavaType" in JavaTypeFactoryImpl like this:

private static class CustomJavaTypeFactoryImpl extends JavaTypeFactoryImpl 
 @Override
 public RelDataType createJavaType(Class clazz) 
 if (clazz.isArray()) 
 return new ArraySqlType(super.createJavaType(clazz.getComponentType()), true);
 
 return super.createJavaType(clazz);
 

but it did not work.

Do Calcite support UDF with variable number parameter, and what should I do.

sql apache-calcite

share|improve this question

asked Mar 26 at 3:28

Grady YangGrady Yang

111 bronze badge

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  When you say your changes to createJavaType "did not work", what happened?
  
  – Michael Mior
  Mar 26 at 14:39
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Still got "No match found for function signature testfunc", no matter how many parameters there are for testfunc. @MichaelMior
  
  – Grady Yang
  Mar 27 at 1:29
  
  

  
  
  
  

add a comment | 

0

I'm using Apache Calcite to validate SQL. I add tables and UDFs dynamically.
The problem is when I add a UDF with variable number parameter, the validator can not find this function.

Version of Calcite is 1.18.0

And this is my code.

TestfuncFunction.java

public class TestfuncFunction 
 public String testfunc(String... arg0) 
 return null;
 

Add UDF

Function schemafunction = ScalarFunctionImpl.create(TestfuncFunction.class),"testfunc");
SchemaPlus schemaPlus = Frameworks.createRootSchema(true);
schemaPlus.add("testfunc", schemafunction);

SQL

select testfunc(field1, field2) from test_table

testfunc is a ScalarFunction with variable number parameter,field1 and field2 are columns of test_table. So this is a legal SQL. But I got this CalciteContextException when validating:

No match found for function signature testfunc(<CHARACTER>, <CHARACTER>)

I tryed to change my sql into one parameter like this:

select testfunc(field1) from test_table

and got this exception

java.lang.AssertionError: No assign rules for OTHER defined
 at org.apache.calcite.sql.type.SqlTypeAssignmentRules.canCastFrom(SqlTypeAssignmentRules.java:386)
 at org.apache.calcite.sql.type.SqlTypeUtil.canCastFrom(SqlTypeUtil.java:864)
 at org.apache.calcite.sql.SqlUtil.lambda$filterRoutinesByParameterType$4(SqlUtil.java:554)
 ...

It seems that calcite transform java array type into SqlTypeName.OTHER.
I have tryed to override method "createJavaType" in JavaTypeFactoryImpl like this:

private static class CustomJavaTypeFactoryImpl extends JavaTypeFactoryImpl 
 @Override
 public RelDataType createJavaType(Class clazz) 
 if (clazz.isArray()) 
 return new ArraySqlType(super.createJavaType(clazz.getComponentType()), true);
 
 return super.createJavaType(clazz);
 

but it did not work.

Do Calcite support UDF with variable number parameter, and what should I do.

sql apache-calcite

share|improve this question

asked Mar 26 at 3:28

Grady YangGrady Yang

111 bronze badge

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  When you say your changes to createJavaType "did not work", what happened?
  
  – Michael Mior
  Mar 26 at 14:39
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Still got "No match found for function signature testfunc", no matter how many parameters there are for testfunc. @MichaelMior
  
  – Grady Yang
  Mar 27 at 1:29
  
  

  
  
  
  

add a comment | 

I'm using Apache Calcite to validate SQL. I add tables and UDFs dynamically.
The problem is when I add a UDF with variable number parameter, the validator can not find this function.

Version of Calcite is 1.18.0

And this is my code.

TestfuncFunction.java

public class TestfuncFunction 
 public String testfunc(String... arg0) 
 return null;
 

Add UDF

Function schemafunction = ScalarFunctionImpl.create(TestfuncFunction.class),"testfunc");
SchemaPlus schemaPlus = Frameworks.createRootSchema(true);
schemaPlus.add("testfunc", schemafunction);

SQL

select testfunc(field1, field2) from test_table

testfunc is a ScalarFunction with variable number parameter,field1 and field2 are columns of test_table. So this is a legal SQL. But I got this CalciteContextException when validating:

No match found for function signature testfunc(<CHARACTER>, <CHARACTER>)

I tryed to change my sql into one parameter like this:

select testfunc(field1) from test_table

and got this exception

java.lang.AssertionError: No assign rules for OTHER defined
 at org.apache.calcite.sql.type.SqlTypeAssignmentRules.canCastFrom(SqlTypeAssignmentRules.java:386)
 at org.apache.calcite.sql.type.SqlTypeUtil.canCastFrom(SqlTypeUtil.java:864)
 at org.apache.calcite.sql.SqlUtil.lambda$filterRoutinesByParameterType$4(SqlUtil.java:554)
 ...

It seems that calcite transform java array type into SqlTypeName.OTHER.
I have tryed to override method "createJavaType" in JavaTypeFactoryImpl like this:

private static class CustomJavaTypeFactoryImpl extends JavaTypeFactoryImpl 
 @Override
 public RelDataType createJavaType(Class clazz) 
 if (clazz.isArray()) 
 return new ArraySqlType(super.createJavaType(clazz.getComponentType()), true);
 
 return super.createJavaType(clazz);
 

but it did not work.

Do Calcite support UDF with variable number parameter, and what should I do.

sql apache-calcite

share|improve this question

asked Mar 26 at 3:28

Grady YangGrady Yang

111 bronze badge

public class TestfuncFunction 
 public String testfunc(String... arg0) 
 return null;
 

Function schemafunction = ScalarFunctionImpl.create(TestfuncFunction.class),"testfunc");
SchemaPlus schemaPlus = Frameworks.createRootSchema(true);
schemaPlus.add("testfunc", schemafunction);

select testfunc(field1, field2) from test_table

No match found for function signature testfunc(<CHARACTER>, <CHARACTER>)

select testfunc(field1) from test_table

java.lang.AssertionError: No assign rules for OTHER defined
 at org.apache.calcite.sql.type.SqlTypeAssignmentRules.canCastFrom(SqlTypeAssignmentRules.java:386)
 at org.apache.calcite.sql.type.SqlTypeUtil.canCastFrom(SqlTypeUtil.java:864)
 at org.apache.calcite.sql.SqlUtil.lambda$filterRoutinesByParameterType$4(SqlUtil.java:554)
 ...

private static class CustomJavaTypeFactoryImpl extends JavaTypeFactoryImpl 
 @Override
 public RelDataType createJavaType(Class clazz) 
 if (clazz.isArray()) 
 return new ArraySqlType(super.createJavaType(clazz.getComponentType()), true);
 
 return super.createJavaType(clazz);
 

share|improve this question

asked Mar 26 at 3:28

Grady YangGrady Yang

111 bronze badge

share|improve this question

asked Mar 26 at 3:28

Grady YangGrady Yang

111 bronze badge

asked Mar 26 at 3:28

Grady YangGrady Yang

111 bronze badge

asked Mar 26 at 3:28

Grady YangGrady Yang

111 bronze badge