ignite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sergey Kozlov (Jira)" <j...@apache.org>
Subject [jira] [Created] (IGNITE-12372) Thin Jdbc driver with collocated=true return per node results
Date Thu, 14 Nov 2019 10:53:00 GMT
Sergey Kozlov created IGNITE-12372:
--------------------------------------

             Summary: Thin Jdbc driver with collocated=true return per node results
                 Key: IGNITE-12372
                 URL: https://issues.apache.org/jira/browse/IGNITE-12372
             Project: Ignite
          Issue Type: Bug
          Components: sql
    Affects Versions: 2.7.6
            Reporter: Sergey Kozlov


# Start two nodes (in-memory)
 # Run sqlline \{{>bin\sqlline.bat -d org.apache.ignite.IgniteJdbcThinDriver -u jdbc:ignite:thin://127.0.0.1/?collocated=true}}
 # Create a table and select aggregation functions:

{noformat}

: jdbc:ignite:thin://127.0.0.1/> create table t1 (a int not null primary key, b varchar)
with "template=partitioned";
No rows affected (0,15 seconds)
0: jdbc:ignite:thin://127.0.0.1/> insert into t1 values (1, 'a'), (2, 'b'), (3, 'c'), (4,
'd');
4 rows affected (0,091 seconds)
0: jdbc:ignite:thin://127.0.0.1/> select * from t1;
+--------------------------------+--------------------------------+
| A | B |
+--------------------------------+--------------------------------+
| 1 | a |
| 2 | b |
| 4 | d |
| 3 | c |
+--------------------------------+--------------------------------+
4 rows selected (0,074 seconds)
0: jdbc:ignite:thin://127.0.0.1/> select count(*) from t1;
+--------------------------------+
| COUNT(*) |
+--------------------------------+
| 3 |
| 1 |
+--------------------------------+
2 rows selected (0,011 seconds)
0: jdbc:ignite:thin://127.0.0.1/> select min(a), max(b) from t1;
+--------------------------------+--------------------------------+
| MIN(A) | MAX(B) |
+--------------------------------+--------------------------------+
| 1 | d |
| 3 | c |
+--------------------------------+--------------------------------+
2 rows selected (0,012 seconds)
0: jdbc:ignite:thin://127.0.0.1/> select min(a), max(a) from t1;
+--------------------------------+--------------------------------+
| MIN(A) | MAX(A) |
+--------------------------------+--------------------------------+
| 1 | 4 |
| 3 | 3 |
+--------------------------------+--------------------------------+
2 rows selected (0,01 seconds)
0: jdbc:ignite:thin://127.0.0.1/>

{noformat}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Mime
View raw message