odbc2parquet
odbc2parquet copied to clipboard
pacman82
A command line tool to query an ODBC data source and write the result into a parquet file.
In TSQL/SQL Server, the [`datetimeoffset`](https://docs.microsoft.com/en-us/sql/t-sql/data-types/datetimeoffset-transact-sql?view=sql-server-ver16) - which is practially datetime with timezone offset - is currently converted into a parquet string. I don't like that because the data stored there...
With default options I made the following measurements using a 10m row table with few int32, int64, double, date, timestamp columns (so no string or other exotic type). ``` tool...
Hi Markus, I'm still using this nice tool and so far everything worked as expected. But then recently I encountered some edge case scenario when I'm trying to dump a...
Hey, not entirely sure this issue will make sense, but I'm an absolute parquet noob and found your tool as a way of dumping stuff from a MariaDB to Parquet...
Prompt for password if the user does not provide one then connecting via dsn on the command line. Consider using https://crates.io/crates/indicatif to handle the user dialog. How do we want...
When I connect to a SQL Server database and query data with data type `datetime` or `datetime2`, it gets converted to parquet data type `BIGINT`. But I would expect data...
According to the [mysql documentation](https://dev.mysql.com/doc/refman/8.0/en/keywords.html), when dealing with reserved words as column names, you can enclose the name with a \` or by providing fully qualified column names in the...
Inspired by #284 and #285. The switch to logical types allowed `odbc2parquet` to select better fitting types in many situations. However, if logical types are not supported by the next...
Hello Markus, I actively using your cli but unfortunately faced with this. ``` thread 'main' panicked at /home/redacted/.cargo/registry/src/index.crates.io-6f17d22bba15001f/parquet-53.0.0/src/file/writer.rs:369:10: Negative row group ordinal: TryFromIntError(()) stack backtrace: 0: 0x5cf28330138a - ::fmt::h1b9dad2a88e955ff 1:...
