Stack Overflow
Stack Overflow

Questions tagged [apache-calcite]

Apache Calcite is a data management framework. Not to be confused with Apache (HTTP Server).

Apache Calcite is a data management framework. It has an implementation of relational algebra, an extensible cost-based optimizer, and an optional SQL parser and JDBC driver.

Calcite is used by Apache Hive and Apache Drill as their query optimizers, and you can use it as a framework to build your own data engine.

Calcite was previously known as Optiq.

255 questions
0
votes
1 answer

Optimizing using calcite gets There are not enough rules to produce a node with desired properties: convention=ENUMERABLE

I'm trying to write a simple program that optimizes SQL query. I am getting "Missing conversion is LogicalTableScan[convention: NONE -> ENUMERABLE]" errors. Here is the optimize function code: public RelNode optimize(RelNode node) { …
Elchanan Shor
  • 1
  • 1
0
votes
0 answers

apache-calcite question to use ODBC driver with Avatica jdbc

How can we use Phoenix ODBC Driver to connect to Avatica JDBC? Thanks, I've tried to install Phoenix ODBC Driver but I don't figure out how to setup a correcty DSN.
fbvdka
  • 1
0
votes
0 answers

How can we parse the SQL query with DATE as the identifier using Apache Calcite?

I am trying to parse the SQL query which is having DATE as the identifier using Apache Calcite. DATE is a reserve word in calcite and due to this it is failing to parse the query with the below error: Exception:…
Amit B
  • 11
  • 2
0
votes
1 answer

How can I convert parsed SqlNodes directly to RelNodes without validation?

I am using Apache Calcite to develop my software.My target is to simply provide an SQL string to Calcite and mainly using its optimizer to optimize it and output a optimized SQL string, which means that i don't have concrete tables or fields. But as…
xwt1
  • 1
0
votes
1 answer

why is calcite using SEARCH operator in the plan when I issue BETWEEN operator in the query

I am issuing a query like: "select col1 a, col2 b from tableA where a between 100 and 101" to my calcite based jdbc driver. The calcite query plan uses a SEARCH operator for the between filter. However I see calcite has a BETWEEN operator in…
Rajesh
  • 1
0
votes
0 answers

Does calcite support custom push down

I have three tables a, b and c, of which a and b are from mysql. When performing associated queries on these three tables, I want a and b to be pushed down to mysql for execution，does calcite support such optimization I find it seems not
cocofhu
  • 1
0
votes
0 answers

Calcite recognizes Database from RelNode

RelNode print each specific dialect query Hi all, I started to use Apache Calcite a few days ago to understand how it works. I created a JSON model with 3 different schema/databases Postgres CSV Mongo Calcite works fine and is connected to all…
Marco
  • 1
  • 1
0
votes
0 answers

How to filter DateTime in QueryRecord (NIFI)

I have a csv file like the one below. I want to filer records based on DateTime in Nifi ValidDate,Skycondition,Precip5min,WdSpdAct2m,WdSpdAct90m,Visibility 12/31/2021 11:35:00,928.3,,3,5.6,36791.4 12/31/2022 11:40:00,943.7,,3,5.5,36810.6 12/31/2022…
Sumit Manna
  • 541
  • 1
  • 5
  • 16
0
votes
0 answers

why linked/coral project not support transform implicit join to relNode?

why linked/coral project not support transform implicit join to relNode ? how to support coral support implicit join transform to relNode
Nelson
  • 1
0
votes
0 answers

Cast to VARCHAR with precision

I'm trying to create a SqlBasicCall that casts the output from a UDF to VARCHAR(50). The UDF is a representation of the Oracle STANDARD_HASH function and the last step I would like to do is CAST the result to VARCHAR. So to explain further, I have…
Spanners
  • 366
  • 2
  • 20
0
votes
0 answers

How to validate an expression in Apache Calcite

I want to know how to validate a expression in Calcite. I create a schema and add my table into it, then I want to use Validator to validate a SqlNode which is from an expression. Here is the code. public class DummyTable extends AbstractTable { …
Kyabia
  • 1
0
votes
1 answer

Nifi QueryRecord on Array of String contains value

Using Apache Nifi i am trying to figure out how to find records which have a string in an array that start with a value Given the below array, i would like only record which have a tag that start with '/test2/' [ { "name":"bob", "tags":[…
timay
  • 35
  • 5
0
votes
1 answer

Parse Bigquery string (offline) using Apache calcite in Java

I need some help on parsing Bigquery string using calcite and I Am new to Apache calcite, so please bear with me for any dumb things. My goal is to parse the Bigquery SQL string (that is either Bigquery expression or Bigquery SQL). If something…
Vasu
  • 49
  • 1
  • 1
  • 7
0
votes
0 answers

Apache Calcite Fails to Parse Its Own Google BigQuery Output

I'm new to Apache Calcite and am running into a strange "gap" - given a simple select query: select * from orders I parse it using: SqlParser.Config sqlParserConfig = SqlParser .configBuilder() .setConformance(SqlConformanceEnum.LENIENT) …
Michael Crampon
  • 1
0
votes
2 answers

Flink Window Aggregation using TUMBLE failing on TIMESTAMP

We have one table A in database. We are loading that table into flink using Flink SQL JdbcCatalog. Here is how we are loading the data val catalog = new JdbcCatalog("my_catalog", "database_name", username, password,…
Kush Rohra
  • 15
  • 5
1 2 3
…
16 17