Any way to support query hints in pyspark backend?

[ted0928]

Hi there, I am trying to partitioni data in specific way, like spark sql below:

SELECT /*+ COALESCE(3) */ * FROM t;

SELECT /*+ REPARTITION(3) */ * FROM t;

SELECT /*+ REPARTITION(c) */ * FROM t;

SELECT /*+ REPARTITION(3, c) */ * FROM t;

SELECT /*+ REPARTITION_BY_RANGE(c) */ * FROM t;

SELECT /*+ REPARTITION_BY_RANGE(3, c) */ * FROM t;

SELECT /*+ REBALANCE */ * FROM t;

SELECT /*+ REBALANCE(3) */ * FROM t;

SELECT /*+ REBALANCE(c) */ * FROM t;

SELECT /*+ REBALANCE(3, c) */ * FROM t;

So there any way to implement or mock the operation？

[cpcloud]

There's no Ibis-native way to express query hints at the moment, however, you can always build an expression using con.sql or table.sql and that SQL can itself contain query hints.