Hi Team,
Have below scenario where reflection on PDS is not used for accelerating VDS query;
Created a reflection on PDS (HDFS source) and a VDS from HDFS source & PostgreSQL source (by joining both). But reflection created on PDS is not used by VDS.
Query profile for PDS (reflection used)
c010d4ad-89d2-471a-9089-a52d716d3516.zip (72.0 KB)
Query profile for VDS (reflection not used)
87bc66dd-401a-44f2-9152-56f93071f39d.zip (89.1 KB)
Reflection query profile
52974b97-2e54-463e-b034-0dd7665fb7f3.zip (95.4 KB)
In reflection used partitioned & sorted functionality. In query filters put on partitioned column and order by on sorted column. HDFS data is in parquet format only but in PDS query, execution time decrease by 50% after use of reflection but in VDS reflection not used for same filter condition.
Any insight will be helpful.
Thanks.