i have a table with two string columns and one datetime column (which is also defined as string datatype). I want to partition the table on monthly basis ie month(the datetime column). So I did the below : create table test_part_tbl (id string, cd string, dttm string) partitioned by (mth string); insert into test_part_tbl partition(mth) select id, cd, create_dt, month(create_dt) from real_table; hive> select * from test_part_tbl ; OK test_part_tbl.id test_part_tbl.cd test_part_tbl.dttm test_part_tbl.mth id1 cd1 2018-10-24 10 id2 cd1 2018-10-24 10 Time taken: 0.13 seconds, Fetched: 2 row(s) So the month ie "10" is actually appearing as part of the table data. Is that correct? Is it possible to partition the table as above and not have the partition column/value as part of the table data? ie when querying can't I use "month(dttm)" and search based on month? Appreciate the insights.
... View more
