Not equal to operator in mapd


#1
FROM m73edc71c_7568_4aa1_9149_49dbd62a810a 
WHERE m_used_flg != '1' AND m_object_type = 'table' GROUP BY m_object_name, m_object_name ORDER BY m_total_table_meg DESC
 LIMIT 10```

Unexpected error occured: Exception: Parse failed: Bang equal '!=' is not allowed under the current SQL conformance level

#2

Hi @nagulan,

You have to use <> for inequalities because in sql99 the != isn’t allowed and