Ziwei Liu created CALCITE-4432:
--
Summary: When the RelNode's input is the same subset as the subset
node belonged to, not choose this node as best.
Key: CALCITE-4432
URL:
GROUPING_ID is problematic for both optimizers and humans, because if the
columns are permuted the value changes, and that causes problems. I think
GROUPING is working well for our purposes.
Of course you can use whichever you like in your queries.
Julian
> On Dec 8, 2020, at 19:00, JiaTao
Try adding —no-build-cache to gradle’s command line. It worked for me. I guess
a bad .class file had gotten lodged in gradle’s cache.
Julian
> On Dec 8, 2020, at 20:20, Chunwei Lei wrote:
>
> I have tried jdk1.8.0_271. But I still get the error.
>
>> Task :plus:forbiddenApisMain FAILED
>
I have tried jdk1.8.0_271. But I still get the error.
> Task :plus:forbiddenApisMain FAILED
> Task :release:distTar
Source distribution is created:
/Users/chunwei.lcw/Desktop/dev_src/calcite/release/build/distributions/apache-calcite-1.27.0-SNAPSHOT-src.tar.gz
Build calcite FAILURE reason:
Hi Julian
I see, thanks, maybe use grouping id is better? Cuz seems not every engine
has this grouping behavior, in the doc of oracle[ref1]:
The expr in the GROUPING function must match one of the expressions in the
GROUP BY clause. The function returns a value of 1 if the value of expr in
the
method *visitRoot* work well.Ichange my code to :
RelToSqlConverter converter = new
RelToSqlConverter(PostgresqlSqlDialect.DEFAULT);
SqlSelect select = converter.visitRoot(project1).asSelect();
fixed the problem.
Thank you again!
On 12/8/20 4:09 PM, tonytao wrote:
Tkansks,I
GROUPING is defined in the SQL standard. If it has N arguments, it
returns an integer bitmask with N bits.
PostgreSQL has the same behavior: see example in
https://www.postgresql.org/docs/9.5/functions-aggregate.html.
Julian
On Tue, Dec 8, 2020 at 12:30 AM JiaTao Tao wrote:
>
> Hi
> After
I just hit the same problem. I upgraded from jdk1.8.0_152 to
jdk1.8.0_271, restarted all gradle daemons, and the problem does not
go away.
Execution failed for task ':plus:forbiddenApisMain':
Caused by: de.thetaphi.forbiddenapis.ForbiddenApiException:
Failed to parse class
Default ??String representation is apostrophe in calcite SQL
??like 'word' . how do I set this to Double
quotes ??like "word" .
Default is : select * from table1 where column1 = 'word'
I hope to support?? select * from table1 where column1 = "word"
Vladimir Sitnikov created CALCITE-4431:
--
Summary: Use requireNonNull(var, "var") instead of
requireNonNull(var) for better error messages
Key: CALCITE-4431
URL:
Hi
After AggregateExpandDistinctAggregatesRule, I got a plan like this:
The $10 in the project node is $g=[GROUPING($0, $1, $2, $3, $4, $5, $6,
$7, $8)]) and we can see it is compared with value 1/2/3, but I check the
def of grouping(), both pg and oracle, the value of grouping is 0 or 1.
Tkansks,I created a jira:https://issues.apache.org/jira/browse/CALCITE-4430
On 12/8/20 2:50 PM, Chunwei Lei wrote:
Hi, Tao.
Thank you for your report. It would be great if you can file an JIRA and
provide
a test case that can reproduce the error.
Best,
Chunwei
On Tue, Dec 8, 2020 at 2:33 PM
TaoJIn created CALCITE-4430:
---
Summary: RelToSqlConverter stack error
Key: CALCITE-4430
URL: https://issues.apache.org/jira/browse/CALCITE-4430
Project: Calcite
Issue Type: Bug
13 matches
Mail list logo