Hey Christian,
On Thu, Feb 13, 2020 at 6:30 PM Christian Beikov
wrote:
> Hello,
>
> I'm trying to generate SQL for a trigger that requires a little rewrite
> of a RelNode structure and I wanted to know if anyone could help me
> figure out how to do a few things
>
> * I need to swap left and ri
This is controlled by the `dialect` argument to RelToSqlConverter. If you
can give some more details about what level you're working at, we can help
further.
Jess
On Tue, Dec 8, 2020 at 4:32 AM 莫失莫忘 wrote:
> Default ，String representation is apostrophe in calcite
> SQL ，like 'word' . how
mized differently.
>
> Julian
>
>
> > On Jan 23, 2017, at 8:36 AM, Jess Balint wrote:
> >
> > Hi,
> >
> > I'm trying to use RelBuilder.call() with SqlStdOperatorTable.IN. I want
> to
> > use IN with the scalar expr list form, not a subquery. How shoul
rator. The operand is the "$8" input ref (this is due to
RexSubQuery returning only one operand and not the rel). Any ideas on where
the issue is here?
Thanks a lot.
Jess
On Wed, Jan 25, 2017 at 4:32 PM, Jess Balint wrote:
> Thanks for the hint. I've got this rel tree now:
>
rsing and serialization have been helpful too. Looking forward to
helping with the project.
Jess
On Thu, Feb 16, 2017 at 4:32 PM, Julian Hyde wrote:
> On behalf of the PMC I am delighted to announce Jess Balint as a new
> Calcite committer. Jess has been making a steady stream of impr
Hi,
In SqlDialect, the UNKNOWN dialect uses backticks for quoting. This is a
MySQL-ism. Any reason not to change it to the standard of double-quotes?
Thx.
Jess
Being the last one to commit, it's fine for me. :) Maybe clean first?
Jess
On Fri, Mar 10, 2017 at 4:45 PM, Maryann Xue wrote:
> Hi all,
>
> Was trying to do 'mvn install' today but got an error as follows:
>
> [ERROR] Failed to execute goal de.thetaphi:forbiddenapis:2.3:check
> (default) on pr
Try RelMetadataQuery.getColumnOrigin()
Jess
On Fri, Mar 17, 2017 at 3:07 AM, weijie tong
wrote:
> I have a requirement to find the on condition name of a join clause,
> but while the condition columns from two tables are the same ,I can not
> find the exact join column name.
> For examp
Hi,
I'm trying to build a query based on an existing (parsed) SQL query. I'm
parsing this query:
select
case room_name
when 'Meeting room for Aeronautics' then 'is_aero'
else 'not_aero'
end room_category
from meeting_rooms
The RexNode, after SqlToRelConverter has the "is_aero"
What is the function of the root schema? Why can't I use a JdbcSchema as
the root?
Thx.
Jess
put tables at level 0 or level 7 you
> run the risk of confusing the tools.
>
> If you get it working please contribute a test case.
>
> Julian
>
>
> On Wed, Apr 26, 2017 at 8:04 AM, Jess Balint wrote:
> > What is the function of the root schema? Why can't I use a JdbcSchema as
> > the root?
> >
> > Thx.
> > Jess
>
Anybody considered putting the database version #'s in SqlDialect? There
are many things that can't be decided on product alone, e.g. OFFSET/FETCH
available only since MSSQL 2012 and Oracle 12.
Jess
Can you share your operand constraints? Where did you see HepRelVertex? As
Julian described, the rel nodes are of the correct type when matched with
operand constraints.
Jess
On Tue, Aug 1, 2017 at 7:25 AM, Muhammad Gelbana
wrote:
> I'm facing a similar problem but with Join inputs. Is there a
The parser should handle this. What is stopping you from parsing it?
On Wed, Aug 16, 2017 at 11:47 PM, SN, Ranganath
wrote:
> Hi Team,
> I am trying to parse nested query. Is there any functionalities or apis to
> parse nested query.
>
> Sample query: Select a,b,c from d where d.id in (select i
Is there a function which searches for a substring? Thanks.
Jess
I'm returning string objects from my enumerable, but getting an exception
when trying to use the MONTH function which compiles to:
org.apache.calcite.avatica.util.DateTimeUtils.unixDateExtract(org.apache.calcite.avatica.util.TimeUnitRange.MONTH,
org.apache.calcite.runtime.SqlFunctions.toInt(curre
Just doing a bit of code reading here. Looking at the SortRemoveRule
implementation:
// Express the "sortedness" requirement in terms of a collation trait
and
// we can get rid of the sort. This allows us to use rels that just
happen
// to be sorted but get the same effect.
final R
=
sort.getInput().getTraitSet().replace(collation);
call.transformTo(convert(sort.getInput(), traits));
}
This will cause the test to pass. Isn't this a bug?
Jess
> Julian
>
>
> > On Oct 14, 2016, at 2:33 PM, Jess Balint wrote:
> >
> > Just d
ger a merge of those sets: the planner now knows that any
> relational expression in either of those sets is now equivalent to any
> other.
>
> > On Oct 14, 2016, at 3:34 PM, Jess Balint wrote:
> >
> > On Fri, Oct 14, 2016 at 5:16 PM, Julian Hyde wrote:
> >
&g
Hi,
Using the RelBuilder API, I would like to create a join condition using
table aliases. The RelBuilder.field(relationAlias, fieldName) method only
checks the top of the stack. The top of the stack is not yet a join node if
using the RelBuilder.join(joinType, joinCondition) method. Here's an
exa
thoughts?
On Tue, Nov 22, 2016 at 3:41 PM, Jess Balint wrote:
> Hi,
>
> Using the RelBuilder API, I would like to create a join condition using
> table aliases. The RelBuilder.field(relationAlias, fieldName) method only
> checks the top of the stack. The top of the stack is not
On Nov 30, 2016, at 12:18 PM, Jess Balint wrote:
> >
> > thoughts?
> >
> > On Tue, Nov 22, 2016 at 3:41 PM, Jess Balint wrote:
> >
> >> Hi,
> >>
> >> Using the RelBuilder API, I would like to create a join condition using
> >> t
Thanks.
Jess
> > The two calls to “field” don’t know they’re in a call to “join”, and in
> particular don’t know that “join” is about to pop two relational
> expressions of the stack. The “2” argument provides that information.
> Without it RelBuilder has no chance to generate the rig
Hi,
I used ProjectRemoveRule, but it's not working. When debugging, I arrive at
this code:
Project project = call.rel(0);
RelNode stripped = project.getInput();
if (stripped instanceof Project) {
The *stripped* object here is an instance of *HepRelVertex* and therefore
this code does not recogniz
Hi,
1.11.0 is not marked as released in Jira. :)
Jess
On Mon, Jan 9, 2017 at 2:38 AM, Julian Hyde wrote:
> The Apache Calcite team is pleased to announce the release of Apache
> Calcite 1.11.0.
>
> Calcite is a dynamic data management framework. Its cost-based
> optimizer converts queries, repre
Hi,
I'm trying to use RelBuilder.call() with SqlStdOperatorTable.IN. I want to
use IN with the scalar expr list form, not a subquery. How should this be
represented by a RexNode? I tried using SqlToRelConverter and it parses as
"x = 1 OR x = 2 ". When I used the expr list form through RelBuild
Where/why is it lost? I've never experienced this with other (non-Apache)
projects.
On Thu, Dec 2, 2021 at 2:32 PM Vladimir Sitnikov <
sitnikov.vladi...@gmail.com> wrote:
> Thanks for the pointers. The committer info is lost indeed.
> I would add the comments to asf.yaml so we can re-iterate late
Author is retained there. It's not set to the person who merged the PR.
On Thu, Dec 2, 2021 at 2:58 PM Vladimir Sitnikov <
sitnikov.vladi...@gmail.com> wrote:
> >I've never experienced this with other (non-Apache) projects.
>
> https://github.com/JetBrains/kotlin-wrappers/pull/969
>
> git show --
The 1.29.0 version needs to be set to "Released" in Jira.
On Sat, Dec 25, 2021 at 11:23 PM Rui Wang wrote:
> Hi community,
>
> Can a PMC member help update the 1.29.0 release version and date at
> https://reporter.apache.org/addrelease.html?calcite? For the release date
> please use 12-26-2021 U
Hi Mans,
This statement in the Javadoc sums it up for me:
Generally a Table will implement this interface to create a particular
subclass of RelNode,
and also register rules that act on that particular subclass of RelNode.
The Table instances in the Schema must be implemented in some way
Hi Stamatis,
I can do 1.32.0 (or whatever makes sense).
Jess
On Thu, Feb 24, 2022 at 5:11 AM Stamatis Zampetakis
wrote:
> Hi all,
>
> In the last 2 years or so we had the following people helping out with
> releasing Calcite.
>
> 1.22.0 Danny Chan
> 1.23.0 Haisheng Yuan
> 1.24.0 Chunwei Lei
>
Hi Stamatis,
Can you add mine also please? I have appended it to Liya Fan's KEYS.txt:
https://gist.github.com/jbalint/fe02278549c38ea037af44b3efdb5545
Jess
On Fri, Mar 4, 2022 at 9:41 AM Fan Liya wrote:
> Hi Stamatis,
>
> Thanks for your good suggestion.
> I have uploaded the updated KEYS fil
I would also like to participate in this. Available 12:00 through 04:00 UTC.
On Sun, Mar 20, 2022 at 3:18 PM Stamatis Zampetakis
wrote:
> Hey Liya,
>
> I can sign your key. Feel free to propose a timeslot when you are available
> and we can hold a virtual key signing party; I am in UTC+1.
>
> Th
You can return null in your rule implementation if the transformation
cannot produce a valid plan. If this is not clearly the answer to what
you're asking, please share an example or some details about what you're
attempting to do.
Jess
On Mon, Apr 11, 2022 at 1:29 PM Soumyava Das wrote:
> Hi,
Sure I'll take a look. Thanks for raising it.
On Wed, Jun 22, 2022 at 6:52 PM Julian Hyde wrote:
> Can someone else do this review?
>
>
> Begin forwarded message:
>
> *From: *"Jiajun Xie (Jira)"
> *Subject: **[jira] Jiajun Xie mentioned you on CALCITE-5013 (Jira) (JIRA)*
> *Date: *June 14, 2022
Hi Yiyun,
The first requirement is that you will need to make some table cardinality
estimates available to the query planner (eg. via
RelMetadataQuery.getRowCount()). This will allow you to implement some
threshold for deciding when to use the described join algorithm. The
algorithm is known as "
t; follows:
> - 1.30.0 Liya Fan
> - 1.31.0 Andrei Sereda
> - 1.32.0 Julian Hyde (originally Jess Balint, switched with 1.33)
> ---
> - 1.33.0 Jess Balint (originally Julian Hyde, switched with 1.32)
> - 1.34.0 Duan Xiong
>
> @Jess, are you still available to be the next R
ing as
> RM.
> The updated list for future releases will be as follows:
> - 1.33.0 Jess Balint
> - 1.34.0 Duan Xiong
> - 1.35.0 Benchao Li
>
> There are currently 14 unresolved issues for 1.33:
> https://issues.apache.org/jira/secure/Dashboard.jspa?selectPageId=123339
rg/jira/browse/CALCITE-5399
> >
> >
> > On Thu, Dec 15, 2022 at 3:14 AM Sean Broeder wrote:
> >
> >> Are there plans to release a new version of Avatica(1.23) to be
> included
> >> in Calcite 1.33.0?
> >>
> >> Thanks,
> >> Sean
>
ra/secure/Dashboard.jspa?selectPageId=12333950
> > >>> <
> > >>>
> > >>
> https://issues.apache.org/jira/secure/Dashboard.jspa?selectPageId=12333950
> > >>>
> > >>> ] there are 6 open issues, all of which have pull requests.
2:03 PM, Stamatis Zampetakis
> wrote:
> > >
> > > Thanks for staying on top of this Jess!
> > >
> > > Apart from the two JIRAs marked as blockers (regressions from 1.32.0) I
> > > don't think we should wait much more for getting the release out.
Great, I'll start the build. Let's hold off on further commits please.
On Wed, Jan 25, 2023 at 6:48 PM Julian Hyde wrote:
> I have merged it:
>
> https://github.com/apache/calcite/commit/20014b6c5b9b57d29248206f19d63ef50f7a5c0f
>
> On Wed, Jan 25, 2023 at 2
> > >>> On Jan 26, 2023, at 12:09 AM, Ruben Q L wrote:
> > >>>
> > >>> According to our Jira dashboard [1] it seems there's still one
> blocker
> > >>> issue for 1.33 [2] (it was categorized as blocker because it was a
> > >>> r
have no problem waiting for the release to be rolled out before
> merging
> > > it, just wanted to reach out to see if you prefer to merge it right
> away,
> > > in case please let me know.
> > >
> > > Btw, thanks Jess for being the release manager!
> > >
Speaking of which, why don't we branch off for the release to avoid
blocking commits?
On Thu, Feb 2, 2023 at 1:29 PM Jess Balint wrote:
> Sorry for delay! I'll get the release notes PR up in a few hours.
>
> On Thu, Feb 2, 2023 at 1:28 PM Julian Hyde wrote:
>
>> Je
Hi all,
I have created a build for Apache Calcite 1.33.0, release
candidate 0.
Thanks to everyone who has contributed to this release.
You can read the release notes here:
https://github.com/apache/calcite/blob/calcite-1.33.0-rc0/site/_docs/history.md
The commit to be voted upon:
https://gitbox
Thanks to everyone who has tested the release candidate and given
their comments and votes.
The tally is as follows.
4 binding +1s:
- Francis Chuang
- Ruben Q
- Julian Hyde
- Benchao Li
3 non-binding +1s:
- Alessandro Solimando
- Sergey Nuyanzin
- Jess Balint
No 0s or -1s.
Therefore, I am
. If we continued
> development during a release we would need to make a git merge commit (for
> the release notes at least).
>
> On 2023/02/02 19:38:40 Jess Balint wrote:
> > Speaking of which, why don't we branch off for the release to avoid
> > blocking commits?
&
>
>
> On Tue, Feb 7, 2023 at 12:36 AM Julian Hyde
> wrote:
>
> > It looks as if the directory was successfully moved from dev to release.
> > (Does anyone know the URL for the dist.apache.org svn commit log?)
> >
> >
> > > On Feb 6, 2023, at 1:48 PM, Je
tml?calcite
and add your release data (version and date) to the database.
On Tue, Feb 7, 2023 at 1:02 PM Julian Hyde wrote:
> Jess, Please let us know when main is open.
>
> > On Feb 7, 2023, at 8:59 AM, Jess Balint wrote:
> >
> > I ran it more than once because it fail
gt; > On Feb 7, 2023, at 11:27 AM, Jess Balint wrote:
> >
> > Can a PMC member please set the release date?
> >
> > r59936 at 2023-02-06 21:29:21 + (Mon, 06 Feb 2023)
> > Promoting Apache Calcite calcite-1.33.0-rc0 -> calcite-1.33.0 to release
> > area
&g
.33.0/
We welcome your help and feedback. For more information on how to
report problems, and to get involved, visit the project website at:
https://calcite.apache.org/
Thanks to everyone involved!
Jess Balint, on behalf of the Apache Calcite Team
ated from that. Back in the day I had trouble generating the site when
> local date <> UTC date, or when the news item date was in the future.
>
> When I see you push the web site updates, I’ll update reporter.
>
> Julian
>
>
> > On Feb 7, 2023, at 11:33 AM, Jess Ba
[1] https://calcite.apache.org/downloads/
> [2] https://calcite.apache.org/docs/history.html#v1-33-0
>
> On Wed, Feb 8, 2023 at 11:28 AM Stamatis Zampetakis
> wrote:
>
> > Great work Jess, thanks a lot for being the RM!
> >
> > On Wed, Feb 8, 2023 at 12:57 AM Je
> > >>> wrote:
> > >>>
> > >>>> I said I’d update reporter. Sorry I didn’t get to it.
> > >>>>
> > >>>> Jess, Several improvements to history.md were discussed in the PR.
> Do
> > >> you
> > &
one that we voted on.
>
> By the way, did you get round to revising the release notes based on PR
> comments?
>
> Julian
>
> > On Feb 22, 2023, at 7:26 AM, Jess Balint wrote:
> >
> > Stamatis,
> >
> > The release commit referenced on the site
> &g
Any chance to do this in European afternoon so those in US can join in
their morning?
On Fri, May 16, 2025 at 11:52 AM Ruben Q L wrote:
> I'll be there.
>
>
> pub rsa4096 2020-09-26 [SC]
>
> 464F A4A3 D7E4 2112 E4CB 68F2 DF92 5FEB A08B 032B
>
> uid[ absoluta ] Ruben Quesada Lop
Jess Balint created CALCITE-3994:
Summary: RexSimplify reduce concat calls with constant arguments
Key: CALCITE-3994
URL: https://issues.apache.org/jira/browse/CALCITE-3994
Project: Calcite
Jess Balint created CALCITE-4245:
Summary: Expression reduction regression
Key: CALCITE-4245
URL: https://issues.apache.org/jira/browse/CALCITE-4245
Project: Calcite
Issue Type: Bug
Jess Balint created CALCITE-1607:
Summary: RelToSqlConverter assertion error with projection over
sort
Key: CALCITE-1607
URL: https://issues.apache.org/jira/browse/CALCITE-1607
Project: Calcite
Jess Balint created CALCITE-1610:
Summary: RelBuilder sort-combining optimization treats aliases
incorrectly
Key: CALCITE-1610
URL: https://issues.apache.org/jira/browse/CALCITE-1610
Project: Calcite
Jess Balint created CALCITE-1611:
Summary: RelToSqlConverter not handling table alias reference
correctly
Key: CALCITE-1611
URL: https://issues.apache.org/jira/browse/CALCITE-1611
Project: Calcite
Jess Balint created CALCITE-1625:
Summary: add basic JDBC statistics
Key: CALCITE-1625
URL: https://issues.apache.org/jira/browse/CALCITE-1625
Project: Calcite
Issue Type: Improvement
Jess Balint created CALCITE-1627:
Summary: Statistics.of() instance doesn't acknowledge super sets
of keys
Key: CALCITE-1627
URL: https://issues.apache.org/jira/browse/CALCITE-1627
Project: Ca
Jess Balint created CALCITE-1631:
Summary: RelMdUniqueKeys doesn't handle TableScan
Key: CALCITE-1631
URL: https://issues.apache.org/jira/browse/CALCITE-1631
Project: Calcite
Issue Type
Jess Balint created CALCITE-1638:
Summary: Simplify $x=$x to true
Key: CALCITE-1638
URL: https://issues.apache.org/jira/browse/CALCITE-1638
Project: Calcite
Issue Type: Improvement
Jess Balint created CALCITE-1640:
Summary: SqlImplementor (RelToSql) doesn't handle join cond same
as filter
Key: CALCITE-1640
URL: https://issues.apache.org/jira/browse/CALCITE-1640
Project: Ca
Jess Balint created CALCITE-1869:
Summary: NPE validating unbounded window functions
Key: CALCITE-1869
URL: https://issues.apache.org/jira/browse/CALCITE-1869
Project: Calcite
Issue Type
Jess Balint created CALCITE-1891:
Summary: NPE in RelBuilder.values() if types are not coercible
Key: CALCITE-1891
URL: https://issues.apache.org/jira/browse/CALCITE-1891
Project: Calcite
Jess Balint created CALCITE-1913:
Summary: Include DB version in SqlDialect
Key: CALCITE-1913
URL: https://issues.apache.org/jira/browse/CALCITE-1913
Project: Calcite
Issue Type: Improvement
Jess Balint created CALCITE-3192:
Summary: Simplify OR incorrectly weaks condition
Key: CALCITE-3192
URL: https://issues.apache.org/jira/browse/CALCITE-3192
Project: Calcite
Issue Type: Bug
Jess Balint created CALCITE-3342:
Summary: sqltorelconverter adds extra fields with order by
Key: CALCITE-3342
URL: https://issues.apache.org/jira/browse/CALCITE-3342
Project: Calcite
Issue
Jess Balint created CALCITE-3430:
Summary: JDBC adapter generates extra alias for VALUES when used
in join
Key: CALCITE-3430
URL: https://issues.apache.org/jira/browse/CALCITE-3430
Project: Calcite
Jess Balint created CALCITE-3489:
Summary: Adding day interval to timestamp returns incorrect value
Key: CALCITE-3489
URL: https://issues.apache.org/jira/browse/CALCITE-3489
Project: Calcite
Jess Balint created CALCITE-1522:
Summary: RelBuilder.union() hits assertion when arguments can't
have a common row type
Key: CALCITE-1522
URL: https://issues.apache.org/jira/browse/CALCITE
Jess Balint created CALCITE-1523:
Summary: Add RelBuilder field() method to reference aliased
relations not on top of stack
Key: CALCITE-1523
URL: https://issues.apache.org/jira/browse/CALCITE-1523
Jess Balint created CALCITE-1551:
Summary: RelBuilder's project() doesn't preserve alias
Key: CALCITE-1551
URL: https://issues.apache.org/jira/browse/CALCITE-1551
Project: Calcite
Jess Balint created CALCITE-1582:
Summary: RelToSqlConverter doesn't handle cartesian join (no join
cond)
Key: CALCITE-1582
URL: https://issues.apache.org/jira/browse/CALCITE-1582
Project: Ca
Jess Balint created CALCITE-1584:
Summary: ProjectRemoveRule loses field names
Key: CALCITE-1584
URL: https://issues.apache.org/jira/browse/CALCITE-1584
Project: Calcite
Issue Type: Bug
Jess Balint created CALCITE-1585:
Summary: SqlPrettyWriter doesn't respect alwaysUseParentheses
Key: CALCITE-1585
URL: https://issues.apache.org/jira/browse/CALCITE-1585
Project: Ca
Jess Balint created CALCITE-1595:
Summary: NPE in SqlTypeUtil
Key: CALCITE-1595
URL: https://issues.apache.org/jira/browse/CALCITE-1595
Project: Calcite
Issue Type: Bug
Components
81 matches
Mail list logo
