Skip to content
Fresh news on big data, data science and cutting edge analytics!

The Analytics Journal

Fresh news on big data, data science and cutting edge analytics!

  • Home
  • About Me
  • Contact Me
Home > Posts tagged partition

Tag: partition

Hive: How to drop partitions by range

Posted on February 15, 2019 by admin

This is the general syntax for the drop partition syntax in Apache Hive:

 

ALTER TABLE table_name DROP [IF EXISTS] PARTITION partition_spec PURGE;

 

So the syntax to drop a range of partitions in a table that uses year as a partitioning column:

ALTER TABLE mytable DROP [IF EXISTS] PARTITION (year>2019) PURGE;

 

 

Posted in Apache HiveTagged by range, DDL, drop, Hive, partition, syntaxLeave a comment

Translate

The Analytics Journal Monthly

Enter your email address to receive summarized stories of the key developments in the big data, analytics and data science arena every month...

Join 6 other subscribers

RSS Feed

  • RSS - Posts

Topic Cloud

#OPN Ambari CentOS Error Error / Issue Solution Fusion Middleware GFS Hadoop Hadoop Ecosystem Hadoop Intall Hive Index install installation interface interview preparation interview questions JDK linkedin Linux / Unix Log Mining loopback nofp OBIEE OBIEE 11g ODI Oracle Oracle ODI patching Performance Tuning Plugins Product Review Python RDDs Ready Scala Spark sqoop syntax tutorial unique Update windows WIP Wordpress

Categories

  • Apache Hive
  • Apache Spark
  • Blogging
  • Business Intelligence Applications (OBIA)
  • Business Intelligence Foundation (BIF)
  • Career Tools
  • Ecosystem
  • Executive Leadership and Influence
  • Fundamentals
  • Hadoop – Technical
  • Job Search
  • LinkedIn
  • Open World
  • Oracle Analytics
  • Oracle Data Integrator (ODI)
  • Oracle Database
  • Technical
  • Uncategorized
  • Unix / Linux
Copyright 2017 © All right reserved by TheAnalyticsJournal.com Proudly powered by WordPress. | Theme: Speedy by eVisionThemes