cube-js/cube

Fails to parse ES query result

开放

#3,128 创建于 2021年7月19日

 (1 条评论) (0 个反应) (0 位负责人)Rust (1,965 个派生)batch import
driver:elasticsearchhelp wanted

仓库指标

星标
 (19,563 个星标)
PR 合并指标
 (PR 指标待抓取)

描述

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.

贡献者指南