Comments (1)
nils-braun
commented on May 23, 2024
Set of operations, which calcite understands:
Comparison Operations
- =
- <>
- >
- >=
- <
- <=
- IS NULL
- IS NOT NULL
- IS DISTINCT FROM
- IS NOT DISTINCT FROM
- BETWEEN
- NOT BETWEEN
- LIKE
- NOT LIKE
- SIMILAR TO (#54)
- NOT SIMILAR TO (#54)
- IN
- NOT IN
- comparison SOME
- comparison ANY
- comparison ALL
- EXISTS
Boolean Operations
- OR
- AND
- NOT
- IS FALSE
- IS NOT FALSE
- IS TRUE
- IS NOT TRUE
- IS UNKNOWN
- IS NOT UNKNOWN
Math Operations
- +
- -
- *
- /
- POWER
- ABS
- MOD (needs CAST, #35)
- SQRT
- LN
- LOG10
- EXP
- CEIL
- FLOOR
- RAND
- RAND_INTEGER
- ACOS
- ASIN
- ATAN
- ATAN2
- CBRT
- COS
- COT
- DEGREES
- PI
- RADIANS
- ROUND
- SIGN
- SIN
- TAN
- TRUNCATE
String Operations
- ||
- CHAR_LENGTH
- CHARACTER_LENGTH
- UPPER
- LOWER
- POSITION
- TRIM
- OVERLAY
- SUBSTRING
- INITCAP
Date/Time Operations
- LOCALTIME (#54)
- LOCALTIMESTAMP (#54)
- CURRENT_TIME (#54)
- CURRENT_DATE (#54)
- CURRENT_TIMESTAMP (#54)
- EXTRACT (#54)
- FLOOR
- CEIL
- YEAR (#54)
- QUARTER (#54)
- MONTH (#54)
- WEEK (#54)
- DAYOFYEAR (#54)
- DAYOFMONTH (#54)
- DAYOFWEEK (#54)
- HOUR (#54)
- MINUTE (#54)
- SECOND (#54)
- TIMESTAMPADD (#91)
- TIMESTAMPDIFF
- LAST_DAY (#91)
Conditional Operations
- CASE
- NULLIF
- COALESCE
from dask-sql.
Related Issues (20)
- [BUG]] [GPU Logic Bug] "SELECT ((1) NOT BETWEEN (CASE ((<column>)) WHEN (1) THEN 0 END ) AND (<column>)) FROM <table>" brings Error
- [BUG][GPU Logic Bug] "SELECT ((<column>) IS DISTINCT FROM ((CASE <column> WHEN <number> THEN <number> END ))) FROM <table>" brings Error
- [BUG][GPU Logic Bug] "SELECT ( (CASE (CASE (<number>) WHEN <column> THEN (<number>) END ) WHEN <number> THEN (<number>) ELSE <column> END )) FROM <table>" brings Error
- [BUG][GPU Logic Bug] "SELECT (CASE (<column>) WHEN <number> THEN <number> END) FROM <table>" brings Error
- [BUG] [Logic Bug] "SELECT <column> FROM <table>" by JDBC brings Error
- [BUG][Logic Bug] "SELECT (<column>)*(<decimal>) FROM <table>" by JDBC brings Error
- [BUG][Logic Bug] "SELECT <column> FROM <table>" brings Error
- SchemaError / NotImplementedError: The python type string is not implemented (yet) HOT 2
- Implement date_trunc function [ENH]
- [BUG] `dynamic_partition_pruning::read_table` errors on single-file Parquet datasets
- [BUG] [GPU Error Bug] "SELECT (('b햦]D7Jr31')||((CASE 'Kx}lzJ^' WHEN <column> THEN '' END ))) FROM <table>" brings Error
- [BUG] [GPU Error Bug] "SELECT (((<column> LIKE '\뽞^' ESCAPE 'M')) IS NULL) FROM <tables>" brings Error
- [BUG] [GPU Error Bug] "SELECT -2613 FROM <table> HAVING (<TIMESTAMP> NOT BETWEEN <TIMESTAMP> AND MAX(<TIMESTAMP>))" brings Error HOT 1
- ⚠️ Upstream CI Dask failed ⚠️
- ⚠️ Upstream CI failed ⚠️ HOT 1
- Push pre-built Python 3.11 wheels [ENH] HOT 2
- Spatial SQL Support HOT 1
- [BUG] `dask-sql` fails to import with `dask-expr` enabled HOT 6
- [BUG] on Starter example HOT 1
- ⚠️ Upstream CI failed ⚠️
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 dask-sql.