Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Do
-
1.4.1
-
None
Description
Tables (based on DBT3):
In test DB:
CREATE TABLE `nation` ( |
`n_nationkey` int(11) NOT NULL, |
`n_name` char(25) DEFAULT NULL, |
`n_regionkey` int(11) DEFAULT NULL, |
`n_comment` varchar(152) DEFAULT NULL, |
PRIMARY KEY (`n_nationkey`) |
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
In dbt3 DB:
CREATE TABLE `nation` ( |
`n_nationkey` int(11) DEFAULT NULL, |
`n_name` char(25) DEFAULT NULL, |
`n_regionkey` int(11) DEFAULT NULL, |
`n_comment` varchar(152) DEFAULT NULL |
) ENGINE=Columnstore DEFAULT CHARSET=latin1 |
The following happens in logs:
Dec 11 19:40:42 ip-172-31-4-94 ExeMgr[6172]: 42.755162 |856|0|0| D 16 CAL0041: Start SQL statement: SELECT cn.n_name, tn.n_name, tn.n_regionkey FROM #015#012(SELECT n_name, n_nationkey from dbt3.nation ) AS cn, #015#012(select sum(n_regionkey) over () as skey, n_name, n_nationkey, n_regionkey from test.nation) AS tn #015#012WHERE cn.n_nationkey=tn.n_nationkey; |test|
|
|
|
Dec 11 19:40:42 ip-172-31-4-94 joblist[6172]: 42.759119 |0|0|0| I 05 CAL0000: QUERY to foreign engine: SELECT `n_name`, `n_nationkey`, `n_regionkey` FROM `nation`
|
|
|
Dec 11 19:40:42 ip-172-31-4-94 joblist[6172]: 42.759344 |856|0|0| C 05 CAL0000: convertColumnData: unknown column data type.
|