cube-js/cube

Support generating the data model for nested records in BigQuery

開放

#227 建立於 2019年10月7日

 (6 則留言) (0 個反應) (0 位負責人)Rust (1,965 個分叉)batch import
driver:bigqueryhelp wanted

倉庫指標

星標
 (19,563 顆星)
PR 合併指標
 (PR 指標待抓取)

描述

Describe the bug I have a bigquery schema that uses nested repeated records, any reference of a field in the nested record throws an error like this:

Error: Error: Cannot access field balance on a value with type ARRAY<STRUCT<price FLOAT64, balance FLOAT64, currency_iso STRING, ...>> at [5:41]

I think for this to be solved cube.js needs to use the UNNEST sql keyword to flatten the array of records: https://stackoverflow.com/questions/39109817/cannot-access-field-in-big-query-with-type-arraystructhitnumber-int64-time-in

The issue was mentioned at the end here, but it was closed so I opened a new one: #182

貢獻者指南