Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Feature Request: correct handling of queries on Parquet file (using OPENROWSET) #509

Open
aarwurzer2 opened this issue Jul 10, 2024 · 0 comments

Comments

@aarwurzer2
Copy link

Currently, the querying of Parquet files is not handled correctly. Columns are interpreted correctly, just not the tables part (as expected).
Following an example of a Parquet query, using OPENROWSET:

SELECT q.MY_FIELD01
  FROM OPENROWSET (BULK '/DATA_STORE1/1/data/date=2022-12-25/*'
                  ,DATA_SOURCE = 'parquet-datasource'
                  ,FORMAT = 'PARQUET') q
WHERE q.MY_FIELD02 >= 'value';

The current output is as follows:

Key Value(s)
Table names OPENROWSET
Table names BULK
Table names DATA_SOURCE
Table names FORMAT
Column names q.MY_FIELD01
Column names q.MY_FIELD02

But, as you might have guessed, OPENROWSET, BULK, DATA_SOURCE and FORMAT are actually all keywords.
For Table names the correct output should have been /DATA_STORE1/1/data/date=2022-12-25/*

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants