cube-js/cube

Fails to parse ES query result

Open

#3128 aperta il 19 lug 2021

Vedi su GitHub
 (1 commento) (0 reazioni) (0 assegnatari)Rust (1965 fork)batch import
driver:elasticsearchhelp wanted

Metriche repository

Star
 (19.563 star)
Metriche merge PR
 (Merge medio 5g 16h) (138 PR mergiate in 30 g)

Descrizione

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.

Guida contributor