SMB joins not working on partitioned queries

2020-10-23 Thread Pau Tallada
Hi all, I'm trying to understand (for the last months) why SMB joins (the most efficient ones) are unable to work with partitions. All my being tells me it should work but, it doesn't. I would really, really, (really!) appreciate any insights on this problem. First, the working example without pa

Re: Hive SQL extension

2020-10-23 Thread Pau Tallada
Hi all, I do not know if that may be of interest to you, but there are other projects that could benefit from this. For instance, ADQL (Astronomical Data Query Language) is a SQL-like language that defines some higher-level f