[#MCOL-3668] "unknown column data type" when using CEJ in a Window Function

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.

[MCOL-3668] "unknown column data type" when using CEJ in a Window Function Created: 2019-12-11 Updated: 2023-03-06 Resolved: 2023-03-06
Status:	Closed
Project:	MariaDB ColumnStore
Component/s:	N/A
Affects Version/s:	1.4.1
Fix Version/s:	Icebox

[MCOL-3668] "unknown column data type" when using CEJ in a Window Function Created: 2019-12-11 Updated: 2023-03-06 Resolved: 2023-03-06