Fully managed cloud. 30-day FREE full featured trial. Start Now
cancel
Showing results for 
Search instead for 
Did you mean: 

Virtual Schema on H2

steffen_check24
Contributor

Hi,

we are using a virtual schema on a H2 database.

In our production environment we are using virtual-schema-dist-5.0.1-bundle-4.0.1.jar  for adapter script, in a second Exasol instance (our PRELIVE environment), we are using virtual-schema-dist-9.0.4-exasol-6.0.2.jar.

 

Queries using exasol build in functions like minutes_between, that do exist in Exasol but not in H2, work on PROD with using virtual-schema-dist-5.0.1, but run into error (Function xxx does not exist) on PRELIVE with virtual-schema-dist-9.0.4.

 

Does anyone know, if there was a change for virtual schema functionality, that such functions are executed inside target DB(H2) know, while they were executed in Exasol before?

Could there be any other reason?

Due to internal organisational processes, I cannot change the jar files for testing.

 

--PROD

CREATE JAVA  ADAPTER SCRIPT "JDBC_ADAPTER_SCRIPT_H2" AS
%scriptclass com.exasol.adapter.RequestDispatcher;
  %jar /buckets/bucketfs1/cdp_public_bucket/virtual-schema-dist-5.0.1-bundle-4.0.1.jar;
  %jar/buckets/bucketfs1/cdp_public_bucket/h2-1.4.199.jar;
/

--PRELIVE

CREATE JAVA  ADAPTER SCRIPT "JDBC_ADAPTER_SCRIPT_H2" AS
%scriptclass com.exasol.adapter.RequestDispatcher;
  %jar /buckets/bucketfs1/cdp_public_bucket/virtual-schema-dist-9.0.4-exasol-6.0.2.jar;
  %jar /buckets/bucketfs1/cdp_public_bucket/h2-1.4.200.jar;
 

 

1 REPLY 1

mwellbro
Xpert

Hi @steffen_check24 ,

haven´t screened github for your particular change but maybe, even though you can´t change the .jar , you might test with the EXCLUDED_CAPABILITIES definition ?

https://docs.exasol.com/db/latest/database_concepts/virtual_schema/adapter_properties.htm

Not sure which capability exactly makes the virtual schema think it could pushdown minutes_between....

Perhaps it would be enough to add " EXCLUDED_CAPABILITIES='MINUTES_BETWEEN' " to your vSchema (or create a new one to test with ).

Haven´t tried this so take it with a grain of salt...

Cheers,
Malte