Re: Issue with correlated subqueries being case-sensitive

yes sounds like a bug in parser. I am using Hive 2 hive> select count(1) from smallsales where exists(select 1 from sales_staging where smallsales.PROD_ID = sales_staging.PROD_ID); FAILED: SemanticException [Error 10250]: Line 1:59 Invalid SubQuery expression 'PROD_ID': For Exists/Not Exists opera

Re: Issue with correlated subqueries being case-sensitive

Hi, It is just a string literal I used as an example. Replacing it with "1" does not affect the issue in any way Best regards, /jack On 04/29/2016 03:24 PM, Mich Talebzadeh wrote: Why not just try the standard way SELECT * FROM P WHERE EXISTS(SELECT 1 FROM B WHERE P.ID = B.ID

Re: Issue with correlated subqueries being case-sensitive

Why not just try the standard way SELECT * FROM P WHERE EXISTS(SELECT 1 FROM B WHERE P.ID = B.ID) You don't need '*' that is not standard SQL as far as I know HTH Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw

Issue with correlated subqueries being case-sensitive

Hi, I am having an issue with correlated sub-queries such as the following SELECT * FROM P WHERE EXISTS (SELECT '*' FROM B WHERE P.ID = B.ID) Both Beeline and Java JDBC client falied with the following message Error: Error while compiling statement: FAILED: SemanticException [Error 10250]: Li