Skip to content

COUNT(*) Warning breaking Pushdown queries #8765

@pauldheinrichs

Description

@pauldheinrichs

Describe the bug
A clear and concise description of what the bug is.

Since this PR has been merged - querying in the BI tool to check counts results in an error rather than getting a count. With pushdown enabled - i wouldn't have anticipated this would be the expected flow if a count measure didn't exist.


If this is the expected outcome, then feel free to close!

cube(`Orders`, {
  sql: `
  select 1 as id, 100 as amount, 'new' status
  UNION ALL
  select 2 as id, 200 as amount, 'new' status
  UNION ALL
  select 3 as id, 300 as amount, 'processed' status
  UNION ALL
  select 4 as id, 500 as amount, 'processed' status
  UNION ALL
  select 5 as id, 600 as amount, 'shipped' status
  `,
  measures: {
    count: {
      type: `count`,
     public: false
    },
    totalAmount: {
      sql: `amount`,
      type: `sum`,
    },
    toRemove: {
      type: `count`,
    },
  },
  dimensions: {
    status: {
      sql: `status`,
      type: `string`,
    },
  },
});


view(`orders_view`, {
  cubes: [
    {
      join_path: Orders,
      prefix: true,
      includes: `*`
    },
}

When doing a select count(*) on the orders_View it will error out..

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions