Skip to main content

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.

 

 


Reply