You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@gluten.apache.org by "shuai-xu (via GitHub)" <gi...@apache.org> on 2024/09/03 08:36:36 UTC

[I] [CH] throw exception when agg grouping has same attributes [incubator-gluten]

shuai-xu opened a new issue, #7096:
URL: https://github.com/apache/incubator-gluten/issues/7096

   ### Backend
   
   CH (ClickHouse)
   
   ### Bug description
   
   when run sql `select
   days, rtime, guest_uid,owner_uid, day1
   from
   (
    select
   day1 as days, rtime, guest_uid, owner_uid, day1
   from
   (
    select distinct coalesce(day, "today") as day1,rtime,uid as guest_uid
    ,if(event.event_info['showeruid'] is null or event.event_info['showeruid']='',0,cast(event.event_info['showeruid'] as bigint) ) as owner_uid
    from xxx
    where day = '${day1}'
   ) t1 ) t2 group by days, rtime, guest_uid, owner_uid, day1 limit 10`, it throws Missmatch output schema exception
   
   ### Spark version
   
   Spark-3.3.x
   
   ### Spark configurations
   
   _No response_
   
   ### System information
   
   _No response_
   
   ### Relevant logs
   
   _No response_


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@gluten.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@gluten.apache.org
For additional commands, e-mail: commits-help@gluten.apache.org


Re: [I] [CH] throw exception when agg grouping has same attributes [incubator-gluten]

Posted by "zzcclp (via GitHub)" <gi...@apache.org>.
zzcclp closed issue #7096: [CH] throw exception when agg grouping has same attributes
URL: https://github.com/apache/incubator-gluten/issues/7096


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@gluten.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@gluten.apache.org
For additional commands, e-mail: commits-help@gluten.apache.org