Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-358

Error in Cross Engine Join Query

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 1.0.3
    • Icebox
    • ExeMgr
    • None
    • 2016-22, 2016-23

    Description

      I am getting below error on performing cross engine query in mariadb columnstore.
      ERROR 1815 (HY000): Internal error: fatal error executing query in crossengine client lib(17)(17)

      My query is :-
      SELECT a.id stoppage_id, a.machine stoppage_machine, MIN(kf.timestamp) stoppage_end FROM kpi_fact kf, ( SELECT sr.id, sr.machine, sr.start_time FROM stoppage_reason sr, stoppage_configuration sc WHERE sr.start_time BETWEEN '2016-10-13 16:05:15' AND '2016-10-13 16:05:15' AND sr.end_time IS NULL AND sc.machine = sr.machine AND sc.with_end_timestamp = false) a WHERE a.machine = kf.machine AND LOWER(kf.kpi_name) = 'machine_up_status' AND kf.kpi_value_integer = 1 AND kf.global_parameter = 0 AND kf.timestamp > a.start_time GROUP BY a.machine, a.id ;

      In the above query there is cross engine join between :-
      kpi_fact(Columnstore) ,stoppage_reason and stoppage_master(MyISAM)

      I am getting ERROR 1815 (HY000): Internal error: fatal error executing query in crossengine client lib(17)(17) because inner select( SELECT sr.id, sr.machine, sr.start_time FROM stoppage_reason sr, stoppage_configuration sc WHERE sr.start_time BETWEEN '2016-10-13 16:05:15' AND '2016-10-13 16:05:15' AND sr.end_time IS NULL AND sc.machine = sr.machine AND sc.with_end_timestamp = false results in empty set.

      When i insert some dummy data in this table :- insert into stoppage_configuration values (1, 'Bleh',0,1,1,1,1);
      Below Query Starts working fine
      SELECT a.id stoppage_id, a.machine stoppage_machine, MIN(kf.timestamp) stoppage_end FROM kpi_fact kf, ( SELECT sr.id, sr.machine, sr.start_time FROM stoppage_reason sr, stoppage_configuration sc WHERE sr.start_time BETWEEN '2016-10-13 16:05:15' AND '2016-10-13 16:05:15' AND sr.end_time IS NULL AND sc.machine = sr.machine AND sc.with_end_timestamp = false) a WHERE a.machine = kf.machine AND LOWER(kf.kpi_name) = 'machine_up_status' AND kf.kpi_value_integer = 1 AND kf.global_parameter = 0 AND kf.timestamp > a.start_time GROUP BY a.machine, a.id ;

      Thanks,
      Saurav

      Attachments

        Activity

          People

            dthompson David Thompson (Inactive)
            kssonu4u Kumar Saurav Sonu
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.