What happens?

The docs suggest usage of describe select * for getting info about column names and types of parquet files:
https://duckdb.org/docs/data/parquet

If you want to figure out the column names and types contained within a Parquet file it is easier to use DESCRIBE.

-- fetch the column names and column types
DESCRIBE SELECT * FROM 'test.parquet';

But this doesn't return anything when executed as a query, neither with parquet files nor with other input types.

In the latest pre-release version, executing the query prints something (looks like a black rectangle when executed in python), but the result is not returned as a table.

To Reproduce

import numpy as np, pandas as pd
df = pd.DataFrame({"col1" : np.arange(5)})
import duckdb
duckdb.query("describe select * from df").to_df()

OS:

Linux

DuckDB Version:

0.6.1

DuckDB Client:

Python

Full Name:

David Cortes

Affiliation:

None

Have you tried this on the latest master branch?

• I agree

Have you tried the steps to reproduce? Do they include all relevant data and configuration? Does the issue you report still appear there?

• I agree