Uploaded image for project: 'Flink'
  1. Flink
  2. FLINK-16301

Annoying "Cannot find FunctionDefinition" messages with SQL for f_proctime or =

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    Description

      When running the following SQL query

      SELECT
          D1.col1 AS A,
          D1.col2 AS B,
          D1.col3 AS C,
          D1.col4 AS D,
          D1.col5 AS E,
          D2.col1 AS F,
          D2.col2 AS G,
          D2.col3 AS H,
          D2.col4 AS I,
          D2.col5 AS J,
          D3.col1 AS K,
          D3.col2 AS L,
          D3.col3 AS M,
          D3.col4 AS N,
          D3.col5 AS O,
          D4.col1 AS P,
          D4.col2 AS Q,
          D4.col3 AS R,
          D4.col4 AS S,
          D4.col5 AS T,
          D5.col1 AS U,
          D5.col2 AS V,
          D5.col3 AS W,
          D5.col4 AS X,
          D5.col5 AS Y
      FROM
          fact_table,
          LATERAL TABLE (dimension_table1(f_proctime)) AS D1,
          LATERAL TABLE (dimension_table2(f_proctime)) AS D2,
          LATERAL TABLE (dimension_table3(f_proctime)) AS D3,
          LATERAL TABLE (dimension_table4(f_proctime)) AS D4,
          LATERAL TABLE (dimension_table5(f_proctime)) AS D5
      WHERE
          fact_table.dim1     = D1.id
          AND fact_table.dim2 = D2.id
          AND fact_table.dim3 = D3.id
          AND fact_table.dim4 = D4.id
          AND fact_table.dim5 = D5.id
      

      with the Blink planner, it prints a log of bogus warnings about unknown functions for things like f_proctime or = at INFO level which should be DEBUG level at least in order not to bother the users with it. The messages I got are:

      13:33:59,590 INFO  org.apache.flink.table.module.ModuleManager                   - Cannot find FunctionDefinition f_proctime from any loaded modules
      13:33:59,641 INFO  org.apache.flink.table.module.ModuleManager                   - Cannot find FunctionDefinition f_proctime from any loaded modules
      13:33:59,644 INFO  org.apache.flink.table.module.ModuleManager                   - Cannot find FunctionDefinition f_proctime from any loaded modules
      13:33:59,647 INFO  org.apache.flink.table.module.ModuleManager                   - Cannot find FunctionDefinition f_proctime from any loaded modules
      13:33:59,650 INFO  org.apache.flink.table.module.ModuleManager                   - Cannot find FunctionDefinition f_proctime from any loaded modules
      13:33:59,662 INFO  org.apache.flink.table.module.ModuleManager                   - Cannot find FunctionDefinition = from any loaded modules
      13:33:59,665 INFO  org.apache.flink.table.module.ModuleManager                   - Cannot find FunctionDefinition = from any loaded modules
      13:33:59,666 INFO  org.apache.flink.table.module.ModuleManager                   - Got FunctionDefinition and from module core
      13:33:59,667 INFO  org.apache.flink.table.module.ModuleManager                   - Cannot find FunctionDefinition = from any loaded modules
      13:33:59,668 INFO  org.apache.flink.table.module.ModuleManager                   - Got FunctionDefinition and from module core
      13:33:59,669 INFO  org.apache.flink.table.module.ModuleManager                   - Cannot find FunctionDefinition = from any loaded modules
      13:33:59,670 INFO  org.apache.flink.table.module.ModuleManager                   - Got FunctionDefinition and from module core
      

      Attachments

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            jark Jark Wu
            nkruber Nico Kruber
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 20m
                20m

                Issue deployment