ignite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Vyacheslav Daradur <daradu...@gmail.com>
Subject Re: Does Ignite support java.sql.Array?
Date Mon, 13 Aug 2018 14:29:00 GMT
Hi, Nick!

ASAIK java.sql.Array hasn't been implemented in binary infrastructure yet.

You should implement it first, like in
https://issues.apache.org/jira/browse/IGNITE-4158

On Mon, Aug 13, 2018 at 5:22 PM Sergey Kozlov <skozlov@gridgain.com> wrote:
>
> Hi Nikolay
>
> I was not able to use array type in sqlline [1] in 2.6
>
> 1. https://issues.apache.org/jira/browse/IGNITE-9230
>
> On Mon, Aug 13, 2018 at 4:58 PM, Nikolay Izhikov <nizhikov@apache.org>
> wrote:
>
> > Hello, Igniters.
> >
> > Does Ignite support java.sql.Array?
> > Can someone from SQL experts clarify this case?
> >
> > My question relates to the specific ticket that comes from our user [1],
> > [2]
> >
> > Ignite documentaion says that we support sql ARRAY data type [3].
> >
> > 1. I'm able to create table with ARRAY column.
> >
> > new SqlFieldsQuery("CREATE TABLE person (id LONG, name VARCHAR, cars
> > ARRAY, PRIMARY KEY (id)) WITH \"backups=1\"")
> >
> > 2. I'm not able to insert or select Array column via jdbc:
> > JdbcConnection, JdbcThinConnection, JdbcResultSet doesn't support
> > `createArray` or similar methods [4], [5], [6].
> > All this classes just throw an exception is user try to create or retrieve
> > java.sql.Array -
> >
> > throw new SQLFeatureNotSupportedException("SQL-specific types are not
> > supported.");
> >
> > How I should insert/select rows into/from array column?
> > Do we have some ticket to add support of Array and other SQL specifi types?
> >
> > [1] https://stackoverflow.com/questions/51621280/saving-a-
> > spark-dataset-to-apache-ignite-with-array-column-and-savemode-overwrite
> > [2] https://issues.apache.org/jira/browse/IGNITE-9229
> > [3] https://apacheignite-sql.readme.io/docs/data-types#section-array
> > [4] https://github.com/apache/ignite/blob/master/modules/
> > core/src/main/java/org/apache/ignite/internal/jdbc2/
> > JdbcConnection.java#L764
> > [5] https://github.com/apache/ignite/blob/master/modules/
> > core/src/main/java/org/apache/ignite/internal/jdbc/thin/
> > JdbcThinConnection.java#L646
> > [6] https://github.com/apache/ignite/blob/master/modules/
> > core/src/main/java/org/apache/ignite/internal/jdbc2/
> > JdbcResultSet.java#L1026
> > [7] https://docs.oracle.com/javase/tutorial/jdbc/basics/array.html
>
>
>
>
> --
> Sergey Kozlov
> GridGain Systems
> www.gridgain.com



-- 
Best Regards, Vyacheslav D.

Mime
View raw message