[ARROW-8037] [Developer][Integration] Consolidate example JSON and test/validate uniformly

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 0.16.0
• Component/s: Integration
• External issue URL: https://github.com/apache/arrow/issues/24252
• Assignee: Unassigned
• Reporter: Ben Kietzman
• Created: 09/Mar/20 15:02
• Updated: 11/Jan/23 07:57

Description

Currently the schema for the integration JSON representation is expressed in prose only. It should be rewritten using a JSON schema representation and used to validate generated as well as (checked-in) example JSON. jsonschema would work https://python-jsonschema.readthedocs.io/en/stable/validate/

Additionally, languages unit test their JSON parsers/converters against differing example JSON:

C++ includes some inline https://github.com/apache/arrow/blob/b0bb6841af91ed2fddc201ca1ff6bedac7629e2e/cpp/src/arrow/ipc/json_integration_test.cc#L317-L346

While Java uses an explicit file https://github.com/apache/arrow/blob/5b783fe35284c97f6bcf107650ba7cfd66a76750/java/tools/src/test/java/org/apache/arrow/tools/TestIntegration.java#L189

This is brittle and difficult to discover. A single directory of checked-in example JSON should be assembled, against which all languages should unit test.