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
0 answers

Calcite ArrayIteratorCursor support for Blobs, Clobs, Array

We are using Calcite version 1.35.0 (Avatica version 1.23.0). We create a connection and add a Schema to it via: connection = DriverManager.getConnection("jdbc:calcite:"); final CalciteConnection calciteConnection; calciteConnection =…
Tony Falabella
  • 335
  • 1
  • 6
  • 17
0
votes
1 answer

Apache calcite adds ASYMMETRIC keyword for a between query

I am using apache calcite 1.34.0 for converting ANSI SQL to Snowflake SQL for a use case. I am having issues for ANSI SQL queries containing 'BETWEEN' keyword. The code below does the conversion from ANSI SQL to SNOWFLAKE SQL. SqlParser sqlParser =…
konoha.itachi
  • 1
0
votes
0 answers

Recomendations on stack config

Experiencing performance problems on writing data to Ignite stack. Doing next queries MERGE INTO ... VALUES ((...)...) ON () WHEN MATCHED THEN UPDATE SET ... WHEN NOT MATCHED THEN INSERT ... VALUES (...) with 1-2 values it takes about 100-150ms in…
Maksym
  • 1
  • 3
0
votes
1 answer

Is there a DorisSqlDialect for calcite?

I am converting standard SQL to doris SQL to support data structures such as bitmap, hll and aggregation methods such as bitmap_union and hll_union. Is there already written DorisSqlDialect?
Long.zhao
  • 1,085
  • 2
  • 11
  • 16
0
votes
0 answers

Transform JOIN condition into equality filters in Apache Calcite

there is a service API that allows retrieving some Books, and we would like to build a Apache Calcite table on top of this service; this API only accepts a set of IDs, and if no IDs are provided, no result is returned. interface BookService { …
lmarx
  • 476
  • 4
  • 9
0
votes
0 answers

Calcite UPDATE with inner select

Does Calcite support UPDATE with inner SQL? it seems that calcite support update with inner sql https://issues.apache.org/jira/browse/CALCITE-2427 but Sample 1 update lk.request set step_id ='12ef237a-4038-41dd-aad3-e67cff4c2a16' where…
Sergey Kashin
  • 1
0
votes
1 answer

How to integrate Apache Calcite with Apache Cassandra and Hibernate/JPA

I wish to integrate Apache Calcite as a library or server on top of Apache Cassandra database and use it as SQL datasource in Hibernate ORM or any other JPA implementation. Is this possible ?
Piyush Katariya
  • 655
  • 8
  • 11
0
votes
0 answers

how to differentiate a column type from a decimal literal used in SqlFunction from Calcite?

So I have a custom SqlFunction: public static final class SqlApproximatePercentileFunction extends SqlAggFunction { public SqlApproximatePercentileFunction() { super( "APPROX_PERCENTILE", null, …
cpchung
  • 774
  • 3
  • 8
  • 23
0
votes
0 answers

How is int Prec value decided in Calcite's SqlBinaryOperator?

SqlBinaryOperator constructor Takes Prec value as input to add support for an operator. I wanted to know how that value is decided? Thank you Looking at SqlstdOperatorTable, I saw the values for existing Prec values of various operators but couldn't…
Kanha gupta
  • 1
0
votes
1 answer

calcite cannot move to STATE_2_READY from STATE_5_CONVERTED

enter image description here java.lang.IllegalArgumentException: cannot move to STATE_2_READY from STATE_5_CONVERTED at org.apache.calcite.prepare.PlannerImpl.ensure(PlannerImpl.java:148) at…
A little yy
  • 1
0
votes
0 answers

Is there an Apache Calcite adapter for BigQuery

Is there an Apache Calcite adapter for BigQuery which can translate Calcite SQL to BigQuery operations. I am planning to use Apache Calcite for a unified query solution which can interact with heterogenous data sources and leverage its query…
ATUL ARORA
  • 1
0
votes
1 answer

Where is the data of the files end with .iq of Calcite?

Calcite-core-test-sql-xx.iq files show us the query sentences and the results, so where is the data from? enter image description here
yan mo
  • 11
  • 1
0
votes
0 answers

How to create an EnumerableInterpreter?

I'm able to execute a query against a streaming data source (Apache Pulsar, based my adapter on the Kafka adapter) using the approach outlined here but the results cannot be enumerated. I found some discussion in a Calcite JIRA that led to me to…
Dave
  • 1
0
votes
0 answers

Authentication and authorizations in Apache Calcite (schemas, tables...)

One of my customers made a proof of concept above Apache Calcite. They want me to upgrade it, and one of the needs is to add authentication and authorization of users to restrict access to certain schemas or tables (columns as a bonus) based on user…
SailingSRJ
  • 1
  • 1
0
votes
1 answer

Calcite order by nullpointer exception

I try to perform query over over some table data in Java using Calcite. I try to execute query: select distinct tbl.col1 , tbl.col2 from infoset.SUBEKT tbl order by col1 asc nulls last , col2 asc nulls last And the…
Kirill Kim
  • 1
  • 2
1 2 3
…
16 17