Error:
No match found for function signature TO_CHAR()
BACKGROUND：
I want to implement a function that can suffice for parsing and
validating complex Oracle SQL. But I encountered some Oracle functions and
keywords that are not supported during development, I don't know how to do it!
W
I've been meaning to write and publish something on this since I had the
same question + it seems to come up often
There are essentially two important things you need to know about Calcite
to work with federated data:
1. Calcite schemas work like filesystem hierarchies. You have a
"rootSchema" wh
Hi Team,
Say that I have a query which references 5 tables, and 3 of these are in
Cassandra and 1 is a CSV file. Out of these, the cassandra tables are split
across 2 different cassandra DB instances.
How does calcite federation work in this case?
Do I have to instantiate multiple connections? Is
I definitely suggest that you look at how Substrait compiles. There are a
number of customizations on top of vanilla Calcite that are done. Key
things to observe include:
* Configuration of runtime/compile time classes at build. [1]
* Registration of addition reflection, etc items [2]
* Use of prox
Thanks everyone for testing and voting for this release.
The vote is currently closed and I will send a separate email with the
results.
On Mon, Aug 1, 2022 at 4:32 AM Chunwei Lei wrote:
> Thanks Andrei for working on this.
>
> Mac OS X 10.16 x86_64,jdk 1.8.0_271,Gradle 7.3
>
> - Checksum and s
Thanks to everyone who has tested the release candidate and given
their comments and votes.
The tally is as follows.
5 binding +1s:
Ruben Q L
Julian Hyde
Francis Chuang
Stamatis Zempetakis
Chunwei Lei
3 non-binding +1s:
Andrei Sereda
Enrico Olivelli
Benchao Li
No 0s or -1s.
Therefore, I am del
杨晓晨 created CALCITE-5225:
Summary: No match found for function signature TO_CHAR()
Key: CALCITE-5225
URL: https://issues.apache.org/jira/browse/CALCITE-5225
Project: Calcite
Issue Type: Bug
Hi, Ray,
> I assume somebody could write custom function to do something like this:
>
> SELECT *
> FROM TABLE (
>HttpReader(
> method => 'GET'
> url => 'https://api.mysite.com/users/1'
> )
> )
>
> Where "https://api.mysite.com/users/1"; returns JSON data like:
>
> { "id": 1, "nam
