ignite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sergey Kozlov <skoz...@gridgain.com>
Subject Re: Does Ignite support java.sql.Array?
Date Mon, 13 Aug 2018 14:22:11 GMT
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
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message