[ https://issues.apache.org/jira/browse/IGNITE-7556?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Artem Budnikov updated IGNITE-7556: ----------------------------------- Description: Descriptions on [https://apacheignite-sql.readme.io/docs/schema-and-indexes] are not DML-friendly After reading this page and [https://apacheignite-sql.readme.io/docs/insert], one would likely still unable to write working INSERT because there won't be primary key in it. Their only chance is to spot _key reference in infoblock, or infer usability of setKeyFields() with single key type. Both are unlikely, leading to questions such as [https://stackoverflow.com/questions/48460214/how-do-i-read-data-from-ignite-kv-storage-using-jdbc] see {{Key is missing from query}} Such problems are hard to debug. They can be avoided if all examples of QueryEntities in docs will contain setKeyFields, and INSERT docs page will refer to _key field. was: Descriptions on [https://apacheignite-sql.readme.io/docs/schema-and-indexes] are not DML-friendly After reading this page and [https://apacheignite-sql.readme.io/docs/insert], one would likely still unable to write working INSERT because there won't be primary key in it. Their only chance is to spot _key reference in infoblock, or infer usability of setKeyFields() with single key type. Both are unlikely, leading to questions such as [https://stackoverflow.com/questions/48460214/how-do-i-read-data-from-ignite-kv-storage-using-jdbc] see {{Key is missing from query}} Such problems are hard to debug. They can be avoided if all examples of QueryEntities in docs will contain setKeyFields, and INSERT docs page will refer to _key field. > Docs should feature specifying SQL key more prominently > ------------------------------------------------------- > > Key: IGNITE-7556 > URL: https://issues.apache.org/jira/browse/IGNITE-7556 > Project: Ignite > Issue Type: Bug > Components: documentation > Reporter: Ilya Kasnacheev > Assignee: Artem Budnikov > Priority: Minor > Fix For: 2.7 > > > Descriptions on [https://apacheignite-sql.readme.io/docs/schema-and-indexes] > are not DML-friendly > After reading this page and > [https://apacheignite-sql.readme.io/docs/insert], one would likely still > unable to write working INSERT because there won't be primary key in it. > Their only chance is to spot _key reference in infoblock, or infer usability > of setKeyFields() with single key type. Both are unlikely, leading to > questions such as > [https://stackoverflow.com/questions/48460214/how-do-i-read-data-from-ignite-kv-storage-using-jdbc] > see {{Key is missing from query}} > Such problems are hard to debug. They can be avoided if all examples of > QueryEntities in docs will contain setKeyFields, and INSERT docs page will > refer to _key field. -- This message was sent by Atlassian JIRA (v7.6.3#76005)