search

exasol / elasticsearch-virtual-schema

Virtual Schema that allows accessing content on an Elasticsearch data source as if it were part of the Exasol database
MIT License
0 stars 1 forks source link

Remove test workaround for failing queries #66

Closed kaklakariada closed 1 month ago

kaklakariada commented 1 year ago

Some queries using the virtual schema fail when converting numeric types, e.g.

SELECT FLOOR("FIELD") FROM VIRTUAL_SCHEMA."index";
SELECT TRUNC(123.4567, 2) FROM VIRTUAL_SCHEMA."index";

These queries fail with the following error message:

ETL-1299: Failed to create transformator for column=0 (starting from 0 for selected columns) [ETL-1202: Not implemented - Transformation for this combination of column types is not possible in this version. A solution for this problem can be perhaps the conversion in another datatype in the database. Otherwise please contact support for additional information]

This is a bug in Exasol 7.1.17.

Once this is fixed in Exasol we need to adapt the tests to expect correct results again.

redcatbear commented 1 month ago

We won't invest effort into 7.1 in this case anymore.