cube-js / cube-js/cube

Fails to parse ES query result

Open
#3,128 1 comment 0 reactions 0 assignees View on GitHub
driver:elasticsearch help wanted
Dominant language
Rust
Stars
20.8k
Forks
2.1k
Avg merge
1d 2h
Merged PRs (30d)
181

Description

**Describe the bug**
Cubejs fails to parse ES query result.

**To Reproduce**
Steps to reproduce the behavior:
1. Create a valid cube schema connecting to AWS ES 7.7
2. Build a query using cubejs play ground with just measure and dimension
3. Run the query
4. See error

**Expected behavior**
Generated SQL query from cubejs log can be copied to kibana and executed successfully. So, query result should be shown in chart.

**Screenshots**
Screen shot attached.
```
Error: Cannot read property 'map' of undefined
at QueryQueue.parseResult (/cube/node_modules/@cubejs-backend/query-orchestrator/src/orchestrator/QueryQueue.js:125:13)
at QueryQueue.executeInQueue (/cube/node_modules/@cubejs-backend/query-orchestrator/src/orchestrator/QueryQueue.js:114:19)
at processTicksAndRejections (internal/process/task_queues.js:97:5)
at /cube/node_modules/@cubejs-backend/query-orchestrator/src/orchestrator/QueryCache.ts:330:17
at QueryOrchestrator.fetchQuery (/cube/node_modules/@cubejs-backend/query-orchestrator/src/orchestrator/QueryOrchestrator.ts:92:20)
at OrchestratorApi.executeQuery (/cube/node_modules/@cubejs-backend/server-core/src/core/OrchestratorApi.ts:57:20)
at /cube/node_modules/@cubejs-backend/api-gateway/src/gateway.ts:797:26
at async Promise.all (index 0)
at ApiGateway.load (/cube/node_modules/@cubejs-backend/api-gateway/src/gateway.ts:782:23)
at /cube/node_modules/@cubejs-backend/api-gateway/src/gateway.ts:281:7
Orchestrator error: 65ef53e6-1fed-4417-978d-5d36c946e066-span-1 (953ms)
```
Screen Shot 2021-07-19 at 1 47 00 PM

**Version:**
v0.27.53
AWS ES 7.7

**Additional context**
Generated SQL query has be run through kibana to verify there is no issue with query.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.