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.

Sign up for GitHub

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

Jump to bottom

Implement all simple expression operators #11

Open
nils-braun opened this issue Aug 27, 2020 · 1 comment
Open

Implement all simple expression operators #11

nils-braun opened this issue Aug 27, 2020 · 1 comment
Labels
good first issue Good for newcomers

Comments

@nils-braun
Copy link
Collaborator

nils-braun commented Aug 27, 2020 •
edited

The RexCallPlugin currently can only handle the most common expressions (binary operations, or and and). There are many more of them that could and should be implemented.
@nils-braun nils-braun mentioned this issue Aug 28, 2020
Merged
This was referenced Sep 18, 2020
Merged
Merged
@nils-braun
Copy link
Collaborator Author

nils-braun commented Sep 21, 2020 •
edited

Set of operations, which calcite understands:

Comparison Operations

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, [WIP] Added a cast operator #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

Conditional Operations

  • CASE
  • NULLIF
  • COALESCE

nils-braun added a commit that referenced this issue Sep 22, 2020
@nils-braun
Added many math functions, related to #11
3585cec
@nils-braun nils-braun mentioned this issue Sep 22, 2020
Merged
nils-braun added a commit that referenced this issue Sep 22, 2020
@nils-braun
Added many math functions (#42)
f46bf51 
* Added many math functions, related to #11

* Code formatting
@nils-braun nils-braun changed the title Implement more expression operators Implement all expression operators Sep 24, 2020
@nils-braun nils-braun added the good first issue Good for newcomers label Sep 24, 2020
@nils-braun nils-braun changed the title Implement all expression operators Implement all simple expression operators Sep 24, 2020
@nils-braun nils-braun mentioned this issue Oct 1, 2020
Merged
@nils-braun nils-braun mentioned this issue Oct 14, 2020
Merged
@Yuhuishishishi Yuhuishishishi mentioned this issue Nov 29, 2020
Merged
pawelbielski added a commit to pawelbielski/dask-sql that referenced this issue Feb 14, 2021
@pawelbielski
Implement first version of TIMESTAMPDIFF dask-contrib#11
d35b9ec 
Implement operators reinterpret and /int. Currently TIMESTAMPDIFF
 returns result in ns regardless of the INTERVAL specified.
This needs to be fixed.
charlesbluca added a commit to charlesbluca/dask-sql that referenced this issue Sep 30, 2021
@charlesbluca
Define GPU marker in pytest.ini (dask-contrib#11)
ffbafe1
charlesbluca added a commit to charlesbluca/dask-sql that referenced this issue Dec 14, 2021
@charlesbluca
Define GPU marker in pytest.ini (dask-contrib#11)
cf414c0
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
good first issue Good for newcomers
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@nils-braun