Your problem, again, is about the names being case sensitive. 
Try using double quotes around column and table names to make sure they are 
interpreted correctly or use them all in uppercase, both in the json model and 
in the query. 
You can also set a different lex property for the connection that is more 
flexible like MYSQL_ANSI or just the caseSensitive property to false. 
http://calcite.apache.org/docs/adapter.htm

Reply via email to