Description
Error
SQL Error: java.lang.UnsupportedOperationException: Cannot evaluate expression: scalar-subquery
Then query a partitioed table based on a parquet file then filter by partition column by scalar subquery.
Query to reproduce:
CREATE TABLE test_prc_bug ( id_value string ) partitioned by (id_type string) location '/tmp/test_prc_bug' stored as parquet; insert into test_prc_bug values ('1','a'); insert into test_prc_bug values ('2','a'); insert into test_prc_bug values ('3','b'); insert into test_prc_bug values ('4','b'); select * from test_prc_bug where id_type = (select 'b');
If table in ORC format it works fine