TEXT is not supported in temporary table


#1

Hi!

I’m trying to run this query:

select * from
(SELECT * FROM pb) em_daily_balance
INNER JOIN currencies
ON em_daily_balance.key_cry = currencies.unified_key
and em_daily_balance.prt_flg = 'M’
AND em_daily_balance.balance <> 0
AND em_daily_balance.key_act NOT LIKE '6%'
INNER JOIN
(SELECT * FROM promprom_dm
WHERE prt_flg = ‘M’) dm
ON em_daily_balance.key_act = dm.key_act limit 5;

but getting exception:
Exception: TEXT is not supported in temporary table.

mapd_server.ERROR only says:
E1208 10:55:23.979027 26726 MapDHandler.cpp:2912] Exception: TEXT is not supported in temporary table.

What could be a possible cause of this exception?

I’m running on version 3.2.3.


#2

Hi

Please upgrade to v3.3.1 and let us know if the issue persists

Regards