You can make good use of Index Hints.
e.g. SELECT * FROM Person USE INDEX(index_age) WHERE salary > 15 AND age
< 35;
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Hi,
I am using Ignite Cache with Persistence. While execution over large tables,
i noticed the below message repeatedly getting logged.
[WARNING][query-#100%IGNITE%][IgniteH2Indexing] Query execution is too long
[time=4863 ms, sql='SELECT
PUBLIC.__Z0._KEY __C0_0,
PUBLIC.__Z0._VAL __C0_1
FROM PUBL
Hi,
We have a Micro Service client to ignite cluster throwing exception
"Cache doesn't exists ..." even though cache severs and caches are up and
running.
Could you please know us how to resolve this issue?
Thanks and Regards,
Hemasundara Rao Pottangi | Senior Project Leader
[image: HotelHub-
To add the java type configuration I am currently using is
java.sql.TYPES.TIMESTAMP
And java.sql.Timestamp
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Hi
I am using Sybase as third party persistence and using XML to configure
cache store factory.
Sybase datetime displays date by default format :
/mm/dd HH:mm:ss Am/pm
Whereas Ignite is expecting a different format with nanoseconds.
This is causing BinaryMarshaller to fail in deserialising
Thanks all.
I resolve it, since the second node didn't remoteListen by an inner logic.
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Just out of curiosity how are you planning to load 1 TB of data in cache,
using datastreamer or cachestore?
What's the expected time to load cache?
Since you are not keeping back up, how are you going to handle the
situation when any of the node crashes? This can happen in prod env, so
what is the
Thank you for reply, Ilya.
> Have you tried to start this on Nightly Build? Can you try that?
No, on 2.7.0#20181130-sha1:256ae401. I will try Nightly Build.
> If it still would not work, can you share your DB+wal files?
I think yes, but it's 15 GB.
On 3/6/19 6:59 PM, Ilya Kasnacheev wrote:
> He
Hello!
Have you tried to start this on Nightly Build? Can you try that?
If it still would not work, can you share your DB+wal files?
Regards,
--
Ilya Kasnacheev
вт, 5 мар. 2019 г. в 20:37, Dmitry Lazurkin :
> Ignite version: 2.7.0#20181130-sha1:256ae401
>
>
>
Hi,
But SQL type BLOB isn't supported by Ignite.
Please use BINARY SQL type.
06.03.2019 18:40, Taras Ledkov пишет:
Hi,
The JDBC Blob is supported by JDBC v2 driver (thick driver based on
Ignite client node).
Thin JDBC driver hasn't supported Blob yet.
06.03.2019 13:50, KR Kumar пишет:
Hi -
Hi,
The JDBC Blob is supported by JDBC v2 driver (thick driver based on
Ignite client node).
Thin JDBC driver hasn't supported Blob yet.
06.03.2019 13:50, KR Kumar пишет:
Hi - I trying out JDBC driver with ignite SQL tables. How do i insert a blob
into my cache table through jdbc?
Thanx and
Dear Apache Enthusiast,
(You’re receiving this because you are subscribed to one or more user
mailing lists for an Apache Software Foundation project.)
TL;DR:
* Apache Roadshow DC is in 3 weeks. Register now at
https://apachecon.com/usroadshowdc19/
* Registration for Apache Roadshow Chicago is
Hello!
I don't see very much going on here. Which one of those dumps are client
which generate load? How do you generate it?
Regards,
--
Ilya Kasnacheev
ср, 6 мар. 2019 г. в 04:29, yu...@toonyoo.net :
> you can see the full thread dump in the attarchment,the filename is
> dump.zip
>
> ---
Hello!
Can you make a small reproducer project, share it with us?
Regards,
--
Ilya Kasnacheev
ср, 6 мар. 2019 г. в 16:08, Ropugg :
> The two nodes have the same subscriber.
> The only difference is the order of starting node.
> The first started node, we call it as Node1, the second started n
Hello!
You can try to see how many entries will fit in your single node (enable
page eviction, see how much you can get before eviction is started), then
scale it up after adding some buffer space.
Regards,
--
Ilya Kasnacheev
ср, 6 мар. 2019 г. в 12:28, Navneet Kumar :
> Ilya,
> Thanks for yo
Hello!
It might take some time to rewind WAL. Consider starting it with -v (or
-DIGNITE_QUIET=false)
Regards,
--
Ilya Kasnacheev
ср, 6 мар. 2019 г. в 16:26, James Wang 王升平 (edvance CN) <
james.w...@edvancesecurity.com>:
> Hi Support,
>
>
>
> My lab VM were shutdown by lack of power. But After
Hello!
I'm afraid that at this point even indexes do not fit in RAM so every
insert needs to get index pages from disk, change them and put them back to
make room for newer ones. Please consider having larger DataRegions.
Regards,
--
Ilya Kasnacheev
ср, 6 мар. 2019 г. в 16:26, Antonio Conforti
Hello!
I don't think we support blobs at the moment. Use setBytes to store data as
byte[].
Regards,
--
Ilya Kasnacheev
ср, 6 мар. 2019 г. в 13:58, KR Kumar :
> Hi - I trying out JDBC driver with ignite SQL tables. How do i insert a
> blob
> into my cache table through jdbc?
>
> Thanx and Rega
Hi Support,
My lab VM were shutdown by lack of power. But After I restart them, I find the
console hang at
[21:26:43] Topology snapshot [ver=35, locNode=2931204b, servers=3, clients=0,
state=ACTIVE, CPUs=12, offheap=12.0GB, heap=3.0GB]
[21:26:43] ^-- Baseline [id=3, size=3, online=3, offline=
Hello Ilya,
thanks for reply.
For answer to your questions today i runned again a test that i stopped at
about 22 millions of entries:
a) the approximate hardware and data region config used in the test:
2 hosts each with:
Processor total : 2
Processor: 0
Name : Intel Xeon
The two nodes have the same subscriber.
The only difference is the order of starting node.
The first started node, we call it as Node1, the second started node is
Node2.
The Node1 send a message, the Node2 will handle it as expected in
remoteListen(@Nullable Object topic, IgniteBiPredicate p)
But t
Hi - I trying out JDBC driver with ignite SQL tables. How do i insert a blob
into my cache table through jdbc?
Thanx and Regards,
KR Kumar
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Hello!
So I have re-ran it with backup.
2 nodes with 1 backup will load 15M entries slightly faster than 1 node
which loads 30M entries without backups.
So I would say that having backups is actually slightly faster.
However, storing 15M entries without backups on 1 node is still 4-5x faster.
Ilya,
Thanks for your quick response. I have gone through the capacity planning
link shared by you.
1,000,000,000 Total objects(Records)
1,024 bytes per object (1 KB)
0 backup
4 nodes
Total number of objects X object size (only primary copy since back up is
set 0. Better remove the back up propert
HI ,
We have provide thread dumps from all client and server. Would you mind
look at it ?
thanks very much.
yu...@toonyoo.net 于2019年3月6日周三 上午9:29写道:
> you can see the full thread dump in the attarchment,the filename is
> dump.zip
>
> --
> yu...@toonyoo.net
>
>
25 matches
Mail list logo