Details
-
Bug
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Cannot Reproduce
-
None
-
None
-
OS: 18.04.6 LTS (Bionic Beaver)
CPU: Intel(R) Xeon(R) Platinum 8272CL CPU @ 2.60GHz
Single node instance
Columnstore.xml:
<CrossEngineSupport>
<Host>localhost</Host>
<Port>3306</Port>
<User>correct_user</User>
<Password>correct_password</Password>
<TLSCA/>
<TLSClientCert/>
<TLSClientKey/>
</CrossEngineSupport>OS: 18.04.6 LTS (Bionic Beaver) CPU: Intel(R) Xeon(R) Platinum 8272CL CPU @ 2.60GHz Single node instance Columnstore.xml: <CrossEngineSupport> <Host>localhost</Host> <Port>3306</Port> <User>correct_user</User> <Password>correct_password</Password> <TLSCA/> <TLSClientCert/> <TLSClientKey/> </CrossEngineSupport>
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