Re: [DISCUSS] Apache Calcite Online Meetup January 2021

this is a great idea thanks @Statmatis looking forward to learning more about Calcite especially the Streaming work. On Mon, Nov 23, 2020 at 2:19 PM Rui Wang wrote: > Sorry for the late reply Statmatis. I have recently been pretty busy on > work as it is approaching the end of the year. > > The

Re: A question regarding querying Google Cloud BigTable or Spanner through Apache Calcite

H Jason, Calcite is a great Logical optimizer Framework that can be used to do very sophisticated data federation and query rewriting. But I don't think you want to use Calcite as it is to perform the physical join between 2 big data systems. To put it simply If you are using Calcite you need to

Re: Nested data handling in Caclite

s well, originally > > the RelStructuredTypeFlattener was designed to extract nested fields so > > that the work like de-correlation is much easier, but it also makes the > > plan changed and hard to maintain, it is not updated frequently, if > > possible, close the

Re: Nested data handling in Caclite

SqlToRelConverterTest#testAliasUnnestArrayPlanWithSingleColumn > for an example, you should make every record type with > StructKind.PEEK_FIELDS, so that nested record type can be also accessed > with DOT. > > > > > > > > Best, > > > > Danny Chan > > > &

Re: Nested data handling in Caclite

record type with StructKind.PEEK_FIELDS, so > that nested record type can be also accessed with DOT. > > Best, > Danny Chan > 在 2020年6月16日 +0800 PM12:50，Slim Bouguerra ，写道： > > Hi Danny, > > Thanks for the suggestion, but that did not solve the problem, still > > ge

Re: Nested data handling in Caclite

you create a structure type, you should choose > StructKind.PEEK_FIELDS instead, which let you to access the nested fields > with DOT, i.e. “a.b.c”. > > Best, > Danny Chan > 在 2020年6月16日 +0800 AM4:21，Slim Bouguerra ，写道： > > I am using this thread since the question seems r

Re: Nested data handling in Caclite

I am using this thread since the question seems related. As of now I can not say a way to project a nested record (FYI scalar works). https://jira.apache.org/jira/browse/CALCITE-4065 @Igor any idea if this can be done without major work on the SqlRelToRelConverter ? Also I am thinking about

[jira] [Created] (CALCITE-4065) Projecting a nested Row fails with org.apache.calcite.util.Util.needToImplement

Slim Bouguerra created CALCITE-4065: --- Summary: Projecting a nested Row fails with org.apache.calcite.util.Util.needToImplement Key: CALCITE-4065 URL: https://issues.apache.org/jira/browse/CALCITE-4065

Re: [DISCUSS] Where do we draw the line?

I totally agree that such review comments are kind of on the edge and can be seen as shaming and bullying. As a person whom lived over 3 different continent and worked with peoples from various culture, i find out (the hard way) that humor is always subjective to culture and context

[jira] [Created] (CALCITE-2358) Use null literal instead of empty string as argument for timestamp_parse Druid expression

slim bouguerra created CALCITE-2358: --- Summary: Use null literal instead of empty string as argument for timestamp_parse Druid expression Key: CALCITE-2358 URL: https://issues.apache.org/jira/browse/CALCITE-2358

[jira] [Created] (CALCITE-2262) Allow count(*) to be pushed with other aggregators to Druid Storage Handler.

slim bouguerra created CALCITE-2262: --- Summary: Allow count(*) to be pushed with other aggregators to Druid Storage Handler. Key: CALCITE-2262 URL: https://issues.apache.org/jira/browse/CALCITE-2262

[jira] [Created] (CALCITE-2236) Avoid duplications of fields names during Druid query planing

slim bouguerra created CALCITE-2236: --- Summary: Avoid duplications of fields names during Druid query planing Key: CALCITE-2236 URL: https://issues.apache.org/jira/browse/CALCITE-2236 Project

[jira] [Created] (CALCITE-2226) Substring operator converter doesn't handle non-constant literals

slim bouguerra created CALCITE-2226: --- Summary: Substring operator converter doesn't handle non-constant literals Key: CALCITE-2226 URL: https://issues.apache.org/jira/browse/CALCITE-2226 Project

[jira] [Created] (CALCITE-2222) Add Quarter as part of valid floor units to push down to Druid.

slim bouguerra created CALCITE-: --- Summary: Add Quarter as part of valid floor units to push down to Druid. Key: CALCITE- URL: https://issues.apache.org/jira/browse/CALCITE- Project

[jira] [Created] (CALCITE-2191) Drop support for Guava versions earlier than 19

slim bouguerra created CALCITE-2191: --- Summary: Drop support for Guava versions earlier than 19 Key: CALCITE-2191 URL: https://issues.apache.org/jira/browse/CALCITE-2191 Project: Calcite

[jira] [Created] (CALCITE-2175) Revisit the assumption made by druid calcite adapter that there is only one timestamp column

slim bouguerra created CALCITE-2175: --- Summary: Revisit the assumption made by druid calcite adapter that there is only one timestamp column Key: CALCITE-2175 URL: https://issues.apache.org/jira/browse/CALCITE

[jira] [Created] (CALCITE-2170) Use Druid Expressions capabilities to improve the amount of work that can be pushed to Druid

slim bouguerra created CALCITE-2170: --- Summary: Use Druid Expressions capabilities to improve the amount of work that can be pushed to Druid Key: CALCITE-2170 URL: https://issues.apache.org/jira/browse/CALCITE

Re: [ANNOUNCE] New committer: Nishant Bangarwa

congrats Nishant! On Wed, Jan 24, 2018 at 12:37 PM, Julian Hyde wrote: > Apache Calcite's Project Management Committee (PMC) has invited Nishant > Bangarwa to become a committer, and we are pleased to announce that he has > accepted. > > Nishant has been contributing to

[jira] [Created] (CALCITE-2123) Bug in the Druid Filter Translation when Comparing String Ref to a Constant Number

slim bouguerra created CALCITE-2123: --- Summary: Bug in the Druid Filter Translation when Comparing String Ref to a Constant Number Key: CALCITE-2123 URL: https://issues.apache.org/jira/browse/CALCITE-2123

[jira] [Created] (CALCITE-2122) Continuum of DateRangeRules issues.

slim bouguerra created CALCITE-2122: --- Summary: Continuum of DateRangeRules issues. Key: CALCITE-2122 URL: https://issues.apache.org/jira/browse/CALCITE-2122 Project: Calcite Issue Type

[jira] [Created] (CALCITE-2121) CAST timestamp with time zone to SQL VARCHAR

slim bouguerra created CALCITE-2121: --- Summary: CAST timestamp with time zone to SQL VARCHAR Key: CALCITE-2121 URL: https://issues.apache.org/jira/browse/CALCITE-2121 Project: Calcite Issue

[jira] [Created] (CALCITE-2119) Druid Filter validation Logic broken for filters like column_A = column_B

slim bouguerra created CALCITE-2119: --- Summary: Druid Filter validation Logic broken for filters like column_A = column_B Key: CALCITE-2119 URL: https://issues.apache.org/jira/browse/CALCITE-2119

[jira] [Created] (CALCITE-2097) Push aggregation and filters over metrics to Druid Query scan.

slim bouguerra created CALCITE-2097: --- Summary: Push aggregation and filters over metrics to Druid Query scan. Key: CALCITE-2097 URL: https://issues.apache.org/jira/browse/CALCITE-2097 Project

[jira] [Created] (CALCITE-2096) Remove extra dummy_aggregator for druid adapter

slim bouguerra created CALCITE-2096: --- Summary: Remove extra dummy_aggregator for druid adapter Key: CALCITE-2096 URL: https://issues.apache.org/jira/browse/CALCITE-2096 Project: Calcite

[jira] [Created] (CALCITE-2095) Push always_true and always_false to Druid as Expression Filter.

slim bouguerra created CALCITE-2095: --- Summary: Push always_true and always_false to Druid as Expression Filter. Key: CALCITE-2095 URL: https://issues.apache.org/jira/browse/CALCITE-2095 Project

[jira] [Created] (CALCITE-2094) Druid Count(*) return null instead of 0 when filter does not match rows.

