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

Unable to join ColumnStore table w/ InnoDb

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Blocker
    • Resolution: Cannot Reproduce
    • None
    • Icebox
    • N/A
    • None

    Description

      I am getting this error

      May 11 12:40:58 localhost joblist[4346]: 58.325928 |1295|0|0| C 05 CAL0000: CrossEngineStep::execute() caught Throw location unknown (consider using BOOST_THROW_EXCEPTION)#012Dynamic exception type: boost::exception_detail::clone_impl<boost::exception_detail::error_info_injector<boost::bad_any_cast> >#012std::exception::what: boost::bad_any_cast: failed conversion using boost::any_cast

      when trying to join these two tables on the "SkuCode" column.

      CREATE TABLE `lineItemSalesClosed` (
      ...
      `SkuCode` varchar(32) DEFAULT NULL,
      ...
      ) ENGINE=Columnstore DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

      CREATE TABLE `sku` (
      `SkuId` varchar(36) NOT NULL,
      `SkuCode` varchar(32) NOT NULL,
      ...
      PRIMARY KEY (`SkuCode`),
      ...
      USING BTREE
      ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

      Query:
      select *
      from
      views.lineItemSalesClosed lisc
      left join views.sku s on lisc.SkuCode = s.SkuCode

      Attachments

        Activity

          People

            Unassigned Unassigned
            ehowlett-vip Evan Howlett
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.