Hello,
I am currently attempting to test out the views feature of Calcite.
I am using a connection string like so:
jdbc:calcite:lex=JAVA;model=inline:<json model>
I have created a JdbcSchema that is attached to an actual database - lets
call it "t1". I can successfully run the query "select * from t1.table
limit 10"
I then created another schema, defined like so:
{
"name": "viewtest",
"tables": [
{ "name": "test_view", "type": "view", "sql": "select * from
t1.table limit 10" }
]
}
The idea is to set up connections to a bunch of physical data sources and
then have a "views" schema that just contains views over them.
However, when attempting to run the query "select * from
viewtest.test_view", I get the following exception:
StatementCallback; uncategorized SQLException for SQL [select * from
viewtest.test_view]; SQL state [null]; error code [0];
Error while executing SQL \"select * from viewtest.test_view\": From line
1, column 15 to line 1, column 32: Object 'T1' not found; did you mean 't1'?
I can clearly see that lex=JAVA is not being used for the view and the
default lex=ORACLE is being used. If I change the view SQL to 'select *
from "t1".table limit 10' it works - but I don't want to have to quote the
identifiers oracle style, I would like the lex=JAVA that I specified on the
connection string to flow down to views as well.
What am I missing here?
Cheers,
Erin
