It's possible I've got something misconfigured, but I've looked and haven't found anything that seems to fit. It's also possible I'm trying to do something that isn't supported, if so I apologize.

When trying to join a ColumSstore table with an InnoDB table that contains an uppercase character the join fails - it looks like it's because it lowercases the table name when trying to do the join. With a setting of

lower_case_table_names = 0
lower_case_file_system = OFF

and these queries

CREATE TABLE IF NOT EXISTS data.example_columnstore_table (
`Blah` VARCHAR(255) NOT NULL
) ENGINE=columnstore;

CREATE TABLE IF NOT EXISTS data.ExampleInnoDBTable (
`Blah` VARCHAR(255) NOT NULL
) ENGINE=INNODB;

INSERT INTO data.ExampleInnoDBTable (`Blah`) VALUES ("1");
INSERT INTO data.example_columnstore_table (`Blah`) VALUES ("1");
SELECT * FROM data.example_columnstore_table JOIN data.ExampleInnoDBTable USING (`Blah`);

it gives an error of "Internal error: fatal error executing query in crossengine client lib(17)(17)"

and in the debug log

Aug 17 10:30:10 db ExeMgr[6710]: 10.193649 |304741|0|0| D 16 CAL0041: Start SQL statement: SELECT * FROM data.example_columnstore_table JOIN data.ExampleInnoDBTable USING (`Blah`); ||
Aug 17 10:30:10 db joblist[6710]: 10.208007 |0|0|0| I 05 CAL0000: QUERY to foreign engine: SELECT Blah FROM exampleinnodbtable
Aug 17 10:30:10 db joblist[6710]: 10.208566 |304741|0|0| C 05 CAL0000: fatal error executing query in crossengine client lib(17)(17)

Joining a lower case InnoDB table and an uppercase InnoDB table does work in this environment