[DRILL-1810] Scalability issues with kvgen

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.9.0
• Component/s: Functions - Drill, Storage - JSON
• Assignee: Mehant Baid
• Reporter: Rahul Kumar Challapalli
• Created: 04/Dec/14 23:58
• Updated: 24/Apr/15 18:14
• Resolved: 03/Apr/15 17:21

Description

git.commit.id.abbrev=4a4f54a

Memory Settings

DRILL_MAX_DIRECT_MEMORY="32G"
DRILL_MAX_HEAP="4G"

Scalar Dataset :

{"col1":{"a":"b"}}

The below query works fine for the above data set. However, if I just copy the same record 100000 times and execute the same query, kvgen fails with memory related issues

select kvgen(col1) from `json_kvgenflatten/kvgen-scalar-large.json`;

I attached the log files. Let me know if you need anything

Issue Links

• depends upon: DRILL-1816 Scan Error with JSON on large no of records with Complex Types