[IGNITE-9228] Spark SQL Table Schema Specification

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.6
• Fix Version/s: 2.8
• Component/s: spark
• Ignite Flags: Docs Required
• Assignee: Stuart Macdonald
• Reporter: Stuart Macdonald
• Created: 07/Aug/18 18:07
• Updated: 06/Sep/19 07:20
• Resolved: 08/Oct/18 15:59

Description

The Ignite Spark SQL interface currently takes just “table name” as a
parameter which it uses to supply a Spark dataset with data from the
underlying Ignite SQL table with that name.

To do this it loops through each cache and finds the first one with the
given table name [1]. This causes issues if there are multiple tables
registered in different schema with the same table name as you can only
access one of those from Spark. We could either:

1. Pass an extra parameter through the Ignite Spark data source which
optionally specifies the schema name.
2. Support namespacing in the existing table name parameter, ie
“schemaName.tableName”

[1 ]https://github.com/apache/ignite/blob/ca973ad99c6112160a305df05be9458e29f88307/modules/spark/src/main/scala/org/apache/ignite/spark/impl/package.scala#L119

Issue Links

• is related to: IGNITE-12141 Ignite Spark Integration Support Schema on Table Write
• links to: GitHub Pull Request #4551

Sub-Tasks

• Update documentation and examples for Spark SQL Table Specification: Closed