https://community.cloudera.com/t5/Support-Questions/How-to-ask-hive-query-to-fetch-data-for-specific-partition/m-p/115206#M78000 <P>Hello everyone,</P><P>I have posted query below in which i have used 3 partition table and all are the external table pointing to some partition ditectory on hdfs.In every table partition is done on "ds" column(i.e. ds=2016-06-01-08).</P><P>ds=year-month-day-hour</P><P>On hourly basis data is landing on hdfs,creating directory as above timestamp and tables are pointing to all those partition directories.</P><P>A question is:</P><P>As already i explained all tables are partitioned,but </P><P>Where to write where clause in below query? so that data will be processed for that particular partition only.</P><P>Please let me know.</P><P>Query:</P><P>INSERT OVERWRITE TABLE falconexample.Patient_proce PARTITION (${falcon_output_partitions_hive}) select p.id,p.gender, p.Age, p.birthdate, o.component[1].valuequantity.value, o.component[1].valuequantity.unit from (select *, floor(datediff(to_date(from_unixtime(unix_timestamp())), to_date(birthdate)) / 365.25) as Age FROM falconexample. patient1) p inner join falconexample.DiagnosticReport1 d on p.id = substr(d.subject.reference,9) inner join falconexample.Observation1 o on p.id = substr(o.subject.reference,9) where p.Age&gt;17 and p.Age&lt;86 and o.component[1].valuequantity.value &lt;140;</P> Thu, 02 Jun 2016 00:23:52 GMT Manus 2016-06-02T00:23:52Z