Re: ERROR: GROUP BY position 0 is not in select list , when using catalyst parser

Unsubscribe On Wed, Sep 18, 2024, 09:39 Sudhanshu wrote: > unsubscribe > > On Wed, Sep 11, 2024 at 1:51 PM Rommel Holmes > wrote: > >> i am using spark 3.3.1 >> here is the sql_string to query a ds partitioned table >> >> ``` >> SELECT >> '2024-09-09' AS ds, >> AVG(v1) AS avg_v1, >> AVG(v2) A

Re: ERROR: GROUP BY position 0 is not in select list , when using catalyst parser

unsubscribe On Wed, Sep 11, 2024 at 1:51 PM Rommel Holmes wrote: > i am using spark 3.3.1 > here is the sql_string to query a ds partitioned table > > ``` > SELECT > '2024-09-09' AS ds, > AVG(v1) AS avg_v1, > AVG(v2) AS avg_v2, > AVG(v3) AS avg_v3 > FROM schema.t1 > WHERE ds = '2024-09-09' >