[
https://issues.apache.org/jira/browse/SOLR-8593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15702457#comment-15702457
]
Julian Hyde commented on SOLR-8593:
---
Calcite rewrites {{SELECT DISTINCT ...}} to {{SELECT ... GROUP BY
[
https://issues.apache.org/jira/browse/SOLR-8593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15700714#comment-15700714
]
Cao Manh Dat commented on SOLR-8593:
What I mean about "run this filter faster than Calcite" is, Solr
[
https://issues.apache.org/jira/browse/SOLR-8593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15700686#comment-15700686
]
Joel Bernstein commented on SOLR-8593:
--
Hi [~risdenk] and [~caomanhdat]. I've reviewed the latest work
[
https://issues.apache.org/jira/browse/SOLR-8593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15664701#comment-15664701
]
Julian Hyde commented on SOLR-8593:
---
CALCITE-1306 covers this. It's not standard SQL but could be enabled
[
https://issues.apache.org/jira/browse/SOLR-8593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15664613#comment-15664613
]
Cao Manh Dat commented on SOLR-8593:
But we wanna to handle having clause without the function like
[
https://issues.apache.org/jira/browse/SOLR-8593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15664595#comment-15664595
]
Julian Hyde commented on SOLR-8593:
---
You're making a mistake I see a lot of people making: trying to do
[
https://issues.apache.org/jira/browse/SOLR-8593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15664576#comment-15664576
]
Julian Hyde commented on SOLR-8593:
---
Regarding the alias for "count(*)". I guess one approach is to
[
https://issues.apache.org/jira/browse/SOLR-8593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15664525#comment-15664525
]
Cao Manh Dat commented on SOLR-8593:
Thanks [~risdenk],
Yeah, I will definitely do that in the
[
https://issues.apache.org/jira/browse/SOLR-8593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15664433#comment-15664433
]
Kevin Risden commented on SOLR-8593:
[~caomanhdat] - I merged your changes with the jira/solr-8593
[
https://issues.apache.org/jira/browse/SOLR-8593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15662327#comment-15662327
]
Cao Manh Dat commented on SOLR-8593:
Thanks [~julianhyde], that make sense, but will Calcite have an
[
https://issues.apache.org/jira/browse/SOLR-8593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15662280#comment-15662280
]
Julian Hyde commented on SOLR-8593:
---
"count(\*)" is not a good derived column name, because it contains
[
https://issues.apache.org/jira/browse/SOLR-8593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15661016#comment-15661016
]
Cao Manh Dat commented on SOLR-8593:
Thanks [~risdenk]
[~julianhyde] BTW: How can we get rid of EXPR$1
[
https://issues.apache.org/jira/browse/SOLR-8593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15659950#comment-15659950
]
Kevin Risden commented on SOLR-8593:
Thanks [~caomanhdat]! I'll integrate the fixes into the
[
https://issues.apache.org/jira/browse/SOLR-8593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15658025#comment-15658025
]
Julian Hyde commented on SOLR-8593:
---
By the way, when you're ready, add please Solr to the [powered
[
https://issues.apache.org/jira/browse/SOLR-8593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15652093#comment-15652093
]
Joel Bernstein commented on SOLR-8593:
--
Very excited about this patch. After a day of review I think
[
https://issues.apache.org/jira/browse/SOLR-8593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15625888#comment-15625888
]
ASF GitHub Bot commented on SOLR-8593:
--
Github user risdenk commented on a diff in the pull request:
[
https://issues.apache.org/jira/browse/SOLR-8593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15622553#comment-15622553
]
ASF GitHub Bot commented on SOLR-8593:
--
Github user risdenk commented on the issue:
[
https://issues.apache.org/jira/browse/SOLR-8593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15622328#comment-15622328
]
Kevin Risden commented on SOLR-8593:
Avatica 1.9 (and Calcite 1.11) is because this needs avatica-core
[
https://issues.apache.org/jira/browse/SOLR-8593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15616986#comment-15616986
]
Julian Hyde commented on SOLR-8593:
---
Ah, I think I see what's going on. You're using avatica-1.9-SNAPSHOT
[
https://issues.apache.org/jira/browse/SOLR-8593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15616963#comment-15616963
]
Julian Hyde commented on SOLR-8593:
---
Is there a Calcite issue logged for the AbstractMethodError relating
[
https://issues.apache.org/jira/browse/SOLR-8593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15616458#comment-15616458
]
Yonik Seeley commented on SOLR-8593:
bq. (This should include joins)
Awesome! I know many who have
[
https://issues.apache.org/jira/browse/SOLR-8593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15616318#comment-15616318
]
Kevin Risden commented on SOLR-8593:
One thing that you may have to do to make the Solr server happy
[
https://issues.apache.org/jira/browse/SOLR-8593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15616304#comment-15616304
]
Joel Bernstein commented on SOLR-8593:
--
[~risdenk], I'll pull the branch and begin working with it. My
[
https://issues.apache.org/jira/browse/SOLR-8593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15616284#comment-15616284
]
ASF GitHub Bot commented on SOLR-8593:
--
Github user joel-bernstein commented on the issue:
[
https://issues.apache.org/jira/browse/SOLR-8593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15513607#comment-15513607
]
Kevin Risden commented on SOLR-8593:
Adding some resources that may be helpful:
*
[
https://issues.apache.org/jira/browse/SOLR-8593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15378775#comment-15378775
]
Joel Bernstein commented on SOLR-8593:
--
Ah, I see. I think we can pull off CoGroup with a merge() and
[
https://issues.apache.org/jira/browse/SOLR-8593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15378687#comment-15378687
]
Julian Hyde commented on SOLR-8593:
---
The trickiest thing about CoGroup is that it aggregates (i.e. groups
[
https://issues.apache.org/jira/browse/SOLR-8593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15378665#comment-15378665
]
Joel Bernstein commented on SOLR-8593:
--
The CoGroup operator is interesting. Solr's Streaming
[
https://issues.apache.org/jira/browse/SOLR-8593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15376266#comment-15376266
]
Julian Hyde commented on SOLR-8593:
---
You should probably model your join and aggregate operators as
[
https://issues.apache.org/jira/browse/SOLR-8593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15372906#comment-15372906
]
Joel Bernstein commented on SOLR-8593:
--
Hi Julian!
Thanks for the offer to help out. [~risdenk] and I
[
https://issues.apache.org/jira/browse/SOLR-8593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15371912#comment-15371912
]
Julian Hyde commented on SOLR-8593:
---
Hi everyone! I'm VP of Apache Calcite. I only just noticed this JIRA
[
https://issues.apache.org/jira/browse/SOLR-8593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15301871#comment-15301871
]
Joel Bernstein commented on SOLR-8593:
--
Interesting. I'd like to spend some time in the next couple
[
https://issues.apache.org/jira/browse/SOLR-8593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15296678#comment-15296678
]
Kevin Risden commented on SOLR-8593:
[~joel.bernstein] - Elasticsearch with Calcite just came through
[
https://issues.apache.org/jira/browse/SOLR-8593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15276494#comment-15276494
]
Joel Bernstein commented on SOLR-8593:
--
Ok, I'll keep digging into the rules to get a better
[
https://issues.apache.org/jira/browse/SOLR-8593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15276480#comment-15276480
]
Kevin Risden commented on SOLR-8593:
Here is a blog post about the concepts and example rules:
[
https://issues.apache.org/jira/browse/SOLR-8593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15276476#comment-15276476
]
Joel Bernstein commented on SOLR-8593:
--
I think my main concern is that the join pushdown rules
[
https://issues.apache.org/jira/browse/SOLR-8593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15276472#comment-15276472
]
Joel Bernstein commented on SOLR-8593:
--
Are you concerned that there isn't a reference implementation
[
https://issues.apache.org/jira/browse/SOLR-8593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15276452#comment-15276452
]
Kevin Risden commented on SOLR-8593:
{quote}
Do you know of an existing adapter that does join push
[
https://issues.apache.org/jira/browse/SOLR-8593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15276420#comment-15276420
]
Joel Bernstein commented on SOLR-8593:
--
[~risdenk], I've been reviewing the work on
[
https://issues.apache.org/jira/browse/SOLR-8593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15264057#comment-15264057
]
Joel Bernstein commented on SOLR-8593:
--
This is awesome.
I like the idea of making this a 6.2
[
https://issues.apache.org/jira/browse/SOLR-8593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15264031#comment-15264031
]
Kevin Risden commented on SOLR-8593:
Currently this is working out really nicely. Need to address the
[
https://issues.apache.org/jira/browse/SOLR-8593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15262895#comment-15262895
]
Kevin Risden commented on SOLR-8593:
Ok made a bunch of progress on the jira/solr-8593 branch:
*
[
https://issues.apache.org/jira/browse/SOLR-8593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15262361#comment-15262361
]
Kevin Risden commented on SOLR-8593:
Pushed initial version to branch jira/solr-8593. Currently there
[
https://issues.apache.org/jira/browse/SOLR-8593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15208885#comment-15208885
]
Joel Bernstein commented on SOLR-8593:
--
Yeah this was done originally because Presto didn't support
[
https://issues.apache.org/jira/browse/SOLR-8593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15208874#comment-15208874
]
Kevin Risden commented on SOLR-8593:
Another thing I learned from looking closely at the TestSQLHandler
[
https://issues.apache.org/jira/browse/SOLR-8593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15208777#comment-15208777
]
Kevin Risden commented on SOLR-8593:
For reference the class that is querying with a stream is here:
[
https://issues.apache.org/jira/browse/SOLR-8593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15208413#comment-15208413
]
Kevin Risden commented on SOLR-8593:
One way to access Calcite is through JDBC. The JDBCStream is
[
https://issues.apache.org/jira/browse/SOLR-8593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15208409#comment-15208409
]
Dennis Gove commented on SOLR-8593:
---
Ok, I see that. So the JDBCStream is being used as the bridge
[
https://issues.apache.org/jira/browse/SOLR-8593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15208336#comment-15208336
]
Kevin Risden commented on SOLR-8593:
I think we can. I will look into it today and see how far I get
[
https://issues.apache.org/jira/browse/SOLR-8593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15208335#comment-15208335
]
Kevin Risden commented on SOLR-8593:
I think my statement was misleading. I think the issue is the
[
https://issues.apache.org/jira/browse/SOLR-8593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15208325#comment-15208325
]
Kevin Risden commented on SOLR-8593:
The diff is misleading since SQLHandler is not shown due to having
[
https://issues.apache.org/jira/browse/SOLR-8593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15207685#comment-15207685
]
Joel Bernstein commented on SOLR-8593:
--
Currently quoted identifiers do refer to columns. This was
[
https://issues.apache.org/jira/browse/SOLR-8593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15207593#comment-15207593
]
Joel Bernstein commented on SOLR-8593:
--
I looked through the code and I'm seeing how CloudSolrStream
[
https://issues.apache.org/jira/browse/SOLR-8593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15207416#comment-15207416
]
Dennis Gove commented on SOLR-8593:
---
[~risdenk], I think I must be missing something in the diff link but
[
https://issues.apache.org/jira/browse/SOLR-8593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15207350#comment-15207350
]
Kevin Risden commented on SOLR-8593:
[~joel.bernstein] I was able to make some really good progress on
[
https://issues.apache.org/jira/browse/SOLR-8593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15206919#comment-15206919
]
Kevin Risden commented on SOLR-8593:
Here is a separate approach that uses all of Calcite and the
[
https://issues.apache.org/jira/browse/SOLR-8593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15206730#comment-15206730
]
Joel Bernstein commented on SOLR-8593:
--
[~risdenk] and I have been looking into different approaches
[
https://issues.apache.org/jira/browse/SOLR-8593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15204988#comment-15204988
]
Joel Bernstein commented on SOLR-8593:
--
It's still worth looking into. But I suspect Calcite has to
[
https://issues.apache.org/jira/browse/SOLR-8593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15204951#comment-15204951
]
Kevin Risden commented on SOLR-8593:
{quote}
But I get worried that we'll be roped into how Calcite
[
https://issues.apache.org/jira/browse/SOLR-8593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15204946#comment-15204946
]
Joel Bernstein commented on SOLR-8593:
--
If wrapping this logic up inside a Calcite adapter makes
[
https://issues.apache.org/jira/browse/SOLR-8593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15204891#comment-15204891
]
Kevin Risden commented on SOLR-8593:
[~joel.bernstein] - I took a much closer look at Calcite and the
[
https://issues.apache.org/jira/browse/SOLR-8593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15200020#comment-15200020
]
Kevin Risden commented on SOLR-8593:
Speaking of Calcite and JDBC -
[
https://issues.apache.org/jira/browse/SOLR-8593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15199661#comment-15199661
]
Joel Bernstein commented on SOLR-8593:
--
SOLR-7560 has a patch that uses Apache Calcite rather then
[
https://issues.apache.org/jira/browse/SOLR-8593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15115253#comment-15115253
]
Joel Bernstein commented on SOLR-8593:
--
Linking to the JDBC driver work. The JDBC driver and the
101 - 164 of 164 matches
Mail list logo