queryparser
queryparser copied to clipboard
uber
Parsing and analysis of Vertica, Hive, and Presto SQL.
Hey,First of all, it's an amazing effort towards building a parser. I am trying to use this tool to parse hive and vertica queries. I am able to get the...
- `SET ROLE/SESSION/TIMEZONE` statement - Named window - Lambda expression - `CREATE TABLE AS` statement - Empty array expression based on #62
Hi, How can I run queryparser not with stack ghci ? In which way can I run it with cmd ? Receiving query file as input and file name to...
Hi, Not sure how to debug this further: ``` 2021-12-25 09:10:31.523860: [debug] DELETE FROM "config_cache_dep" WHERE ("config_cache_id"=?) AND (1=2); [PersistInt64 72] 2021-12-25 09:10:31.524114: [debug] INSERT INTO "config_cache_dep"("config_cache_id","ghc_pkg_id") VALUES (?,?),(?,?),(?,?),(?,?),(?,?),(?,?),(?,?),(?,?),(?,?),(?,?),(?,?),(?,?),(?,?),(?,?),(?,?),(?,?),(?,?),(?,?),(?,?),(?,?),(?,?),(?,?),(?,?); [PersistInt64...
ie srctableA.srcColumn1 = trgtableB.trgColumnX srctableA.srcColumn3 = trgtableB.trgColumnY
Hi, seems like resolver gets confused about the context used for resolution when trying to resolve columns in nested queries and fails with `AmbiguousColumn` error, e.g.: `select a from demo.foo...
Hello, I'm new to Haskell and wanted to dive into this project. I installed ghc and haskell-stack on my mac as the README suggested, but executing `stack setup` I kept...
Hi, some of the more advanced Vertica's aggregate functions are missing ([CUBE](https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/SQLReferenceManual/Statements/SELECT/CUBEaggregate.htm), [ROLLUP](https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/SQLReferenceManual/Statements/SELECT/ROLLUPClause.htm), [GROUPING SETS](https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/SQLReferenceManual/Statements/SELECT/GROUPINGSETaggregate.htm)), also other related funcions ([GROUPING](https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/SQLReferenceManual/Functions/Aggregate/GROUPING.htm), [GROUPING_ID](https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/SQLReferenceManual/Functions/Aggregate/GROUPING_ID.htm), [GROUP_ID](https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/SQLReferenceManual/Functions/Aggregate/GROUP_ID.htm)). I would like to contribute but it seems...
Long-term thinking here: Hive introduces its sql features across many versions, and we'll have users that need to pin to a specific version. The hive parser should add version to...
Hello! I am looking to parse and analyze Teradata queries so that we can better understand what tables and columns are used. After some googling I was happy to find...
