Example : when we create a partition like create table............. partition by(age), and load the table on basis of age then i just want to know if i do select * from table; how it is giving me the data for all the students but as the table is partitioned by age it should give me the data related to partition.
If you want to query the data for specific partition then it should be part of the WHERE clause. Thanks
While loading data into the partition table how does it know that 3rd column in my textfile will be a "suppose i am partitioning with country" country becuase while creating a partition table like create table Stockmarket (namestock String,currency string,comp String) partitioned by (country String) row format delimited fields terminated by '\,' stored as textfile ; while loading this table like " load data local inpath '/user/himanshu/stock' into stockmarket partition(country);"
now my question is which column is it going to take as the country from the file,