You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Roman Churganov (Jira)" <ji...@apache.org> on 2020/10/11 20:07:00 UTC
[jira] [Comment Edited] (CALCITE-4290) Not optimal subqueries due
to a "*" in them
[ https://issues.apache.org/jira/browse/CALCITE-4290?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17212027#comment-17212027 ]
Roman Churganov edited comment on CALCITE-4290 at 10/11/20, 8:06 PM:
---------------------------------------------------------------------
Have you got any basic description of concepts concerning entrails of the lib, aside from the user guide on the site and java-doc, I mean more in-depth stuff?
was (Author: rrrrrr111):
Have you got any basic description of concepts concerning entrails of the lib?
> Not optimal subqueries due to a "*" in them
> -------------------------------------------
>
> Key: CALCITE-4290
> URL: https://issues.apache.org/jira/browse/CALCITE-4290
> Project: Calcite
> Issue Type: Bug
> Components: jdbc-adapter
> Affects Versions: 1.25.0
> Reporter: Roman Churganov
> Priority: Major
>
> Run a query which should be distributed into sub-queries onto multiple schemas through JDBC adapter, for example
> select ft.id, ft.c11, tt.c41 from sch1.foo ft join sch2.tab tt on ft.id = tt.id
> Calcite will make two sub-queries like SELECT * FROM "TAB" ORDER BY "ID" and SELECT * FROM "FOO" ORDER BY "ID" which are not optimal due to an excessive columns data requested
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)