| |
| CREATE TEMPORARY TABLE temptable (key1 INT, value1 STRING) PARTITIONED BY (ds STRING, hr STRING); |
| |
| ALTER TABLE temptable ADD PARTITION (ds='2008-04-08', hr='3'); |
| ALTER TABLE temptable ADD PARTITION (ds='2008-04-08', hr='4'); |
| ALTER TABLE temptable ADD PARTITION (ds='2008-04-08', hr='5'); |
| ALTER TABLE temptable ADD PARTITION (ds='2008-04-09', hr='5'); |
| ALTER TABLE temptable ADD PARTITION (ds='2008-04-09', hr='6'); |
| ALTER TABLE temptable ADD PARTITION (ds='2008-04-10', hr='5'); |
| ALTER TABLE temptable ADD PARTITION (ds='2008-04-11', hr='5'); |
| |
| SHOW PARTITIONS temptable LIMIT 2; |
| SHOW PARTITIONS temptable PARTITION(ds='2008-04-08') LIMIT 2; |
| SHOW PARTITIONS temptable ORDER BY ds DESC, hr DESC; |
| SHOW PARTITIONS temptable ORDER BY ds DESC, hr DESC LIMIT 2; |
| SHOW PARTITIONS temptable WHERE ds > '2008-04-08' AND hr = '5'; |
| SHOW PARTITIONS temptable WHERE ds > '2008-04-08' AND hr = '5' ORDER BY ds DESC; |
| SHOW PARTITIONS temptable WHERE ds > '2008-04-08' AND hr = '5' ORDER BY ds DESC LIMIT 2; |
| SHOW PARTITIONS temptable WHERE ds > '2008-04-08' AND hr >= '5' ORDER BY ds DESC, hr ASC; |
| SHOW PARTITIONS temptable WHERE ds > '2008-04-08' AND hr >= '5' ORDER BY ds DESC, hr ASC LIMIT 2; |