Hi! I see. So you're running a streaming job. "select" in a streaming job will only produce visible data when you enable checkpointing (this is due to the exactly-once guarantee of Flink), see [1] for more detail. See [2] on how to enable checkpointing for Flink SQL.
Generated code are also in the logs if you set the appropriate logging level. [1] https://nightlies.apache.org/flink/flink-docs-master/docs/dev/table/sql/queries/overview/#execute-a-query [2] https://stackoverflow.com/a/65681975 dz902 <dz9...@gmail.com> 于2022年3月14日周一 11:08写道： > Hi Caizhi, > > Thanks for the quick reply. I was just running a simple "SELECT * FROM > tbl_name" against a table with Kafka connector, but no data showed up and > no errors. > > Where can I find the generated code if I'm using SQL client? > > Thanks! > > > On Mon, Mar 14, 2022 at 10:58 AM Caizhi Weng <tsreape...@gmail.com> wrote: > >> Hi! >> >> For stages and logs you can refer to the web UI. For generated code set >> logging level of org.apache.flink.table.runtime.generated.CompileUtils to >> debug. >> >> What query are you running? If possible can you share your SQL in the >> mailing list? >> >> dz902 <dz9...@gmail.com> 于2022年3月14日周一 10:42写道： >> >>> Hi, >>> >>> I'm trying to debug SQL queries, from SQL client or Zeppelin notebook >>> (job submitted to remote cluster). >>> >>> I have a query not getting any data. How do I debug? Can I see the >>> actual code generated from the SQL query? Or is it possible to show all the >>> stages, actions or logs generated by the query? >>> >>> Thanks, >>> Dai >>> >>
