manojkarthick/pqrs

Add support for SQL schemas

Opened this issue · 1 comments

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');

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?