pqrs icon indicating copy to clipboard operation
pqrs copied to clipboard

Add support for SQL schemas

Open frgomes opened this issue 2 years ago • 1 comments
trafficstars

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

frgomes avatar Jul 11 '23 21:07 frgomes

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?

manojkarthick avatar Jul 17 '23 19:07 manojkarthick