Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                
Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SQL API: Compute error in queries with OR operator #8417

Open
kderbalah opened this issue Jul 2, 2024 · 2 comments
Open

SQL API: Compute error in queries with OR operator #8417

kderbalah opened this issue Jul 2, 2024 · 2 comments
Labels
question The issue is a question. Please use Stack Overflow for questions.

Comments

@kderbalah
Copy link

kderbalah commented Jul 2, 2024

Failed SQL

SELECT week_utc, MEASURE(num_customers) AS total_customers
FROM customers
WHERE month_utc = 202310 OR month_utc = 202311
GROUP BY week_utc

Error
SQL Error [XX000]: ERROR: Arrow error: Compute error: TypeError: Cannot read properties of undefined (reading 'split')

Logical Plan

CubeScan: request={
  "measures": [
    "customers.num_customers"
  ],
  "dimensions": [
    "customers.week_utc"
  ],
  "segments": [],
  "filters": [
    {
      "or": [
        {
          "member": "customers.month_utc",
          "operator": "equals",
          "values": [
            "202310"
          ]
        },
        {
          "member": "customers.month_utc",
          "operator": "equals",
          "values": [
            "202311"
          ]
        }
      ]
    }
  ]
}

Version:
v0.35.55

Additional context
I see same error when enabling SQL pushdown

@paveltiunov
Copy link
Member

@kderbalah This one most likely fails during query_rewrite

@paveltiunov paveltiunov added the question The issue is a question. Please use Stack Overflow for questions. label Jul 5, 2024
@kderbalah
Copy link
Author

@paveltiunov I believe so, the query works fine without the OR operator, and the logical plan seems to be correct, what could be the issue?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
question The issue is a question. Please use Stack Overflow for questions.
Projects
None yet
Development

No branches or pull requests

2 participants