slim bouguerra created CALCITE-2094: --- Summary: Druid Count(*) return null instead of 0 when filter does not match rows. Key: CALCITE-2094 URL: https://issues.apache.org/jira/browse/CALCITE-2094

[jira] [Created] (CALCITE-2041) Adding the ability to turn off nullability matching for ReduceExpressionsRule

slim bouguerra created CALCITE-2041: --- Summary: Adding the ability to turn off nullability matching for ReduceExpressionsRule Key: CALCITE-2041 URL: https://issues.apache.org/jira/browse/CALCITE-2041

[jira] [Created] (CALCITE-2019) Push count over druid column as count *

slim bouguerra created CALCITE-2019: --- Summary: Push count over druid column as count * Key: CALCITE-2019 URL: https://issues.apache.org/jira/browse/CALCITE-2019 Project: Calcite Issue Type

Re: Setting up remote JDBC Calcite Against Druid

have you looked at this ? https://hortonworks.com/blog/connect-tableau-druid-hive/ Also druid as a built in SQL layer starting from druid 0.10.0 thus you can use it to connect tableau as well

Re: Thoughts about providing port to connect other SQL interface

Thought superset has a native support to connect to druid and use druid’s physical language rather than SQL -- B-Slim ___/\/\/\___/\/\/\___/\/\/\___/\/\/\___/\/\/\___ > On Jun 13, 2017, at 12:19 PM, Junxian Wu wrote: > > Hi, Dev

[jira] [Created] (CALCITE-1770) Filters with Null fail with NPE

slim bouguerra created CALCITE-1770: --- Summary: Filters with Null fail with NPE Key: CALCITE-1770 URL: https://issues.apache.org/jira/browse/CALCITE-1770 Project: Calcite Issue Type: Bug

[jira] [Created] (CALCITE-1769) Push Filters down to druid when there a cast to numeric

slim bouguerra created CALCITE-1769: --- Summary: Push Filters down to druid when there a cast to numeric Key: CALCITE-1769 URL: https://issues.apache.org/jira/browse/CALCITE-1769 Project: Calcite

[jira] [Created] (CALCITE-1765) Druid adapter fail when the extract granularity is not supported

slim bouguerra created CALCITE-1765: --- Summary: Druid adapter fail when the extract granularity is not supported Key: CALCITE-1765 URL: https://issues.apache.org/jira/browse/CALCITE-1765 Project

[jira] [Created] (CALCITE-1758) Push down to druid the order by limit operator

slim bouguerra created CALCITE-1758: --- Summary: Push down to druid the order by limit operator Key: CALCITE-1758 URL: https://issues.apache.org/jira/browse/CALCITE-1758 Project: Calcite

[jira] [Created] (CALCITE-1725) Push Extraction function aggragation to druid.

slim bouguerra created CALCITE-1725: --- Summary: Push Extraction function aggragation to druid. Key: CALCITE-1725 URL: https://issues.apache.org/jira/browse/CALCITE-1725 Project: Calcite

[jira] [Created] (CALCITE-1722) Lose of double precision on Filters.

slim bouguerra created CALCITE-1722: --- Summary: Lose of double precision on Filters. Key: CALCITE-1722 URL: https://issues.apache.org/jira/browse/CALCITE-1722 Project: Calcite Issue Type

[jira] [Created] (CALCITE-1714) Do not push group by on druid metrics fields

slim bouguerra created CALCITE-1714: --- Summary: Do not push group by on druid metrics fields Key: CALCITE-1714 URL: https://issues.apache.org/jira/browse/CALCITE-1714 Project: Calcite Issue

[jira] [Created] (CALCITE-1707) Push Extract on Year/Month/Day to druid

slim bouguerra created CALCITE-1707: --- Summary: Push Extract on Year/Month/Day to druid Key: CALCITE-1707 URL: https://issues.apache.org/jira/browse/CALCITE-1707 Project: Calcite Issue Type

[jira] [Created] (CALCITE-1655) Add In filter to druid adapter.

slim bouguerra created CALCITE-1655: --- Summary: Add In filter to druid adapter. Key: CALCITE-1655 URL: https://issues.apache.org/jira/browse/CALCITE-1655 Project: Calcite Issue Type: Bug