Uploaded image for project: 'Kylin'
  1. Kylin
  2. KYLIN-639

Get "Table 'xxxx' not found while executing SQL" error after a cube be successfully built

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: v0.7.1
    • Fix Version/s: v0.7.1
    • Component/s: Query Engine
    • Labels:
      None

      Description

      After building a cube successfully, execute a SQL on the "query" tab, but got error like:

      rom line 1, column 86 to line 1, column 96: Table 'KYLIN_SALES' not found while executing SQL: "select cal_dt, sum(price) as total_selled, count(distinct seller_id) as sellers from kylin_sales group by cal_dt order by cal_dt LIMIT 50000"

      In the left table tree of "query" tab, the tables that defined in the cube wasn't displayed as well; But if restart the kylin server, everything goes well.

        Attachments

          Activity

            People

            • Assignee:
              shaofengshi Shao Feng Shi
              Reporter:
              shaofengshi Shao Feng Shi
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 24h
                24h
                Remaining:
                Remaining Estimate - 24h
                24h
                Logged:
                Time Spent - Not Specified
                Not Specified