Where Clause not working only for a particular field on Select statement

[Sai33]

Hello Everyone,

I'm facing a very strange scenario. I have a table with 5 fields partitiontimestamp, [year], [month], [day], [hour]

When i try to load the data with a Where condition on [year], [month], [day], [hour] it loads fine and generates the expected data.

But, when i try to load data with filter on partitiontimestamp it says 'Field Not Found'. Actually the filed is existing on the Source table. 

Please see below snapshots for a better understanding

Runs successfully when other fields are used are filtersData Model Viewer after successful loadError when partitiontimestamp has been used in Filterpartitiontimestamp used as filter

[lorenzoconforti]

The error might actually come from the preceding load; just try if this errors and, if it works, check if any data is being loaded. What might be happening is that the filter is working but the condition not being met so the where clause returns no record

[e_condis_derived_location]:
SELECT
partitiontimestamp,
[year],
[month],
[day],
[hour]
FROM [condis_source].[e_condis_derived_location]
Where partitiontimestamp='2019091709';

[Sai33 · Accepted solution]

Thanks everyone for your valuable inputs.

My Datasource here was a Hive DataLake and the User which was fetching data from there was not having enough rights to execute the exact where condition i was looking for (But, was able to execute the other Where condition 😲)

So, i had to add both these setting to the Qlik - Hive connection 

SET hive.execution.engine = tez;

SET tez.queue.name=pr-*;

Then i was able to run my script successfully 😥