[jira] [Created] (DRILL-1810) Scalability issues with kvgen

["Rahul Challapalli (JIRA)" <ji...@apache.org>]

Rahul Challapalli created DRILL-1810:
----------------------------------------

             Summary: Scalability issues with kvgen
                 Key: DRILL-1810
                 URL: https://issues.apache.org/jira/browse/DRILL-1810
             Project: Apache Drill
          Issue Type: Bug
          Components: Functions - Drill, Storage - JSON
            Reporter: Rahul Challapalli
            Assignee: Mehant Baid


git.commit.id.abbrev=4a4f54a

Memory Settings 
{code}
DRILL_MAX_DIRECT_MEMORY="32G"
DRILL_MAX_HEAP="4G"
{code}


Scalar Dataset :
{code}
{"col1":{"a":"b"}}
{code}

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
{code}
select kvgen(col1) from `json_kvgenflatten/kvgen-scalar-large.json`;
{code}


Complex Dataset :
{code}
{
  "data" : {
    "col1" : {
      "one" : [1,2,3,4],
      "two" : [{"a":"b"},{"c":"d"}]
    }
  }
}
{code}

Even in this case, the below query works fine for the above data set. However when we copy the same record 100000 times we are hitting memory issues
{code}
select kvgen(data) from `json_kvgenflatten/kvgen-complex-large.json`;
{code}

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



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)