I tried like the below, still no luck.. Am I missing something here
[tibusr@JMNGD1BAQ10V03 bin]$ ./sqlline.sh --verbose=true -u jdbc:ignite:thin://127.0.0.1;distributedJoins=true issuing: !connect jdbc:ignite:thin://127.0.0.1 '' '' org.apache.ignite.IgniteJdbcThinDriver Connecting to jdbc:ignite:thin://127.0.0.1 Connected to: Apache Ignite (version 2.3.0#20171028-sha1:8add7fd5) Driver: Apache Ignite Thin JDBC Driver (version 2.3.0#20171028-sha1:8add7fd5) Autocommit status: true Transaction isolation: TRANSACTION_REPEATABLE_READ sqlline version 1.3.0 0: jdbc:ignite:thin://127.0.0.1> select A.ACCOUNT_ID,P.ACCOUNT_ID_LIST from "Account".Account A, "Customer".Customer P where P.PARTY_ID='P100000001' and A.PARTY_ID = P.PARTY_ID; +--------------------------------+--------------------------------+ | ACCOUNT_ID | ACCOUNT_ID_LIST | +--------------------------------+--------------------------------+ +--------------------------------+--------------------------------+ No rows selected (0.044 seconds) 0: jdbc:ignite:thin://127.0.0.1> Regards, Naveen 91-9561721495 From: Alexey Kukushkin [mailto:[email protected]] Sent: Friday, November 24, 2017 6:44 PM To: [email protected] Subject: Re: SQL Join not giving results Please add distributedJoins=true parameter to a connection URL when you run sqlline.
