Re: [ANNOUNCE] Apache Hive 4.0.0 Released

2024-04-02 Thread Pau Tallada
; > For Hive release details and downloads, please visit: > > https://hive.apache.org/downloads.html > > > > Hive 4.0.0 Release Notes are available here: > > > https://issues.apache.org/jira/secure/ReleaseNote.jspa?version=12343343=Text=12310843 > > > > We would like to thank the many contributors who made this release > > possible. > > > > Regards, > > > > The Apache Hive Team > > -- -- Pau Tallada Crespí Departament de Serveis Port d'Informació Científica (PIC) Tel: +34 93 170 2729 --

TABLESAMPLE with buckets not working, it does not prune input

2024-01-24 Thread Pau Tallada
_table TABLESAMPLE(0.1 PERCENT) => *25 tasks* * HDFS_BYTES_READ = 45484944 (45M)* Please, any hint would be greatly appreciated! [1] https://cosmohub.pic.es [2] https://cwiki.apache.org/confluence/display/hive/languagemanual+sampling -- ------ Pau Tallada Crespí De

Re: Hive SQL extension

2020-10-23 Thread Pau Tallada
; >> I am looking for a way to rewrite the original (Hive syntactically not >> correct) query to a new (syntactically correct) one. >> >> I was checking the hooks as a possible solution, but I have found that: >> >>- HiveDriverRunHook.preDriverRun can get the

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