p.enthalabs

chDB SQL Shell

Warning: This is a cached snapshot of the original page, consider retry with caching opt-out.

New Import

Examples

Local

Version SELECT version()Generated rows SELECT number, number * number AS square FROM numbers(10)

Remote files

TSV via url()SELECT * FROM url('https://datasets-documentation.s3.eu-west-3.amazonaws.com/nyc-taxi/trips_0.gz', 'TabSeparatedWithNames') LIMIT 10 TSV via s3()SELECT * FROM s3('https://datasets-documentation.s3.eu-west-3.amazonaws.com/nyc-taxi/trips_0.gz', NOSIGN, 'TabSeparatedWithNames') LIMIT 10 Parquet via url()SELECT * FROM url('https://datasets-documentation.s3.eu-west-3.amazonaws.com/house_parquet/house_0.parquet') LIMIT 10

chDB SQL Shell

[](https://github.com/chdb-io/chdb "chDB on GitHub")

chDB SQL Shell is initializing… 95.3 MiB

chdb :)

Enter SQL query