Comments (4)
max-sixty
commented on June 6, 2024
I don't think that stripping the timezone would be good — '2023-03-01T00:00:00Z' has a different meaning to '2023-03-01T00:00:00'.
A really complete approach would be to preemptively know that ClickHouse didn't support timezones, and raise an error. Getting to that level of support across language features & dialects would be nice, but require lots of investment.
So for the moment, is it reasonable to just use ..@2023-03-01T00:00:00) in the PRQL query? That then passes on the '2023-03-01T00:00:00' value and the query should work.
from prql.
ukclivecox
commented on June 6, 2024
Yes, I can work around this. Just created this issue as an FYI for discussion for a full solution.
from prql.
max-sixty
commented on June 6, 2024
OK great.
Let's leave it open for a bit to see if others have thoughts.
My initial inclination is that this level of detail in the compiler is probably some distance away, unless a contributor has a specific interest in clickhouse datetimes. So we could mark as postponed.
from prql.
max-sixty
commented on June 6, 2024
Marking as postponed. Thanks for the suggestion @ukclivecox.
from prql.
Related Issues (20)
- Nightly tests failed HOT 1
- prqlc CLI not built with cli feature enabled (version 0.11.2 and 0.11.3) HOT 5
- Aggregating on group key got messed with multiple CTEs HOT 3
- Nightly tests failed
- make PRQL usable from observable/framework HOT 5
- The `let main =` example in the book doesn't work HOT 3
- Join on clickhouse produces intersect expression and failed query HOT 1
- Panic on query `x -> y` HOT 8
- 0.11.4 didn't publish
- 0.11.4 didn't publish HOT 2
- Null safe equality inconsistency HOT 11
- `into` semantics as transform? HOT 4
- Publish the lutra python bindings HOT 1
- Aliasing Left Side of Join Breaks Derivation HOT 5
- Use `git cliff` to generate changelogs HOT 7
- "How to become a `SELECT` star" HOT 2
- Nightly tests failed HOT 2
- Unhelpful error with `take -10` HOT 2
- Multiple `select` transform is wonky HOT 3
- Compile crash on `from {}`
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from prql.