Re: Need Help on RelToSqlConverter simple use case

Please ignore my previous mail. I was able to get expected results. I got the project list properly expanded using visitRoot(relNode).asStatement(). Earlier I was using visitInput(relNode, 0).asQueryOrValues() which was generating wild card based projection list. Regards, Karthick On Sat, Mar

Need Help on RelToSqlConverter simple use case

Hi All, I am trying to use calcite as a sql rewrite layer to attach some default filter conditions on the incoming SQL queries for execution. I have been able to successfully add FilterRule and modified the logicalplan to include the filter. But when the convert the query back from RelNode to

Re: Would appreciate help with first PR

FYI, ServerTest.testTruncateTable() is a known unstable test[1]. [1] https://issues.apache.org/jira/browse/CALCITE-6048 Tanner Clary 于2023年11月2日周四 07:49写道： > > Hi Paul, > > Thanks for opening your first PR! I took a look and I think it might have > been a flaky failure, I believe that has

Re: Would appreciate help with first PR

Hi Paul, Thanks for opening your first PR! I took a look and I think it might have been a flaky failure, I believe that has happened to me in the past. I approved the workflow run so we will see what happens with CI, I will try to give the PR a review in the meantime :) Thanks again! Best,

Would appreciate help with first PR

I just created https://github.com/apache/calcite/pull/3495 for  https://issues.apache.org/jira/browse/CALCITE-6044. It's my first PR. I'm getting what appears to be a code quality error or a test failure in  ServerTest.testTruncateTable(), which passes when I run it locally. Any tips for where

Re: [Help Needed] Dissecting CTE out of Calcite LogicPlan

anually traverse the entire tree and > use WITH-AS to wrap any sub-trees with a LogicalProject root. By doing so > we will have an easy-to-understand SQL equivalent of the original SQL. > After some research, we came to believe that this feature is not readily > available in Calcite, and decide

Re: [Help Needed] Dissecting CTE out of Calcite LogicPlan

AS to wrap any sub-trees with a LogicalProject root. By doing so we will > have an easy-to-understand SQL equivalent of the original SQL. After some > research, we came to believe that this feature is not readily available in > Calcite, and decide to reach out for help as our current approach ha

[Help Needed] Dissecting CTE out of Calcite LogicPlan

with a LogicalProject root. By doing so we will have an easy-to-understand SQL equivalent of the original SQL. After some research, we came to believe that this feature is not readily available in Calcite, and decide to reach out for help as our current approach has blockers. To illustrate our current approach

Who can help review my pull request?

Who can help review my pull request? https://issues.apache.org/jira/browse/CALCITE-5860 https://github.com/apache/calcite/pull/3326

Re: Documentation / Resources to help getting started with Elasticsearch Adapter

; > Please keep me in the loop on this thread. I am an experienced Java dev, > > but just joined and need to learn Calcite and Apache tools. This thread > > looks perfect for me to shadow and learn, plus help Sumanth with ES and > > Java. > > > > For beginners, where

Re: Documentation / Resources to help getting started with Elasticsearch Adapter

, Alessandro On Thu 6 Jul 2023, 17:23 Joe Talafous, wrote: > Hi Calcite Devs, > > Please keep me in the loop on this thread. I am an experienced Java dev, > but just joined and need to learn Calcite and Apache tools. This thread > looks perfect for me to shadow and learn, pl

Re: Documentation / Resources to help getting started with Elasticsearch Adapter

Hi Calcite Devs, Please keep me in the loop on this thread. I am an experienced Java dev, but just joined and need to learn Calcite and Apache tools. This thread looks perfect for me to shadow and learn, plus help Sumanth with ES and Java. For beginners, where is the proper place to read

Documentation / Resources to help getting started with Elasticsearch Adapter

be really helpful if I could get a tutorial document on connecting to ElasticSearch programmatically. Thanks in advance for your help and all the work you are doing with Calcite and I will make sure to share these resources with the community if it helps me. So others with the same issue can refer

RE: Developing problems with Calcite - Need help

