Excel Add-In for Parquet

Build 20.0.7695

Parquet データのモデリング

In this section we will show how to control the various schemes that the 本製品 offers to bridge the gap with relational SQL and nested Parquet services. The CData Excel Add-In for Parquet provides a managed way for you to use the two prevailing techniques for dealing with nested Parquet data:

  • Parsing the data structure and building a relational model based on the existing hierarchy.
  • Drilling down into the nested arrays and objects using horizontal flattening.

Parsing Hierarchical Data

By default, the 本製品 automatically detects the rows in a document, so that you do not need to know the structure of the underlying data to query it with SQL. Set the DataModel property to choose a basic configuration of how the 本製品 models object arrays into tables. Set the FlattenObjects and FlattenArrays properties to configure how nested data is flattened into columns. See 階層データの解析 for a guide.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 20.0.7695