You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
SELECT 0.5*max(Mvir) as m from MDR1.BDMV where snapnum=85
Query plan
-- CALL paquExec('SELECT 0.5 * MAX AS `_0__5_*_max_Mvir_` FROM MDR1.BDMV WHERE ( `snapnum` = 85 ) ', 'aggregation_tmp_16656224')
-- USE spider_tmp_shard
-- SET @i=0-- CREATE TABLE cosmosim_user_kristin.`2014-11-28-14-08-18-8760` ENGINE=MyISAM SELECT @i:=@i+1 AS `row_id`, `_0__5_*_max_Mvir_` FROM `aggregation_tmp_16656224`
-- CALL paquDropTmp('aggregation_tmp_16656224')
Error
Unknown column 'MAX' in 'field list'
A query like SELECT max(Mvir) as m ... works fine, I just encounter problems if I add the multiplication or subtract something etc.
The text was updated successfully, but these errors were encountered:
Query
Query plan
Error
Unknown column 'MAX' in 'field list'
A query like
SELECT max(Mvir) as m ...
works fine, I just encounter problems if I add the multiplication or subtract something etc.The text was updated successfully, but these errors were encountered: