I am trying to use the duckdb summarize command
https://duckdb.org/docs/archive/0.9/guides/meta/summarize
in an in memory duckdb using the sqlexecutor:
SUMMARIZE SELECT * FROM read_parquet('/Users/x/Downloads/Address.parquet');
This doesn’t return any results/attributes but ‘runs’ successfully in FME. In DBeaver it runs no issues.
Any idea is there is a trick to get this working?
Many ThanksQ!
Have you exposed the Attributes on the Workspace?
“SELECT *” gives no clues to SQLExecutor as to what Workspace Attribute Names to create for generated Workspace Features. This will need to be set in the Attributes to Expose Parameter, or in a downstream AttributeExposer
If you however view the results in Data Inspector you will see on any individual Feature in the Feature Information any unexposed Attribute values.
