kylin-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "liubo@fcyun.com" <li...@fcyun.com>
Subject SQL problems: Expression 'C.ENABLE_DATE' is not being grouped
Date Tue, 31 Oct 2017 03:58:38 GMT
Hi all,
    My requirement is: 
    enable_date in t_store table means the first day the store registered in our system, it's
a new store , otherwise it's a old store.
    so, I write this SQL, "case when c.enable_date =d.dd then 1 else 0 end is_new_store "

    but, it's wrong, the error is: Expression 'C.ENABLE_DATE' is not being grouped

    How to solve this, and ideals? thanks ~





liubo@fcyun.com
Mime
View raw message