Re: Expression push down from Join Node to below node.

2025-05-26 Thread Shubhankar Anand Kulkarni
egards Shubhankar K ZLabs-CStore On Thu, 22 May 2025 14:21:51 +0530 Andy Fan wrote --- Shubhankar Anand Kulkarni < mailto:shubhankar...@zohocorp.com > writes: Hi, > SELECT sensitive_data1, column1 FROM benchmark_encytion AS t1 LEFT JOIN ( > SELECT aes256_cbc_de

Re: Expression push down from Join Node to below node.

2025-05-28 Thread Shubhankar Anand Kulkarni
Can you please resolve the doubt mentioned in the below thread? Thanks &Regards Shubhankar K Zlabs-CStore Member of Technical Staff, Zoho On Mon, 26 May 2025 16:58:12 +0530 Shubhankar Anand Kulkarni wrote --- Hi Andy, Thanks for the reply. As suggested, I tried using CTE w

Expression push down from Join Node to below node.

2025-05-22 Thread Shubhankar Anand Kulkarni
Hi Hackers,   While dealing with a few queries, I noticed that when the join expression (join clause) is used in projection as well, the expression will be computed twice. For a better understanding, please take reference from the following example: SELECT sensitive_data1, column1 FROM benchmark

Re: Expression push down from Join Node to below node.

2025-06-19 Thread Shubhankar Anand Kulkarni
Hi, Thanks for your valuable feedback on the patch. Will check on the cases mentioned by you and do the needful. Best Regards Shubhankar K. Member Technical Staff Zoho Corporation On Sat, 14 Jun 2025 09:03:25 +0530 Andy Fan wrote --- Shubhankar Anand Kulkarni

Re: Expression push down from Join Node to below node.

2025-06-13 Thread Shubhankar Anand Kulkarni
and the approach we're taking to optimize the query execution. If you have any further questions or suggestions, please feel free to share. Thanks and Regards Shubhankar K. ZLabs-CStore Member of Technical Staff, Zoho On Wed, 28 May 2025 23:53:46 +0530