/calciteCompiler/CalciteCompiler.java#L314 Mihai -Original Message- From: brunofsdias Sent: Saturday, July 01, 2023 10:03 AM To: dev@calcite.apache.org Subject: Developing problems with Calcite - Need help Hello. My name is Bruno, and I'm a Software Engineer student at University of Minho. I am

Developing problems with Calcite - Need help

and the LogicalSort past the Join. I have tried to remove the rules that can transpose the Filter, Sort and Joins, and ddi change the computeSelfOfCost functions so that the Join tries to be done first, but then it just always does a scan of the file. Can you help me with this? What can be the best solution

Help with EnumerableInterpreter

This is a follow-on from a Stack Overflow question a couple of days ago, but some progress has been made. I'm now using the approach in the EndToEndEnumerableExample but still getting issues. I'm able to execute a query against a streaming data source (Apache Pulsar, based my adapter on the Kafka

Re: Help with implementation of parsing typed array from string

Thank you for sharing the link! It helps to derive array type, but how to properly implement parsing when type is known ? I was thinking of defining a method 'parseLiteral(String, RelDataType)' in the 'SqlAbstractParserImpl' class that would call a specific parser method depending on the type.

Re: Help with implementation of parsing typed array from string

Are you familiar with the work I did in https://issues.apache.org/jira/browse/CALCITE-5424 to defer the creation of literals? Previously when a literal is a type followed by a string, such as DATE ‘1969-07-21’, the string was parsed in the parser; now we defer parsing the string until

Help with implementation of parsing typed array from string

Hi! Some time ago, I implemented an implicit cast from string literals to arrays [1]. However, this implementation has limitations. For instance, the following query will not work: select a.v = ARRAY[1,2] FROM UNNEST(ARRAY['{1,2}', '{3,4}']) as a(v); Additionally, an implicit cast from arrays to

Re: Help converting a SHA1 hash to Oracle

alect = OracleSqlDialect.DEFAULT;; > String Query = > compliantFunction.toSqlString(translationDialect).toString(); > My key issue seems to be how I get VARCHAR(200) in my cast function, > secondly everything included the CAST AS has been quoted. > I’ve tried SO for support and according to the Calcite website, It > recommended I try here. So any help would be appreciated? > > Thanks > -- Best, Benchao Li

Help converting a SHA1 hash to Oracle

200) in my cast function, secondly everything included the CAST AS has been quoted. I’ve tried SO for support and according to the Calcite website, It recommended I try here. So any help would be appreciated? Thanks

Re: Help with adding Spark functionality

Hi Sophie~ FIRST and LAST are keywords, but they also are nonReservedKeywords[1]. I found a JIRA ticket[2] about FIRST_VALUE/LAST_VALUE, maybe it is useful for you. Refs: [1]

Re: Help with adding Spark functionality

According to this [1] FIRST is a synonym for FIRST_VALUE, which Calcite already has. Please log a Jira case describing the feature you want. Then design discussions can occur against that case. Have a look through the commit log at how people have added dialect-specific functions. Usually adding

Help with adding Spark functionality

Hi, I'm looking to add support for the Spark FIRST and LAST functions. Please can I have some pointers as to where to look? In particular in reference to how it can be handled separately than the FIRST function that's part of MATCH_RECOGNIZE Thanks, Sophie -- This email is confidential, if

Re: [for help] Should I change my commit user.email?

It happens to the best of us! It turns out that I've used not fewer than 5 different combinations over the years: $ git log --author=hyde|grep Author:|sort |uniq Author: Julian Hyde Author: Julian Hyde Author: Julian Hyde Author: julianhyde Author: julianhyde These days I prefer to use my

Re: [for help] Should I change my commit user.email?

Thank you, Alessandro Solimando, and Benchao Li. Git commit history shouldn’t be changed in any case indeed, I am just a little nervous about the mistake I made. I will use my personal email in the future contributions. > 2022年10月17日 19:21，Benchao Li 写道： > > As I can see, there is no need

