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 <skoz...@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 <nizhi...@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.
