Streaming SQL

2016-12-11 Thread Riccardo Tommasini
Hello everybody, my name is Riccardo Tommasini and I am a PhD student in Computer Science at Politecnico di Milano (Italy). let me first say that this project is just great and I am following the dev list since a couple of weeks, it’s cool to see all this work in progress. I got to know about

Accessing database metadata

2016-12-14 Thread Riccardo Tommasini
for a table for instance? thanks in advance! Riccardo Tommasini Master Degree Computer Science PhD Student at Politecnico di Milano (Italy) streamreasoning.org<http://streamreasoning.org/> Submitted from an iPhone, I apologise for typos.

Re: Accessing database metadata

2016-12-14 Thread Riccardo Tommasini
Hi Julian, thanks for the quick answer. I will do it. Riccardo Tommasini Master Degree Computer Science PhD Student at Politecnico di Milano (Italy) streamreasoning.org<http://streamreasoning.org/> Submitted from an iPhone, I apologise for typos. From: Julian Hyde <mailto:jh...@a

Replace Function

2017-01-04 Thread Riccardo Tommasini
xInst.ex(Resources.java:514) ... 44 more 11:01:07.488 [main] ERROR o.a.calcite.runtime.CalciteException - org.apache.calcite.runtime.CalciteContextException: From line 1, column 8 to line 1, column 35: No match found for function signature TRANSLATE3(, , ) Process finished with exit code 1 [1] https://issues.apache.org/j

Re: Replace Function

2017-01-04 Thread Riccardo Tommasini
Like this? Connection connection = DriverManager.getConnection("jdbc:calcite:;fun=oracle"); Btw, can you point me where JDBC function escape are specified? Cause I think REPLACE should be part of them, am I wrong? Riccardo Tommasini Master Degree Computer Science PhD Student at P

Re: Replace Function

2017-01-04 Thread Riccardo Tommasini
Ok, added under JDBC function escape as suggested in the SQL docs seems passing all the tests. Riccardo Tommasini Master Degree Computer Science PhD Student at Politecnico di Milano (Italy) streamreasoning.org<http://streamreasoning.org/> Submitted from an iPhone, I apologise for typos.

Re: Replace Function

2017-01-08 Thread Riccardo Tommasini
Sure, can you send me a pointer? I am not used to the JIRA system. Riccardo Tommasini Master Degree Computer Science PhD Student at Politecnico di Milano (Italy) streamreasoning.org<http://streamreasoning.org/> Submitted from an iPhone, I apologise for typos. From: Julia

Understanding Calcite DB Metadata [TYPE_NAME]

2017-01-08 Thread Riccardo Tommasini
4 and MYSQL’s INT as INTEGER NOT NULL Can you please explain to me what these datatypes refer to? thanks in advance! [1] https://issues.apache.org/jira/browse/CALCITE-1545 Riccardo Tommasini Master Degree Computer Science PhD Student at Politecnico di Milano (Italy) streamreasoning.org<htt

Re: : ApacheCon CFP closing soon (11 February)

2017-01-18 Thread Riccardo Tommasini
Thinking about it. My group and I are using calcite for ontology based data access Riccardo Tommasini Master Degree Computer Science PhD Student at Politecnico di Milano (Italy) streamreasoning.org<http://streamreasoning.org/> Submitted from an iPhone, I apologise for typos. On 18 Januar

Spark and Calcite

2017-01-18 Thread Riccardo Tommasini
Hello, I'm trying to understand how to use the spark adapter. Does anyone have any example? Thanks in advance Riccardo Tommasini Master Degree Computer Science PhD Student at Politecnico di Milano (Italy) streamreasoning.org<http://streamreasoning.org/> Submitted from an iPhone,

Re: ApacheCon CFP closing soon (11 February)

2017-01-20 Thread Riccardo Tommasini
Interesting, Jordan, can you show me some example on calcite+spark? Riccardo Tommasini Master Degree Computer Science PhD Student at Politecnico di Milano (Italy) streamreasoning.org<http://streamreasoning.org/> Submitted from an iPhone, I apologise for typos. From: jordan.halter...@gma

Re: [DISCUSS] The state of the project - 2017

2017-11-06 Thread Riccardo Tommasini
Hello all, My name is Riccardo Tommasini (Politecnico di Milano) It’s nice to see all these activities and I’m glad that Calcite is finally attracting other people in academia. On my side, In collaboration with the university of Bolzano/Bozen, we are using Calcite for ontology based data access

Re: Recursive query, graph query, Datalog

2017-12-15 Thread Riccardo Tommasini
Hello all, Let me introduce myself again. I’m Riccardo Tommasini, Politecnico di Milano. I do research on Stream Reasoning, graph stream processing. In particular, RDF stream processing and i work with temporal datalog. This is a quite exciting news. Going technical, a datalog frontend that

Re: Resources to contribute

2018-01-27 Thread Riccardo Tommasini
Hi Michael, I’m Riccardo Tommasini from the calcite newsletter. Can you share with me the calcite paper you mentioned? I am working on related research and i would like to read it. Thanks a lot Cheers, RT On 27 Jan 2018, 13:04 +0100, Michael Mior , wrote: Hi Edmon, Sorry for the lack of an

Re: Benchmarking Calcite - starting the conversation on the targets and design of the benchmark

2018-02-04 Thread Riccardo Tommasini
Regarding the Comparison with other federated query processing engines such as Spark SQL and PrestoDB What about KSQL [1] and InfluxDB recent work (looking for a link) [1] https://github.com/confluentinc/ksql RT On 4 Feb 2018, 16:35 +0100, Edmon Begoli , wrote: * Comparison with other fede

Re: "Standardizing" streaming SQL

2018-02-16 Thread Riccardo Tommasini
Hello all, I am definitely interested and I can share some references on existing algebras and work we did on the topic. On 16 Feb 2018, 23:59 +0100, Julian Hyde , wrote: Edmon, If you can make committees aware of this effort, I would be very grateful. It’s very clear to me that people are usi

Re: Updates on Benchmarking and Optimization Research for Calcite

2018-02-28 Thread Riccardo Tommasini
Hello, I can definitely help if you need me to do something. And I would also like to join the online meeting. Cheers, On 20 Feb 2018, 22:13 +0100, Edmon Begoli , wrote: Just a quick update on the progress of benchmarking setup for Calcite, and a call to you for feedback and participation: 1.

Re: Approximate query processing in Calcite

2018-05-04 Thread Riccardo Tommasini
I also find it quite interesting! Iot and social media can be relevant domains of application Riccardo Tommasini Master Degree Computer Science PhD Student at Politecnico di Milano (Italy) streamreasoning.org Submitted from an iPhone, I apologise for typos. On 4 May 2018, 00:58 +0200, Edmon

[jira] [Created] (CALCITE-1545) Exposing Database Metadata

2016-12-18 Thread Riccardo Tommasini (JIRA)
Riccardo Tommasini created CALCITE-1545: --- Summary: Exposing Database Metadata Key: CALCITE-1545 URL: https://issues.apache.org/jira/browse/CALCITE-1545 Project: Calcite Issue Type