David Bryson
09/14/2023, 5:19 PM203 sliding_window = Slide.over(lit(4).hours).every(lit(20).minutes).on(col("event_time")).alias("w")
204
205 mean_table = input_table.window(sliding_window) \
206 .group_by(col("device_id"), col('w')) \
207 .select(col("device_id"), vector_mean(col('sensor_mm'), col('w')), col('w').rowtime.alias("end_time"))
When I pass in the time column I get SQL errors like the following:
py4j.protocol.Py4JJavaError: An error occurred while calling o8.executeSql.
: java.lang.RuntimeException: Not support visitor: org.apache.flink.table.planner.plan.utils.ExpandTableScanShuttle$ExpandTableScanInSubQueryShuttle@6d09d4a4I"m not sure what the exception is trying to tell me, but I'd like to process this window with the value and the time.
David Bryson
09/14/2023, 5:20 PMDavid Bryson
09/14/2023, 5:45 PMvector_mean(col('sensor_mm'), col('end_time'))
Which I'm not sure is entirely what i want