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

Apache Calcite 1.13.0 produced null pointer exception compared to 1.12.0

Using Apache Calcite on Windows and trying to query the DEPTS.csv used on the website tutorial I get a NullPointerException when using Calcite Core 1.13.0 but when I use 1.12.0 the issue disappears. Properties info = new Properties(); …
Mark Ashworth
  • 164
  • 12
0
votes
0 answers

How to Apache Calcite query mongo DB by using Relational Algebra

Can any one share sample code for Apache Calcite querying MongoDB by using relational algebra.
Kamatchi Gunasekaran
  • 47
  • 7
0
votes
1 answer

Insert,update ,delete,drop sample code by using relation algebra

I am new Apache Calcite and am able to fetch the data from DB by using relational algebra ,but not able to do insert,update, delete,drop operation. If can share sample code will be more helpful.
Kamatchi Gunasekaran
  • 47
  • 7
0
votes
1 answer

Is there a method to derive equivalent filters from join filters and others?

Q1: select * from t1, t2 where t1.a = t2.b and t1.a = 2; It is equivalent to follow query. Q2: select * from t1, t2 where t1.a = t2.b and t1.a = 2 and t2.b = 2; Now, I use Apache Calcites to generate plan for Q1, and use…
inferno
  • 684
  • 6
  • 21
0
votes
1 answer

Hyperunique Aggregations in Calcite-Druid Adapter

In my Druid data source, I have a hyperUnique aggregation (ingestion time) on one of the fields. I am trying to do the equivalent of COUNT(DISTINCT()) on this aggregated field. Is it supported in the Calcite Druid Adapter? If so,…
Vihag Gupta
  • 3
  • 1
0
votes
1 answer

Apache Calcite: Handle special characters in MongoDB collection names

Is there a way to execute SQL queries on MongoDB if the collection's name contains special characters such as 1a84375b-9bd0-4ec3-9f93-536ce380f813? I encounter org.apache.calcite.sql.parser.impl.ParseException when I execute my statement. Are there…
Pete
  • 13
  • 4
0
votes
2 answers

Kylin - Group by Rollup and Cube

I am trying to use the ROLLUP and CUBE operators to summarise data using the sample cube. If I execute the query the following error message is returned: Internal error: Error while applying rule OLAPAggregateRule, args…
rivethead_
  • 131
  • 1
  • 6
0
votes
2 answers

How to install two different version of a specific package in Maven?

I'm connecting to 2 different DB, and their JDBC client both requires the package org.apache.calcite.avatica, one is using version 1.6, and another is using version 1.8, so I need to install both the versions (1.6 and 1.8), and seems that the…
luochen1990
  • 3,689
  • 1
  • 22
  • 37
0
votes
0 answers

calcite, id filters , what is the easiest way to get them?

I would like to find the easiest way to get the filters for id columns of my tables. Currently I use FilterableTable but that returns the filters as an expression tree and I would have to scan for it. I am wondering if there is an easier way to get…
kostas.kougios
  • 945
  • 10
  • 21
0
votes
2 answers

Insert multiple rows with one request using phoenix query server on Hbase

I am looking to combine multiple upsert requests into one request and pass it to the phoenix query server. I am sending the following json to upsert one record POST https://tishihdiphoenix.azurehdinsight.net/hbasephoenix/ HTTP/1.1 request: { …
Aditya Goparaju
  • 1
  • 3
-1
votes
1 answer

how to use Apache calcite to create rexwindow

I would like to create a SQL like this: select ROW_NUMBER() over(order by orderno) as id from process then I try to use "SqlSelect" to create parse tree, but I don't konw how to create function "ROW_NUMBER() over(order by orderno)". Maybe I should…
qqqq
  • 1
-1
votes
1 answer

How to add a udf who's parameter is a table name

I want to add a udf to calcite. The udf's parameter is a table name, and it will return a varchar value. Are there any sample for this? Thanks. My test sql is: SELECT MYTEST22(a), MYTEST(a), MYTEST1(a), COUNT(*) FROM alisis.table1 WHERE…
fei.chen
  • 13
  • 5
-1
votes
1 answer

Apache Calcite is not working in Web Application

I'm using Apache Calcite in My Project to do CSV,Excel and Other Database management. Its working when i execute through main method but its giving an error while executing through web service Caused by: java.lang.RuntimeException:…
Prasad V S
  • 262
  • 4
  • 17
-1
votes
1 answer

How to insert data in Apache calcite

I'm inserting data form SQL to File through Apache calcite Class.forName("org.apache.calcite.jdbc.Driver"); Connection connection = DriverManager.getConnection("jdbc:calcite:"); CalciteConnection calciteConnection =…
Prasad V S
  • 262
  • 4
  • 17
1 2 3
…
16
17