Hi,
When using reflectiveSchema we must define a static Java class for the schema
object, but in our use case the actual data to query is dynamic, define JAVA
class for each data combination is impossible, we have an idea that can we make
a JSONSchema which accepts a Map>, so that each List
Gavin, thank you very much.
My example works too now, the key point is we must attache the same schema to
both
calciteconnection using conn.getRootSchema().addSubSchema() and FrameworkConfig
using .defaultSchema() method.
And we think that if a defaultSchema parameter for the connection string
Digging into this more to try to better understand Calcite and hopefully
make
progress,it seems like the query breaks here:
https://github.com/apache/calcite/blob/5b2de4ef5c9447bc9f7aff98dd049bd32af5c53d/core/src/main/java/org/apache/calcite/rel/rel2sql/SqlImplementor.java#L1450-L1454
Here you go:
https://gist.github.com/GavinRay97/ffb97088b895389770b7a5d42dc713e9
I have tried to comment on it as best I could.
The important part is what you pass as the default schema name to
"getFrameworkConfig()"
This sets the query namespace when you make queries.
I wrote two examples --
I will write full working implementation of ReflectiveSchema and "select
count(*) from emps"; query execution to help you
Give me one moment please
On Sat, Feb 19, 2022 at 8:52 AM xiaobo wrote:
> Hi,
>
> There is a documented "schema" parameter for the jdbc connection string
> parameters at
Hi,
There is a documented "schema" parameter for the jdbc connection string
parameters at page:
https://calcite.apache.org/docs/adapter.html
the question is : is a init schema the default schema, if not , can you add a
defaultSchema paramter for the jdbc connection string?
Regards
Jiajun Xie created CALCITE-5013:
---
Summary: Parentheses should be reserved when the operand of SetOp
has limit or offset
Key: CALCITE-5013
URL: https://issues.apache.org/jira/browse/CALCITE-5013