Re: [for help] Should I change my commit user.email?

I have probably misunderstood the concern then, if you just want to link different email addresses to the same GitHub account, then it's totally fine and doable (no need to rewrite git history or anything). I sensed that Mou Wu wanted to remove any reference to the work email (possibly because

Re: [for help] Should I change my commit user.email?

As I can see, there is no need to change the git commit history. Github allows adding multiple email addresses, you can add your company's email address to your Github account as well. After that, all the things will work fine in Github, such as that Github will know that you have committed to

Re: [for help] Should I change my commit user.email?

Hi Mou Wu, over the years I have seen several contributors using their working emails in the git commits, in principle I don't think there is any issue with that. In any case, I guess it would not be possible to amend git history to change the email, as this will change the sha1 for all

[for help] Should I change my commit user.email?

Hello committers: I contributed two pull requests(commits: 3d39fdcee, b16df019e) in recent two mouths, I found I committed my company’s email instead of my personal email on these two commits(thanks Benchao Li, he reminded me), and I should committed my personal email because my GitHub’s email

need help on building calcite fat jar

y might have done this before, Please help me. This is in gradle build , I am very new in gradle . Regards, Kartik

Re: HELP !

Hi, xiaochen~ As mentioned in calcite-5225, you can add it to SqlLibraryOperators. If you have many functions to add, create your SqlOperatorTable and use ChainedSqlOperatorTable is a more suitable way. For example,

HELP !

Error: No match found for function signature TO_CHAR() BACKGROUND： I want to implement a function that can suffice for parsing and validating complex Oracle SQL. But I encountered some Oracle functions and keywords that are not supported during development, I don't know how to do it!

Re: Re: Re: Re: Looking for help: There are not enough rules to produce a node with desired properties

Hey Benchao, Thank you for your guidance and advice. I am very happy to be able to develop based on calcite. Thank you very much! -原始邮件- 发件人:"Benchao Li" 发送时间:2022-06-26 18:20:53 (星期日) 收件人: "方丰斌" <8692182...@zju.edu.cn>, dev@calcite.apache.org 抄送: 主题: Re

Re: Re: Re: Looking for help: There are not enough rules to produce a node with desired properties

t; *发件人:*"Benchao Li" > *发送时间:*2022-06-26 09:45:36 (星期日) > *收件人:* "方丰斌" <8692182...@zju.edu.cn> > *抄送:* dev@calcite.apache.org > *主题:* Re: Re: Looking for help: There are not enough rules to produce a > node with desired properties > > I tried t

Re: Re: Looking for help: There are not enough rules to produce a node with desired properties

gt; no convert. I solved the problem according to your suggestion. > > BTW：I tried to add DDL statements and create a custom table (which > inherits AbstractTable). However, it is obvious that some rules cannot be > converted when CBO is started. Can you help provide some suggestions? Thank > y

Re: Re: Looking for help: There are not enough rules to produce a node with desired properties

CBO is started. Can you help provide some suggestions? Thank you very much! -原始邮件- 发件人:"Benchao Li" 发送时间:2022-06-25 20:56:00 (星期六) 收件人: dev@calcite.apache.org, 8692182...@zju.edu.cn 抄送: 主题: Re: Looking for help: There are not enough rules to produce a node with desired properti

Re: Looking for help: There are not enough rules to produce a node with desired properties

subscribe to the list so that you > receive updates. > > Julian > > > On Jun 24, 2022, at 09:37, 方丰斌 <8692182...@zju.edu.cn> wrote: > > > > Hey all, > > > > > > > > > >I'm trying to use VolcanoPlanner. I have encountered th

Re: Looking for help: There are not enough rules to produce a node with desired properties

