[DRILL-5111] Nested array column trimmed on 64k characters when queried via ODBC

• Type: Bug
• Status: Open
• Priority: Critical
• Resolution: Unresolved
• Affects Version/s: 1.8.0
• Component/s: Client - ODBC
• Assignee: Unassigned
• Reporter: Daniel Jurcau
• Created: 06/Dec/16 07:44
• Updated: 06/Dec/16 07:56

Description

When querying JSON documents via the ODBC driver on Windows, the contents of columns which contain a JSON array is always trimmed to 64K characters.

Example entry in the JSON document:
{
"id": 1,
"items": [

{"type": "item"}

,
// thousands of similar entries
]}

On querying, the column items returns the array as a JSON string that never exceeds 64K characters, even if the amount should be in the range of a few megabytes for the data in question.