duneanalytics/harmonizer

Issues

• [BUG] Error: (summary of your error message)

  #97 opened 8 months ago by mividtim
  0

• Annotate queries with column types?

  #50 opened 8 months ago by vegarsti
  2

• cast(col as timestamp) should be from_unixtime(col) when col is numeric

  #56 opened 8 months ago by vegarsti
  0

• Adds `NULLS FIRST` to `ORDER BY`s from Spark

  #90 opened 8 months ago by vegarsti
  1

• Redundant casts in string CONCAT

  #91 opened 8 months ago by vegarsti
  4

• [BUG] Error: Cannot apply operator: varbinary = varchar(42)

  #95 opened a year ago by andrewhong5297
  1

• `SELECT generate_series()` in Postgres should become `SELECT UNNEST(SEQUENCE...` in DuneSQL

  #88 opened a year ago by vegarsti
  1

• Array indexes in Postgres should not be incremented

  #86 opened a year ago by vegarsti
  1

• `TRY_CAST('1 day' AS INTERVAL)` should be `interval '1' day`

  #51 opened a year ago by vegarsti
  2

• Translate Postgres interval casts to interval literals

  #80 opened a year ago by vegarsti
  0

• Array and struct access operator is null safe in Spark, but not in Trino

  #75 opened a year ago by vegarsti
  0

• Spark requires length when casting to VARCHAR, but doesn't truncate string

  #74 opened a year ago by vegarsti
  2

• Trino does truncating integer division, Spark does not

  #72 opened a year ago by vegarsti
  0

• Should convert to_utc_timestamp -> to_unixtime

  #65 opened a year ago by vegarsti
  1

• `cast(x as type)` should have alias `x`

  #55 opened a year ago by vegarsti
  0

• Postgres group aggregates

  #53 opened a year ago by vegarsti
  0

• datediff -> DATE_DIFF

  #39 opened a year ago by andrewhong5297
  6

• Another hex string leading zero bug

  #48 opened a year ago by vegarsti
  0

• Leading zeros are stripped from hex

  #41 opened a year ago by vegarsti
  3

• table names with double quotes not properly translated

  #40 opened a year ago by MarcoVugts
  3

• Handle implicit conversions of Spark and Postgres types

  #30 opened a year ago by vegarsti
  0

• Spark's to_date(s) is handled badly

  #20 opened a year ago by vegarsti
  2

• Automatically translate '0x...' strings into 0x VARBINARY literals (i.e. remove quotes)

  #22 opened a year ago by vegarsti
  1

• Handle Spark's posexplode

  #21 opened a year ago by vegarsti
  0

• Translate Spark's explode into an unnest with a CROSS JOIN

  #18 opened a year ago by vegarsti
  0

• Parameters sometimes get botched

  #13 opened a year ago by vegarsti
  0