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

Query with dynamic prefix computed fields on external dataset returns empty for avro file format

Details

    Description

      Steps to reproduce -

      1. Create an external dataset with AVRO file format

        CREATE EXTERNAL DATASET Default.Default.gXeAxG4EMBnpeGWiO5XZi7uix1LMbC ON `columnar-functional-sanity-test-data` AT Default.Default.lnytUuF2No1gl USING "level_{level_no:int}_folder_{folder_no:int}" WITH {"include": "*.avro", "format": "avro"};

      2. Run following query

        select count(*) from Default.Default.gXeAxG4EMBnpeGWiO5XZi7uix1LMbC where level_no=1 and folder_no=1

      3. Above query returns empty result.
      4. But if we run below query, it returns correct result

        select count(*) from Default.Default.ECPRgWAcj 

        This issue is not seen for external datasets created for other file formats.

      Attachments

        For Gerrit Dashboard: MB-61548
        # Subject Branch Project Status CR V

        Activity

          People

            ayush.tripathi Ayush Kumar Tripathi
            umang.agrawal Umang
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:

              Gerrit Reviews

                There is 1 open Gerrit change

                PagerDuty