cube-js/cube

Fails to parse ES query result

Open

#3.128 geöffnet am 19. Juli 2021

Auf GitHub ansehen
 (1 Kommentar) (0 Reaktionen) (0 zugewiesene Personen)Rust (1.965 Forks)batch import
driver:elasticsearchhelp wanted

Repository-Metriken

Stars
 (19.563 Stars)
PR-Merge-Metriken
 (Durchschn. Merge 5T 16h) (138 gemergte PRs in 30 T)

Beschreibung

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)

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