Left Join Not working


#1

I am trying to execute the following Left Join query:

select .* from Table_1 h left join Table_2 d on h.col3 = d.id ;

and get the following Output: Exception: Hash join failed, reason: Equijoin types must be identical, found: CHAR, TEXT

However the when I use \d table name the data types are similar:

CREATE TABLE Table_1 (
id TEXT ENCODING DICT(32),
col0 TEXT ENCODING DICT(32),
col1 TEXT ENCODING DICT(32),
col2 TEXT ENCODING DICT(32),
col3 TEXT ENCODING DICT(32))

CREATE TABLE Table_2 (
id TEXT ENCODING DICT(32),
description TEXT ENCODING DICT(32),
name TEXT ENCODING DICT(32))

Please resolve this issue


#2

Hi,

Can you please confirm you are running a recent version of MapD.

This query should be failing, with an entirely different error, due to the .* select items?

Regards