> problems. I hope I can ask for some help. Thank you very much！ > >Test code： > > ` > >VolcanoPlanner planner = new VolcanoPlanner(); >planner.addRelTraitDef(ConventionTraitDef.INSTANCE); > >// Below two lines are important for t

Looking for help: There are not enough rules to produce a node with desired properties

Hey all, I'm trying to use VolcanoPlanner. I have encountered the following problems. I hope I can ask for some help. Thank you very much！ Test code： ` VolcanoPlanner planner = new VolcanoPlanner(); planner.addRelTraitDef(ConventionTraitDef.INSTANCE

Need help in calcite materialized view.

Hi Team, I am trying to use calcite for maintaining materialized views. I am facing some issues while rewriting sql. I am using volcano planner and initiating calcite through following ways: 1. Initiating volcano planner then adding materialized rules. 2. Adding materialized views in planner. 3.

Re: Help adding Snowflake variant syntax

Hi Julian, Thanks for asking those questions! I was providing this material as an educational reference since the use case is very similar to the resources I shared. I found those references to help enrich the Calcite community in the past. For example, Gavin Ray has written an article [1

Re: Help adding Snowflake variant syntax

Let’s suppose that there is code/tests in Coral would allow Calcite to implement this feature. Under the terms of Coral’s license (BSD2) some COULD copy code from Coral to Calcite, but SHOULD they? As an Apache project, and as individuals participating in an open source community beyond the

Re: Help adding Snowflake variant syntax

Hi Erik, Coral [1, 2] which is based on Calcite might be a good starting point for this type of work.There are a couple of dialects it supports right now: Hive (or Spark) and Trino (or Presto). You can check out the corresponding test cases [3, 4] for these two dialects. coral-common [5] is a

Help adding Snowflake variant syntax

I'm Erik and I'm currently working on a project that requires a patch to Calcite as described in this email (a related Jira task is here

Help for Fixing TpcdsLatticeSuggesterTest in calcite

help me fix this problem?

Re: [HELP][Release 1.30.0]

Hi Stamatis, Thanks a lot for your kind help and precious time. I am in UTC+8, and available today (2022-03-21) between 10:00 and 14:00 UTC. Hi Jess, The time slot you proposed is OK for me. I am afraid it is not convenient for people in UTC+1. Anyway, please propose another time slot

Re: [HELP][Release 1.30.0]

t; On Sun, Mar 20, 2022 at 11:26 AM Fan Liya wrote: > > > The problem was worked around by building the site manually. > > If we find the root cause, maybe we need to adjust the document > > accordingly. > > > > BTW, we need a PMC to update the latest release at > &g

Re: [HELP][Release 1.30.0]

, we need a PMC to update the latest release at > https://reporter.apache.org/addrelease.html?calcite > Is there anyone willing to help? > Thank you in advance. > > Best, > Liya Fan > > > > Fan Liya 于2022年3月20日周日 16:54写道： > > > Hi all, > > > > Whe

Re: [HELP][Release 1.30.0]

The problem was worked around by building the site manually. If we find the root cause, maybe we need to adjust the document accordingly. BTW, we need a PMC to update the latest release at https://reporter.apache.org/addrelease.html?calcite Is there anyone willing to help? Thank you in advance

Re: [HELP][Release 1.30.0]

月19日周六 16:59写道： > Hi Francis, > > Thanks a lot for your feedback. > I can see it propagated too. > > However, it is not listed in > > https://dlcdn.apache.org/calcite/ > > Maybe the list will be updated later. > > Thanks again for your kind help. > > Best,

Re: [HELP][Release 1.30.0]

Hi Francis, Thanks a lot for your feedback. I can see it propagated too. However, it is not listed in https://dlcdn.apache.org/calcite/ Maybe the list will be updated later. Thanks again for your kind help. Best, Liya Fan Francis Chuang 于2022年3月19日周六 16:37写道： > Hi Liya, > >

Re: [HELP][Release 1.30.0]

Hi Liya, I can see that the release has propagated: https://dlcdn.apache.org/calcite/apache-calcite-1.30.0/ We do need to sign your key though, using a virtual key signing party so that your key is part of the web of trust. Francis On 19/03/2022 7:28 pm, Fan Liya wrote: Hi all, I am

Re: [HELP][Release 1.30.0]

Hi all, I am having another problem when trying to publish the release. After running the publishing command: ./gradlew publishDist -Prc=3 -Pasf It seemed to have finished successfully. However, the release was not propagated to the mirrors (it was supposed to be propagated almost immediately):

Re: [Help] UNION queries with one or more SELECTs containing a JOIN are significantly slower after 1.24

ou can log a JIRA along with the test case, so people can do the root cause analysis. Thanks, Haisheng Yuan On 2022/03/12 01:26:53 "Gramana, Zachary (GE Digital)" wrote: > Hello all! > > I would appreciate some help/guidance with troubleshooting a big

Re: [Help] UNION queries with one or more SELECTs containing a JOIN are significantly slower after 1.24

le test case? You can log a JIRA along > with the test case, so people can do the root cause analysis. > > Thanks, > Haisheng Yuan > > On 2022/03/12 01:26:53 "Gramana, Zachary (GE Digital)" wrote: > > Hello all! > > > > I would appreciate some help/guida

Re: [Help] UNION queries with one or more SELECTs containing a JOIN are significantly slower after 1.24

> > I would appreciate some help/guidance with troubleshooting a big performance > regression we saw on our UNION queries after updating our application from > 1.24 to 1.29. Many of the tables in the queries are wide (> 50 columns) so we > use a custom push-down Project class.

[Help] UNION queries with one or more SELECTs containing a JOIN are significantly slower after 1.24

Hello all! I would appreciate some help/guidance with troubleshooting a big performance regression we saw on our UNION queries after updating our application from 1.24 to 1.29. Many of the tables in the queries are wide (> 50 columns) so we use a custom push-down Project class. These cus

Re: [HELP][Release 1.30.0]

Hi Stamatis, Thanks a lot for your clarification and confirmation. Best, Liya Fan Stamatis Zampetakis 于2022年3月11日周五 21:39写道： > Hi Liya, > > The asf.git.pushRepositoryProvider property controls the git repository > that is used by the release plugin [1]. There are two options: > * GITBOX ->

Re: [HELP][Release 1.30.0]

Hi Liya, The asf.git.pushRepositoryProvider property controls the git repository that is used by the release plugin [1]. There are two options: * GITBOX -> https://gitbox.apache.org/repos/asf/calcite.git * GITHUB -> https://github.com/apache/calcite.git In the first attempt, you tried to push to

[HELP][Release 1.30.0]

Hi all, When preparing a release build, I ran the command according to the document [1]: *./gradlew prepareVote -Prc=2 -Pasf -Pasf.git.pushRepositoryProvider=GITBOX* Then I got the following error message: *Build calcite FAILURE reason:Execution failed for task ':pushRcTag': Caused

Re: [HELP][DISCUSS] ReduceExpressionsRule configurability / extensibility

Thanks Stamatis, I will take a look at those links. On Fri, Feb 18, 2022 at 9:41 PM Stamatis Zampetakis wrote: > Hi Ruben, > > There was a recent request about preventing simplifications of certain > operators [1] that does make sense in certain use cases. Apart from changes > in RexSimplify

Re: [HELP][DISCUSS] ReduceExpressionsRule configurability / extensibility

Hi Ruben, There was a recent request about preventing simplifications of certain operators [1] that does make sense in certain use cases. Apart from changes in RexSimplify this request would most likely need some kind of changes in various reduce expressions rules like the ones you seem to need

[HELP][DISCUSS] ReduceExpressionsRule configurability / extensibility

Hello community, I would need some advice for a very specific problem. I find myself in the following situation: I have a plan with a bottom filter (an equality) and a top filter (a user defined function MY_FUNC): ... LogicalFilter(condition: MY_FUNC($0, 42)) LogicalFilter(condition: $0=1)

Re: Help with SqlAdvisor and autocomplete please!

te: > > > > Hello, > > Please can I ask for some help or guidance with SqlAdvisor and completion? > > My problem is that I can get completion working for table names, but not > > column names. > > > > "select a.mgr from ^stuff a" > >

Re: Help with SqlAdvisor and autocomplete please!

ferent from these? > On Jan 20, 2022, at 2:40 AM, mark wrote: > > Hello, > Please can I ask for some help or guidance with SqlAdvisor and completion? > My problem is that I can get completion working for table names, but not > column names. > > "select a.mgr from ^

Help with SqlAdvisor and autocomplete please!

Hello, Please can I ask for some help or guidance with SqlAdvisor and completion? My problem is that I can get completion working for table names, but not column names. "select a.mgr from ^stuff a" gives me good results: CATALOG.SALES.EMP, CATALOG.SALES, etc, but "select a.^

Help with extending the Calcite grammar

Hi, I am relatively a newcomer to the Calcite project and was exploring ways to extend Calcite's grammar. I have gone through the provided test cases and some examples where the grammar is modified. I was facing difficulty in adding custom clauses to the end of a pre-existing grammar rule. In

Re: [GITHUB-HELP] The Committer how to merge a PR correctly

Thank you for your reply. It is very helpful to me about the procedure of how to merge the PR. Actually, I have tested in another git repository before. I want to find a "standard procedure" to guarantee What I do is the right procedure. I believe this email will help the new Com

Re: [GITHUB-HELP] The Committer how to merge a PR correctly

ations to be a committer of Calcite. > > I'm not a Calcite committer. However I could share the PR merge workflow > which I get from a PMC member of Apache Flink community. Maybe it could > help you. > > 1. get the PR in your local repository > --- > > git fetch pull/yy

Re: [GITHUB-HELP] The Committer how to merge a PR correctly

Hi Xiong, Congratulations to be a committer of Calcite. I'm not a Calcite committer. However I could share the PR merge workflow which I get from a PMC member of Apache Flink community. Maybe it could help you. 1. get the PR in your local repository --- > git fetch pull//head: x

Re: [GITHUB-HELP] The Committer how to merge a PR correctly

Did you search for an answer before posting this question? What did you find? > On Dec 2, 2021, at 5:24 PM, xiong duan wrote: > > Hi, PMC and Committers. As a newcomer, I have one problem want to know. > > Do we have a procedure about The Committer how to merge a PR correctly? > > Every time

[GITHUB-HELP] The Committer how to merge a PR correctly

Hi, PMC and Committers. As a newcomer, I have one problem want to know. Do we have a procedure about The Committer how to merge a PR correctly? Every time I merge the PR, I always worried whether have a wrong step. So If have the standard procedure, It will be very helpful.

help review PR (ugrade to Cassandra 4 - CALCITE-4768)

Hello everyone, if someone has spare cycles I'd appreciate some help merging this PR: https://github.com/apache/calcite/pull/2592 This is the associated ticket: https://issues.apache.org/jira/browse/CALCITE-4768 The PR adds Cassandra 4 support, and upgrades as well the DataStax driver we use

Re: Need help: exception when using Elasticsearch adapter

csearch/ElasticsearchTable in model json/yaml to parse the SQL > statement? I assumed Calcite can convert any supported SQL to Elasticsearch > DSL no matter what the Schema/Table specification of the SQL are. > > Thanks, > Justin > > From > Alessandro Solimando alessandro.so

RE: Need help: exception when using Elasticsearch adapter

...@gmail.com<mailto:alessandro.solima...@gmail.com> Subject Re: Need help: exception when using Elasticsearch adapter Date Thu, 30 Sep 2021 06:14:05 GMT Each adapter "speaks" the language of the supported data source, but only to the extent of querying it, and for the tables stored in it

Re: Need help: exception when using Elasticsearch adapter

rel#67:RelSubset#3.ELASTICSEARCH.[]",color=red] > } > root -> subset67; > subset64 -> rel60[color=blue]; > subset66 -> rel65[color=blue]; rel65 -> subset64[color=blue]; > subset67 -> rel68; rel68 -> subset66; > } >

RE: Need help: exception when using Elasticsearch adapter

[color=blue]; subset66 -> rel65[color=blue]; rel65 -> subset64[color=blue]; subset67 -> rel68; rel68 -> subset66; } Thanks, Jusitn From: Justin Huang Sent: Monday, September 27, 2021 1:56 PM To: dev@calcite.apache.org Subject: Need help: exception when using Elasticsear

Re:Need help: Optimization rule to reduce project-filter-project-filter on one table

`.In the RelNode, we can implement a `RelOptRule` to match the operator, and then remove the cast operator.you can refer `RelOptRules` in `org.apache.calcite.rel.rules.CoreRules`.In addition, you can use `RelShuttle` to rewrite RelNode, both of them can remove the `castoperator`. I hope it can help

Need help: Optimization rule to reduce project-filter-project-filter on one table

Hi Calcite developers, I just started learning Calcite, and tried Calcite optimization on a fake SQL as shown in below table. I see that generated Logical plan has interleaved Project-Filter-Project-Filter chain on one table. I need some help on 2 questions: 1. Does Calcite have any rule

Materialized View and Lattice Suggester help

Hi Calcite devs, Today our team deploys a Calcite service that uses Daily OLAP Cube tables and fine grain Fact tables. Daily OLAP Cube tables are used to vastly improve latency when querying for a wide date range but comes with a restriction – the date range *must* be UTC day granularity. When a

[dev] Need help with a query failing at validation.

Hi, I'm Nishchith I've been using calcite for quite some time, recently I was using it to for a query which ran successfully on snowflake but erred out at validation step with: *Query: *SELECT * FROM TABLE PIVOT(sum(X) FOR Y IN (v1, v2, v3)) AS P(a, b, c, d) *Error:

Re: [HELP] Calcite interpreting SQL to Druid DSL Question

some real Druid. There’s no error in the tutorial, sorry about the confusion. Will come back to this thread if we have any new findings. Thanks. Regards, Chi 发自我的iPhone > 在 2021年6月9日，下午11:31，Ben Krug 写道： > > Hi Xu - > > I think it should work the way you expect. It would help to

Re: [HELP] Return type of the SUM aggregate function and AggregateExpandDistinctAggregatesRule

Hi, I've filed the issue CALCITE-4652 (see [1]). Please take a look at the suggested fix [2]. [1]. https://issues.apache.org/jira/browse/CALCITE-4652 [2]. https://github.com/apache/calcite/pull/2439 On 04.06.2021 18:46, Taras Ledkov wrote: Hi, I try to expand return type of the SUM aggregate

Re: [HELP] Calcite interpreting SQL to Druid DSL Question

Hi Xu - I think it should work the way you expect. It would help to know the steps that you followed to set it up. When you say a tutorial, which one? Do you mean this - https://calcite.apache.org/docs/druid_adapter.html ? What steps did you take to set it up and run the query? Thank you, Ben

Re: [HELP] Calcite interpreting SQL to Druid DSL Question

Hi Ben, Thanks for your prompt response. I checked the data schema in Druid and found below definition which specify the timestamp column. If I query with “__time”, it will be the situation which mentioned in previous email. And I tried to query with the column name “at”, it shows there’s no

Re: [HELP] Calcite interpreting SQL to Druid DSL Question

I'm coming from the druid side, not a calcite person, but I wanted to ask. What tutorial do you mean? Did you specify a model, and did it specify timestampColumn? (If so, was it __time?) I notice that in the druid console, if you use your SQL, it translate correctly, as in your desired DSL, so

[HELP] Calcite interpreting SQL to Druid DSL Question

Hi team, I’m trying to integrate Druid with Calcite by using calcite-druid adapter. After following the tutorial, we could connect Calcite with Druid and fetching metadata back. But when trying to execute query with below SQL, the DSL generated by Calcite is translating the __time where clause

[HELP] Return type of the SUM aggregate function and AggregateExpandDistinctAggregatesRule

Hi, I try to expand return type of the SUM aggregate function like Postgress for my SQL engine based on Calcite framework. e.g.: SUM of INTEGER or BIGINT returns DECIMAL. Looks like the override the `RelDataTypeSystem#deriveSumType` is appropriate place for he change. Is it OK? Let's take

Re: [HELP] SqlParserImpl#jj_scan_token hangs?

Ruben, The next time the case reproduces, please collect the core dump. At least you would be able to analyze it later. It might be a VM issue (e.g. failing compilation), or it might be a concurrency issue (e.g. data race in the parser code), or something completely different. You might find

[HELP] SqlParserImpl#jj_scan_token hangs?

Hello, in a downstream project we have experienced a strange phenomenon around Calcite SQL parser. To sum up, while running (sequentially) several thousand times (around 20K) different instances of the "same" query (not sure if the query itself is relevant, but just in case I share how it looks

Re: [HELP] ExceptionInInitializerError caused by ImmutableBeans?

I have created https://issues.apache.org/jira/browse/CALCITE-4492 to address this issue. @Stamatis Zampetakis please note that, while the Flink error was observed with Java9, my error was observed with Java8 (on Websphere). On Tue, Feb 9, 2021 at 10:56 PM Stamatis Zampetakis wrote: >

Re: [HELP] ExceptionInInitializerError caused by ImmutableBeans?

Definitely worth logging/fixing but given that java9 is already EOL [1] I don't think there are going to be many people impacted by this. [1] https://www.oracle.com/java/technologies/java-se-support-roadmap.html On Tue, Feb 9, 2021 at 10:38 PM Julian Hyde wrote: > Can you please log it? Link

Re: [HELP] ExceptionInInitializerError caused by ImmutableBeans?

Can you please log it? Link it to https://issues.apache.org/jira/browse/CALCITE-4200 (if it’s not the same issue) and of course FLINK-19820. > On Feb 9, 2021, at 8:28 AM, Ruben Q L wrote: > > Hello everyone, > > While testing an

[HELP] ExceptionInInitializerError caused by ImmutableBeans?

Hello everyone, While testing an application that uses Calcite, I'm getting an error when I try to run it on a Websphere9 environment (IBM J9 VM, Java8, Ubuntu) [1]. It would seem there is an issue around org.apache.calcite.util.ImmutableBeans and the reflection mechanisms that it uses, in the

RE: Re: Re: Request help in implementing subquery in WHERE condition

Thanks Stamatis. The link you shared is really helpul. -Original Message- From: Stamatis Zampetakis Sent: Wednesday, January 27, 2021 2:33 AM To: dev@calcite.apache.org Subject: [EXTERNAL] Re: Re: Request help in implementing subquery in WHERE condition Hi Hrudaya, In the code you

Re: Re: Request help in implementing subquery in WHERE condition

deptno from dept where > emp.job = dept.name) > I am very new to calcite and still trying to understand how relbuilder > works. > I am not sure how to construct the relbuilder for the query in > https://issues.apache.org/jira/browse/CALCITE-1493 > I would appreciate any help with thi

RE: Re: Request help in implementing subquery in WHERE condition

help with this. Regards, Hrudaya -Original Message- From: Julian Hyde Sent: Tuesday, January 26, 2021 9:25 AM To: dev@calcite.apache.org Subject: [EXTERNAL] Re: Request help in implementing subquery in WHERE condition Yes; I usually only call build() once per RelBuilder program, and leave

RE: Re: Request help in implementing subquery in WHERE condition

am very new to calcite and still trying to understand how relbuilder works. I am not sure how to construct the relbuilder for the query in https://issues.apache.org/jira/browse/CALCITE-1493 I would appreciate any help with this. Regards, Hrudaya -Original Message- From: Stamatis Zampetakis

Re: Request help in implementing subquery in WHERE condition

uot;) >>.join(JoinRelType.LEFT, >> relBuilder.equals( >>relBuilder.field(2, "ja", "user_id"), >>relBuilder.field(2, "u", "user_id"))); >> >>relBuilder.project(relBuilder.field(&quo

  1   2   3   >