ignite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nikolay Izhikov <nizhi...@apache.org>
Subject Re: Does Ignite support java.sql.Array?
Date Mon, 13 Aug 2018 15:55:25 GMT
Thanks for a comments.

Should we update documentation and remove ARRAY support?

Vladimir, Denis, can you comment on this?

В Пн, 13/08/2018 в 17:29 +0300, Vyacheslav Daradur пишет:
> 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
> 
> 
> 
Mime
View raw message