You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@calcite.apache.org by Julian Hyde <jh...@apache.org> on 2021/09/10 19:37:15 UTC
Tableau dialect specification for Calcite
Tableau has a text file [1] where you can define your dialect. It lets
Tableau know how to generate SQL to extract a year from a date, for
example.
Has anyone written that dialect specification for Calcite or a system
that uses Calcite's SQL parser (such as Druid, Phoenix)? Since those
systems have similar dialects, it would be good to pool resources
here.
Julian
[1] https://tableau.github.io/connector-plugin-sdk/docs/dialect
Re: Tableau dialect specification for Calcite
Posted by Laurent Goujon <la...@dremio.com>.
We will get back to you guys!
Laurent
On Mon, Sep 20, 2021 at 4:55 PM Julian Hyde <jh...@gmail.com> wrote:
> Looks very promising, and has the .tdd file that I was looking for. Thanks
> Jacques.
>
> That said, there is no LICENSE file. I will file an issue to clarify the
> license.
>
> Julian
>
>
>
> > On Sep 20, 2021, at 1:04 PM, Jacques Nadeau <ja...@apache.org> wrote:
> >
> > I wonder if the Dremio connector would be a good place to start since it
> > uses Calcite:
> >
> > https://github.com/dremio-hub/tableau-connector
> >
> >
> > On Fri, Sep 10, 2021 at 12:37 PM Julian Hyde <jh...@apache.org> wrote:
> >
> >> Tableau has a text file [1] where you can define your dialect. It lets
> >> Tableau know how to generate SQL to extract a year from a date, for
> >> example.
> >>
> >> Has anyone written that dialect specification for Calcite or a system
> >> that uses Calcite's SQL parser (such as Druid, Phoenix)? Since those
> >> systems have similar dialects, it would be good to pool resources
> >> here.
> >>
> >> Julian
> >>
> >> [1] https://tableau.github.io/connector-plugin-sdk/docs/dialect
> >>
>
>
Re: Tableau dialect specification for Calcite
Posted by Julian Hyde <jh...@gmail.com>.
Looks very promising, and has the .tdd file that I was looking for. Thanks Jacques.
That said, there is no LICENSE file. I will file an issue to clarify the license.
Julian
> On Sep 20, 2021, at 1:04 PM, Jacques Nadeau <ja...@apache.org> wrote:
>
> I wonder if the Dremio connector would be a good place to start since it
> uses Calcite:
>
> https://github.com/dremio-hub/tableau-connector
>
>
> On Fri, Sep 10, 2021 at 12:37 PM Julian Hyde <jh...@apache.org> wrote:
>
>> Tableau has a text file [1] where you can define your dialect. It lets
>> Tableau know how to generate SQL to extract a year from a date, for
>> example.
>>
>> Has anyone written that dialect specification for Calcite or a system
>> that uses Calcite's SQL parser (such as Druid, Phoenix)? Since those
>> systems have similar dialects, it would be good to pool resources
>> here.
>>
>> Julian
>>
>> [1] https://tableau.github.io/connector-plugin-sdk/docs/dialect
>>
Re: Tableau dialect specification for Calcite
Posted by Jacques Nadeau <ja...@apache.org>.
I wonder if the Dremio connector would be a good place to start since it
uses Calcite:
https://github.com/dremio-hub/tableau-connector
On Fri, Sep 10, 2021 at 12:37 PM Julian Hyde <jh...@apache.org> wrote:
> Tableau has a text file [1] where you can define your dialect. It lets
> Tableau know how to generate SQL to extract a year from a date, for
> example.
>
> Has anyone written that dialect specification for Calcite or a system
> that uses Calcite's SQL parser (such as Druid, Phoenix)? Since those
> systems have similar dialects, it would be good to pool resources
> here.
>
> Julian
>
> [1] https://tableau.github.io/connector-plugin-sdk/docs/dialect
>