akoshchiy commented on PR #16790:
URL: https://github.com/apache/datafusion/pull/16790#issuecomment-3089036776
I've added some comments to the docs.
btw, I've checked behaviour on duckdb, and it looks more clearly - there is
no prefixes at all. Maybe we can do the same?
```
cat nested_2.ndjson
{"metadata": {"product": "Product Name 1", "price": 1}}
{"metadata": {"product": "Product Name 2", "price": 2}}
{"metadata": {"product": "Product Name 3", "price": 3}}
{"metadata": {"product": "Product Name 4", "price": 4}}
{"metadata": {"product": "Product Name 5", "price": 5}}
{"metadata": {"product": "Product Name 6", "price": 6}}
{"metadata": {"product": "Product Name 7", "price": 7}}
{"metadata": {"product": "Product Name 8", "price": 8}}
{"metadata": {"product": "Product Name 9", "price": 9}}
duckdb
DuckDB v1.3.2 (Ossivalis) 0b83e5d2f6
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
D SELECT unnest(metadata) FROM 'nested_2.ndjson';
┌────────────────┬───────┐
│ product │ price │
│ varchar │ int64 │
├────────────────┼───────┤
│ Product Name 1 │ 1 │
│ Product Name 2 │ 2 │
│ Product Name 3 │ 3 │
│ Product Name 4 │ 4 │
│ Product Name 5 │ 5 │
│ Product Name 6 │ 6 │
│ Product Name 7 │ 7 │
│ Product Name 8 │ 8 │
│ Product Name 9 │ 9 │
└────────────────┴───────┘
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org
For additional commands, e-mail: github-h...@datafusion.apache.org
