Hello!
I believe if all fields' lengths are known (e.g. number columns) it is the
exact number of bytes required to store them.
If some of lenghts are unknown I believe it's 10 by default.
Not sure you can introspect it after index is created.
Regards,
--
Ilya Kasnacheev
сб, 8 дек. 2018 г. в
Thanks, Ilya.
How can find the payload size of an existing index?
Jose
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Hello!
Yes, you should put a number there, instead of "true". My bad.
As for your problem, I have filed a ticket:
https://issues.apache.org/jira/browse/IGNITE-10602
You can work around this problem by invoking every CREATE INDEX in its own
statement.
Regards,
--
Ilya Kasnacheev
пт, 7 дек.
I have found that issuing the CREATE INDEX commands separately (not as part
of a multiple-statement command) works fine.
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Thanks, Ilya,
Isn't the IGNITE_MAX_INDEX_PAYLOAD_SIZE setting expecting a number
(byte-count)?
The SQL command(s) I run is as follows:
String cmd = "DROP TABLE IF EXISTS public.transactions;" +
"DROP INDEX IF EXISTS transactions_id_k_v;" +
Hello!
Just start your JVM with -DIGNITE_MAX_INDEX_PAYLOAD_SIZE=true or set
IGNITE_MAX_INDEX_PAYLOAD_SIZE environment variable to "true" before
starting JVM.
INLINE_SIZE worked the last time I have checked. Can you show the exact
statement and error message?
Regards,
--
Ilya Kasnache
Hi,
How do we set the global default IGNITE_MAX_INDEX_PAYLOAD_SIZE?
(Note: Adding INLINE_SIZE xx to a CREATE INDEX command, as per the docs is
throwing an SqlException!)
Thanks,
Jose
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/