pyspark-ai icon indicating copy to clipboard operation
pyspark-ai copied to clipboard

Can you retrieve the SQL query?

Open waddahAldrobi opened this issue 1 year ago • 1 comments

We have been playing around with a tool for a bit, super cool! But is there a way to get the SQL query to help us debug?

We noticed that sometimes it's not using the partitioned columns, which doesn't scale well.

waddahAldrobi avatar Jul 10 '23 16:07 waddahAldrobi

@waddahAldrobi Thanks for the inputs! For now, you can enable the verbose mode. For example, spark_ai=SparkAI(verbose=true) and there will be logs about the generated code. I am also working on the code completion notebook magic.

gengliangwang avatar Jul 10 '23 22:07 gengliangwang

Woah that's awesome! Thank you!

waddahAldrobi avatar Jul 16 '23 08:07 waddahAldrobi