You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@calcite.apache.org by Ricardo Peres <ri...@collibra.com.INVALID> on 2021/11/22 11:01:19 UTC

Support for more data types

Hi all,

Our team is currently looking into Avatica to solve a specific use case we
have.
In our use case, we don't have control/knowledge of the schema, any data
type can be returned. After some testing and checking the source code, we
noticed that some data types are currently not supported, for instance the
SQLXML data type.
We understand that some data types like BLOB and SQLXML are not
trivial/recommended to be sent via JSON/Protobuf over HTTP so, we would
like to know if there are plans to support these/more data types or if
there are any constraints that prevent the support to be implemented at all.

Kind regards.

Ricardo Peres.

Re: Support for more data types

Posted by Ricardo Peres <ri...@collibra.com.INVALID>.
Hi Julian,

Thanks for your reply.
We will create a ticket and start working on supporting SQLXML type for now,
this should allow us to familiarise with the source code and potentially
work
on other not supported standard data types in the future.

Kind regards.

Ricardo Peres.

On Mon, 22 Nov 2021 at 22:49, Julian Hyde <jh...@apache.org> wrote:

> Riccardo, There is no technical reason for Avatica to not support those
> data types. If someone contributed support for those data types (or any
> other standard data types), we would gladly accept. Juli
> *Caution*: External (jhyde@apache.org)
> First-Time Sender   Details
> <https://protection.inkyphishfence.com/details?id=Y29sbGlicmEvcmljYXJkby5wZXJlc0Bjb2xsaWJyYS5jb20vNTU4MmNhYTE0NjZiZjFmZGE3YTIzNzkxYmQ0ZTEyZWIvMTYzNzYyMTM3Ni42NQ==#key=0461ab3e3855a8d45d2dbfa07092cba3>
>   Report This Email
> <https://protection.inkyphishfence.com/report?id=Y29sbGlicmEvcmljYXJkby5wZXJlc0Bjb2xsaWJyYS5jb20vNTU4MmNhYTE0NjZiZjFmZGE3YTIzNzkxYmQ0ZTEyZWIvMTYzNzYyMTM3Ni42NQ==#key=0461ab3e3855a8d45d2dbfa07092cba3>
>  FAQ <https://www.inky.com/banner-faq/>  Protection by INKY
> <https://www.inky.com>
>
> Riccardo,
>
>
>
> There is no technical reason for Avatica to not support those data
>
> types. If someone contributed support for those data types (or any
>
> other standard data types), we would gladly accept.
>
>
>
> Julian
>
>
>
> On Mon, Nov 22, 2021 at 3:01 AM Ricardo Peres
>
> <ri...@collibra.com.invalid> wrote:
>
> >
>
> > Hi all,
>
> >
>
> > Our team is currently looking into Avatica to solve a specific use case
> we
>
> > have.
>
> > In our use case, we don't have control/knowledge of the schema, any data
>
> > type can be returned. After some testing and checking the source code, we
>
> > noticed that some data types are currently not supported, for instance
> the
>
> > SQLXML data type.
>
> > We understand that some data types like BLOB and SQLXML are not
>
> > trivial/recommended to be sent via JSON/Protobuf over HTTP so, we would
>
> > like to know if there are plans to support these/more data types or if
>
> > there are any constraints that prevent the support to be implemented at
> all.
>
> >
>
> > Kind regards.
>
> >
>
> > Ricardo Peres.
>

Re: Support for more data types

Posted by Julian Hyde <jh...@apache.org>.
Riccardo,

There is no technical reason for Avatica to not support those data
types. If someone contributed support for those data types (or any
other standard data types), we would gladly accept.

Julian

On Mon, Nov 22, 2021 at 3:01 AM Ricardo Peres
<ri...@collibra.com.invalid> wrote:
>
> Hi all,
>
> Our team is currently looking into Avatica to solve a specific use case we
> have.
> In our use case, we don't have control/knowledge of the schema, any data
> type can be returned. After some testing and checking the source code, we
> noticed that some data types are currently not supported, for instance the
> SQLXML data type.
> We understand that some data types like BLOB and SQLXML are not
> trivial/recommended to be sent via JSON/Protobuf over HTTP so, we would
> like to know if there are plans to support these/more data types or if
> there are any constraints that prevent the support to be implemented at all.
>
> Kind regards.
>
> Ricardo Peres.