Hi, No, we do not support ARRAY data type at the moment. Let's remove it from docs.
On Mon, Aug 13, 2018 at 10:06 PM Denis Magda <[email protected]> wrote: > Vladimir, > > Could you step in? How should we update our docs and what are the steps to > add Arrays support to the project? I thought this worked all the times. > > -- > Denis > > On Mon, Aug 13, 2018 at 8:55 AM Nikolay Izhikov <[email protected]> > wrote: > >> 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 <[email protected]> >> 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 <[email protected] >> > >> > > 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 >> > >> > >> > > >
