Hi all,
Could someone please explain, in what cases it makes sense to use REPLICATED
cache/table?
I thought I would use REPLICATED tables for small tables which contain
related information.
Like a city table, which maybe has a few 10k entries.
And use PARTITIONED for big tables, like persons tab
Hi Ilya Kasnacheev,
On Ingite 2.7
No code is using affinityCall()
Haven’t enabled cache statistics
Could you please answer my questions in red below:
Try to increase Xmx up to 4Gb or higher or avoid G1GC usage on small heaps as
it is very sensitive to free heap memory.
James>> Yes, it helps.
As
Hi
I wanted to start the TX transaction with a timeout value, however the
"txStart" API also expects a "txSize" parameter.
The documentation states we can pass an approximate value.
https://ignite.apache.org/releases/latest/javadoc/org/apache/ignite/IgniteTransactions.html
Could you tell how t
I see.
Let me get back to you on that - it may take some time employ 2.7.
Thank you
Ariel
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Hi Igor,
I took a look at the master branch. I have couple questions.
1. For void getAndPutIfAbsent, the method has this comment:
@param valOut Previously contained value regardless of whether put happened
or not (null if there
* was no previous value).
How do we
Hello!
Your best bet is to use LONG or DOUBLE, I guess.
Regards,
--
Ilya Kasnacheev
пн, 18 мар. 2019 г. в 17:31, PBSLogitek :
> I have a BigDecimal column on my entity which i need to index. Now i see
> following message in the console
>
> /Column cannot be inlined into the index because it's
We had found we needed to change this in ignite.sh along these lines, so we
only had to expose one port out of the container.Otherwise you need to
expose the RMI port also.
# Newer Java versions (1.8.0_121+) allow the RMI port to be the same port.
if [ -n "$JMX_PORT" ]; then
JMX_MON="-Dcom.su
It looks like one of the nodes is unreachable or corrupt in some way. Look for
disconnection or communication errors.
As a general point, including text rather than screen-shots is preferable; the
screenshots are barely legible.
Regards,
Stephen
> On 18 Mar 2019, at 14:32,
> wrote:
>
> Hi,
> CREATE TABLE Country (
> country_id INT(10),
> country_name CHAR(30),
> Continent CHAR(30),
> PRIMARY KEY (country_id)
> ) WITH "template=partitioned, backups=1";
>
>
> CREATE TABLE City (
> city_id INT(15),
> country_name CHAR(30),
> city_name CHAR(50),
> Dist CHAR(20),
> PRIMARY KEY
I have a BigDecimal column on my entity which i need to index. Now i see
following message in the console
/Column cannot be inlined into the index because it's type doesn't support
inlining, index access may be slow due to additional page reads (change
column type if possible) [cacheName=ChannelPr
Attached SQL file is missing, So I am adding content in post directly :
CREATE TABLE Country (
country_id INT(10),
country_name CHAR(30),
Continent CHAR(30),
PRIMARY KEY (country_id)
) WITH "template=partitioned, backups=1";
CREATE TABLE City (
city_id INT(15),
country_name CHAR(30),
city
Please find attached SQL file .
Result of query:
select count(*) from city c join country co on c.country_name =
co.country_name;
= 0 Rows
select count(*) from city c join country co on c.country_name !=
co.country_name;
= 1200 Rows
--
Sent from: http://apache-ignite-users.70518.x6.nabble
I also have a problem with this so if someone can help..!
Tnx
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Hello!
Writing such function is easy (you probably could do that using custom SQL
functions already), but optimizing and indexing such function is very
non-trivial.
And users of RDBMS expect that core functionality will be sufficiently
optimized.
Regards,
--
Ilya Kasnacheev
пн, 18 мар. 2019 г
I recommend that Ignite can implement a function using JSON Path to handle such
ArrayList type.
Since most of RDBS supports JSON PATH now like MSSQL. It would be easier for
developer to handle with nested object or JSON string.
Before Ignite implement this, developer have to implement a custom
By the way, since Ignite 2.8 Ignite is going to support both OpenSSL 1.0
and 1.1
Best Regards,
Igor
On Thu, Mar 14, 2019 at 12:18 PM Ilya Kasnacheev
wrote:
> Hello!
>
> You can do 'sudo make uninstall' instead of deleting headers manually.
> Otherwise, cheers!
>
> Regards,
> --
> Ilya Kasnach
Hi Jack,
Design document is mostly for developers, not for users. It shows current
state of the master branch, so not every feature listed there as supported
actually presents in any Ignite release. You can try naightly builds [1]
though,
if you want try some new features before they get into some
Hello!
Looks like affinity collocation does not work. Can you share country-city
script (and DDL) so I could check?
Regards,
--
Ilya Kasnacheev
пт, 15 мар. 2019 г. в 19:16, NileshKhaire :
> Hello,
>
> I have inserted 1000 cities now and 3 countries.
>
> 1st Country = 500 cities
> 2nd Country
Hello!
Are you sure it's Ignite's SQL? Since this statement does not look like
something Ignite will accept.
In Ignite you can use double quotes to specify case-sensitive spelling:
"GameType".
Then I expect identifiers will be considered case-sensitive and will need
to be specified in double quo
Hello!
The best approach is to use .setIndexedTypes() instead of
setQueryEntities(), and annotate complex types in question with
@QuerySqlField.
This way you can then pour those types into cache and it will work
transparently.
Regards,
--
Ilya Kasnacheev
пт, 15 мар. 2019 г. в 18:28, Mike Needh
20 matches
Mail list logo