Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-40194

Query on external dataset is unable to parse large list of json objects.

    XMLWordPrintable

    Details

    • Triage:
      Triaged
    • Operating System:
      Centos 64-bit
    • Story Points:
      1
    • Is this a Regression?:
      Yes
    • Sprint:
      CX Sprint 205

      Description

      While querying external datasets created on AWS bucket, following behaviour was observed.

      File contains JSONL and list of JSON object, got the below error:

      [
      { "code": 23036, "msg": "Parsing error at file_0.json line 49873 field N/A: Unexpected character (',' (code 44)): expected a valid value (JSON String, Number, Array, Object or token 'null', 'true' or 'false')", "query_from_user": "select count(*) from travel_ds;" }
      ]
      

      File contains only list of JSON objects, got below error:

      [
      { "code": 23036, "msg": "Parsing error at file_x.json line 1 field N/A: Unexpected character (',' (code 44)): expected a valid value (JSON String, Number, Array, Object or token 'null', 'true' or 'false')", "query_from_user": "select count(*) from travel_ds;" }
      ]
      

       

      File samples attached.

        Attachments

        1. file_0.json
          8.06 MB
        2. file_x.json
          0.3 kB

          Issue Links

          No reviews matched the request. Check your Options in the drop-down menu of this sections header.

            Activity

            umang.agrawal Umang created issue -
            ali.alsuliman Ali Alsuliman made changes -
            Field Original Value New Value
            Assignee Hussain Towaileb [ hussain.towaileb ] Ali Alsuliman [ ali.alsuilman ]
            till Till Westmann made changes -
            Remote Link This issue links to "*DB review (Web Link)" [ 20106 ]
            till Till Westmann made changes -
            Epic Link MB-36814 [ 114175 ]
            till Till Westmann made changes -
            Link This issue blocks MB-38724 [ MB-38724 ]
            till Till Westmann made changes -
            Labels analytics analytics approved-for-6.6.0
            ali.alsuliman Ali Alsuliman made changes -
            Remote Link This issue links to "*DB git commit (Web Link)" [ 20107 ]
            ali.alsuliman Ali Alsuliman made changes -
            Rank Ranked higher
            ali.alsuliman Ali Alsuliman made changes -
            Rank Ranked higher
            ali.alsuliman Ali Alsuliman made changes -
            Sprint CX Sprint 205 [ 1126 ]
            ali.alsuliman Ali Alsuliman made changes -
            Rank Ranked lower
            ali.alsuliman Ali Alsuliman made changes -
            Resolution Fixed [ 1 ]
            Status Open [ 1 ] Resolved [ 5 ]
            Hide
            build-team Couchbase Build Team added a comment -

            Build couchbase-server-6.6.0-7851 contains cbas-core commit 7bfce0e with commit message:
            MB-40194: Copy JSON object data to buffer only when reading JSON object has started

            Show
            build-team Couchbase Build Team added a comment - Build couchbase-server-6.6.0-7851 contains cbas-core commit 7bfce0e with commit message: MB-40194 : Copy JSON object data to buffer only when reading JSON object has started
            ritam.sharma Ritam Sharma made changes -
            Labels analytics approved-for-6.6.0 analytics approved-for-6.6.0 needs-functional-test
            Hide
            build-team Couchbase Build Team added a comment -

            Build couchbase-server-7.0.0-2510 contains cbas-core commit 7bfce0e with commit message:
            MB-40194: Copy JSON object data to buffer only when reading JSON object has started

            Show
            build-team Couchbase Build Team added a comment - Build couchbase-server-7.0.0-2510 contains cbas-core commit 7bfce0e with commit message: MB-40194 : Copy JSON object data to buffer only when reading JSON object has started
            Hide
            umang.agrawal Umang added a comment -

            verified with couchbase server build 6.6.0-7861

            Show
            umang.agrawal Umang added a comment - verified with couchbase server build 6.6.0-7861
            umang.agrawal Umang made changes -
            Assignee Ali Alsuliman [ ali.alsuilman ] Umang [ JIRAUSER24787 ]
            Status Resolved [ 5 ] Closed [ 6 ]
            Hide
            build-team Couchbase Build Team added a comment -

            Build couchbase-server-6.6.2-9599 contains cbas-core commit 7bfce0e with commit message:
            MB-40194: Copy JSON object data to buffer only when reading JSON object has started

            Show
            build-team Couchbase Build Team added a comment - Build couchbase-server-6.6.2-9599 contains cbas-core commit 7bfce0e with commit message: MB-40194 : Copy JSON object data to buffer only when reading JSON object has started

              People

              Assignee:
              umang.agrawal Umang
              Reporter:
              umang.agrawal Umang
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Gerrit Reviews

                  There are no open Gerrit changes

                    PagerDuty