so yes, it is working in hive and not in impala. We are using impala, what can we do? ... View more

  Strange, see the attached screenshot.  What am I doing wrong? Are the cloudera/impala versions ok? You are actually using hive, I use Impala...? ... View more

The following select query is not working   CREATE TABLE TEMP_TABLE_CELL (BSC BIGINT, CELL_PRIMARY BIGINT); CREATE TABLE MAIN_CALLS (CALL_UNIQUE_ID BIGINT, IMSI BIGINT, IMEI BIGINT, BSC BIGINT, CELL_PRIMARY BIGINT); SELECT * FROM MAIN_CALLS CALLS where (BSC in (4,5) or exists (select 1 from TEMP_TABLE_CELL tt where tt.bsc = bsc and tt.cell_primary = cell_primary)); ... View more

Well, just checked now and I get quite the same error: AnalysisException: EXISTS/NOT EXISTS subqueries in OR predicates are not supported. I am using : ... or exists (select 1 from TEMP_TABLE_CELL tt where tt.bsc = bsc ) when using "and" it works fine.   Cloudera version: [yigal@d50q-mtr-app13 ~]$ ls -l /opt/cloudera/parcels/ total 0 lrwxrwxrwx. 1 root root 33 Apr 19 13:11 CDH -> CDH-7.1.9-1.cdh7.1.9.p14.53489573 drwxr-sr-x. 11 root root 119 Nov 3 2023 CDH-7.1.7-1.cdh7.1.7.p2046.46875634 drwxr-sr-x. 11 root root 119 May 17 2024 CDH-7.1.9-1.cdh7.1.9.p14.53489573 ... View more

Thank you! I will check it ... View more

Hi, Was this implemented already in later versions? ... View more