manojkarthick / pqrs

Command line tool for inspecting Parquet files
Apache License 2.0
294 stars 29 forks source link

Add support for SQL schemas #45

Open frgomes opened 1 year ago

frgomes commented 1 year ago

It would be handy if something like this would be available:

$ pqrs schema --sql-dialect=clickhouse --name=ticker /path/to/file.parquet
CREATE TABLE ticker (
  isin String NOT NULL,
  O Int32 NOT NULL,
  H Int32 NOT NULL,
  L Int32 NOT NULL,
  C Int32 NOT NULL
) ENGINE = Parquet('/path/to/file.parquet');
manojkarthick commented 1 year ago

Agree that this would be useful but I'm not sure if this fits into pqrs. I would also not like to end up supporting various SQL dialects within pqrs. Might be better off as a separate tool?