Tracking: polars support

[jetjinser]

Polars is a DataFrame interface on top of an OLAP Query Engine implemented in Rust using Apache Arrow Columnar Format as the memory model.

Works normally with general use. However, when if_table_exist is specified as replace in the parameter of DataFrame.write_database, the sql query that risingwave currently does not support will be used.

• pg_sequence (not pg_sequences)

  • 2954

  • 15934

• json_build_object (not jsonb_build_object): https://www.postgresql.org/docs/16/functions-json.html#FUNCTIONS-JSON-CREATION-TABLE
  • Considering that RisingWave does not have a json datatype, this problem may need to be solved in other ways.

[neverchanje]

Related issue: https://github.com/risingwavelabs/sqlalchemy-risingwave/pull/29 datapolars requires upgrading sqlalchemy version to v2.

[github-actions[bot]]

This issue has been open for 60 days with no activity. Could you please update the status? Feel free to continue discussion or close as not planned.