No partition predicate found for Alias even when the partition predicate in present in the query No partition predicate found for Alias even when the partition predicate in present in the query hadoop hadoop

No partition predicate found for Alias even when the partition predicate in present in the query


hadoop hive cloudera hiveql hue

This happens because hive is set to strict mode.this allow the partition table to access the respective partition /folder in hdfs . 

  set hive.mapred.mode=unstrict;  it will work

hadoop hive cloudera hiveql hue

In your query error it is said: No partition predicate found for Alias "inv" Table "pos_inv".

So you must put the where clause for the fields of the partitioned table (for pos_inv), and not for the other one (inv), as you've done.

hadoop hive cloudera hiveql hue

set hive.mapred.mode=unstrict allows you access the whole data rather than the particular partitons. In some case read whole dataset is necessary, such as: rank() over

Recent Posts
How can I color dots in a xy scatterplot according to column value?
How to update a claim in ASP.NET Identity?
What does {0} mean when initializing an object?
Accessing members of items in a JSONArray with Java
How to log SQL statements in Spring Boot?
Powershell Get-WebSite name parameter is ignored
How to detect scroll to bottom of html element
Java synchronized method
How to test controllers with CodeIgniter?
Detect Visual Composer
Matplotlib: Specify format of floats for tick labels
Rails join a list of strings with commas and "and" before the last